October 19, 2011 at 4:03 pm
I want generate a report of week user activites on a server.
Please provide me the scripts.
October 19, 2011 at 4:17 pm
If this is not a home work assignment, my fee for supplying what you requested is 60.00 U.S. Dollars, with a minimum of $300.00. If it is a homework problem, tell us what you have tried to data.
Suggestion - use GOOGLE and lookup LOGIN TRIGGERS
October 19, 2011 at 4:33 pm
You haven't well explained what you are looking for, nor have you attempted anything. We are here to help, and happy to help. We are not here to do all the work for you.
Please make an attempt yourself, but first think about what you mean by "week user activities"". That's not well defined.
October 20, 2011 at 5:40 am
Do you mean every single action taken by the users for a week? You'll need to capture all events. I'd suggest looking up how to use extended events for that, but you're going to be collecting a whole lot of data and it's going to require you to manage all that information and then query the XML output. Best thing to do would be to get a better understanding of what exactly you're looking for.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 21, 2011 at 1:23 pm
Oh, I'll happily give you an answer: Enable Change Data Capture.
Price List
Answers: $1
Correct Answers: $5
As Always, Dumb Looks are Free of Charge
You could also buy a 3rd party vendor product. I'm familiar with Quest, but there are others.
October 21, 2011 at 5:28 pm
Mvs2k11 (10/19/2011)
I want generate a report of week user activites on a server.Please provide me the scripts.
I know it's probably just a problem with the language barrier, but you really need to learn how to ask a question. In the meantime, you could probably get to where you need to be by reading the following articles and modifying the code it contains to report on weekly data. 😉
http://www.sqlservercentral.com/articles/T-SQL/63681/
http://www.sqlservercentral.com/articles/Crosstab/65048/
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply