locked
Aduit Report RRS feed

  • Question

  • Hi Friends,

    i need your help in generating Aduit Report. My Manager want to generate report with below columns from Systables


    SERVER NAME   DB NAME            Login                     UserTitle                       Service Account                Role

    Madison               Appli                     hel436                  DBA                                           Y or  N                            SA      

     

    Any help is use ful    

     


    • Edited by maddy28 Friday, October 7, 2011 8:37 AM
    Friday, October 7, 2011 8:36 AM

Answers

All replies

  • It is not very clear whe this report is supposed to include. "UserTitle" sounds like something you would have to look from an Employees table - that is not information stored in SQL Server.

    "Role" is another one. SQL Server has roles, but a user can belong to many roles. But "SA" is not a role, so maybe this the role within the organisation?

    "Service Account" also calls for clarification. With the "Service account" one usually means the Windows account under which SQL Server runs under. But what is meant here?


    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
    Friday, October 7, 2011 10:13 PM
  • I completely agree with Erland. The first three columns are easily achieveable. The rest three are not clear. If you are having some usertable which holds the usertitle then probably u can use some logic to get it. There are many ways to achieve auditing. Which version of SQL Server are you using?
    Thanks & Regards, Manjunath C Bhat, http://manjunathcbhat.blogspot.com http://manjunathcbhat.wordpress.com
    Monday, October 10, 2011 6:24 AM
  • Hi Maddy

    You check following link. Its Quite Similar to Your Question.

    http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/b0ee6b97-358e-4e1d-b6f1-681f33757485


    Mark as Answer If Reply Was Helpful
    Thanks
    Kuldeep Bisht
    Technical Lead @ Simplion Technologies
    Blog : www.dbsimplified.com
    • Marked as answer by Stephanie Lv Friday, October 14, 2011 1:28 PM
    Monday, October 10, 2011 6:40 AM