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
    Tuesday, August 29, 2017 11:45 AM


All replies