Results 1 to 3 of 3

Thread: database usage report

  1. 05-22-2002, 07:43 AM #1
    Sri Guest

    database usage report

    Hi,

    I have a requirement to create a Database usage report. The report should have - userid, user name, login time, database to which he has logged in, log out time, host machine id.

    How do I go about generating this type of report. What system tables are to be refered?

    Please help.

    Thanks
    Sri
    Reply With Quote Reply With Quote
  2. 05-22-2002, 08:21 AM #2
    MAK Guest

    database usage report (reply)

    Run SQL Profiler.
    It will give u a complete detail of everything


    ------------
    Sri at 5/22/2002 8:43:42 AM

    Hi,

    I have a requirement to create a Database usage report. The report should have - userid, user name, login time, database to which he has logged in, log out time, host machine id.

    How do I go about generating this type of report. What system tables are to be refered?

    Please help.

    Thanks
    Sri
    Reply With Quote Reply With Quote
  3. 05-28-2002, 10:28 AM #3
    Venu Guest

    database usage report (reply)

    Refer to SysProcesses table in the Master database.. You have all the info in this...

    Hope this Helps..
    Venu


    ------------
    Sri at 5/22/2002 8:43:42 AM

    Hi,

    I have a requirement to create a Database usage report. The report should have - userid, user name, login time, database to which he has logged in, log out time, host machine id.

    How do I go about generating this type of report. What system tables are to be refered?

    Please help.

    Thanks
    Sri
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules