Query

  • I want generate a report of week user activites on a server.

    Please provide me the scripts.

  • 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

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • 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.

  • 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

  • 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.

  • 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


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply