Results 1 to 4 of 4

Thread: System Report

  1. #1
    Join Date
    Jan 2005
    Posts
    3

    Unanswered: System Report

    Hi all,

    How can i generate automated response from the server which provides me whole weekly sysetem report which contains, system up time, errors, how many login attemps, IO information,


    Please help me.

    thanks

  2. #2
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    you want to roll your own? i think there are plenty of 3rd party tools for this stuff.

    if you want to do your own thing, you could use xp_readerrorlog to parse the sql logs, that might be a start.

  3. #3
    Join Date
    Jan 2005
    Posts
    3
    yes want to create own and need system uptime in hours, login attemps, success and failures count, and other system information.

    also need weekly report so I have no clue how to generate that report!!

    please advise

  4. #4
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    I did advise already. You can use xp_readerrorlog to parse the sql logs.

Posting Permissions

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