Powershell or WMI for sql server users monitoring RRS feed

  • Question

  • This is the scenario of my research work : I have twenty active directory accounts  that makes use of a central database (their accounts had been registered with the sql server database). The active directory users, edits and deletes data within the database.

    I want to write a script to monitor sql server event logins scenario for each  Active Directory accounts . I want the script to capture the time the users login into the database, the tables  they edited, and every events associated  with EACH ACTIVE DIRECTORY USER.

    Could someone give me a hint on how to go about it, possible weblinks and sources would do.

    What am looking for is this : WMI for auditing Active directory, want to track
    users that logs into sql server database.
    I want to audit the time they log into the database, what they do in the database.

    BASICALLY SQL SERVER MONITORY....any codes or links  pls

    • Moved by Bill_Stewart Monday, October 2, 2017 10:00 PM Unanswerable drive-by question
    Wednesday, August 30, 2017 7:35 AM

All replies