Building a monitoring server with power shell RRS feed

  • Question

  • With interest i read  the article  : https://www.red-gate.com/simple-talk/sql/database-administration/create-a-monitoring-server-for-sql-server-with-powershell/

    I have two instances  of database  sql server in my  SQL SERVER :

    \\.\root\Microsoft\SqlServer\ServerEvents\MSSQLSERVER (Instance DEFAULT)

    \\.\root\Microsoft\SqlServer\ServerEvents\INST1 (Instance INST1)

    I want to build a monitoring server   for users access to a SQL SERVER, i want the server to capture users logon time, activities within the database.

    I want a system that captures user activities  within the database.

    Could someone put me through on the usage.  I mean sample codes  

    Tuesday, August 29, 2017 12:49 PM

All replies

  • WOW, another post about monitoring SQL server and asking for the same activities.....we do not write scripts here, please look at the other posts right on the front page asking the same thing as you are.

    If you find that my post has answered your question, please mark it as the answer. If you find my post to be helpful in anyway, please click vote as helpful. (99,108,97,121,109,97,110,50,64,110,121,99,97,112,46,114,114,46,99,111,109|%{[char]$_})-join''

    Tuesday, August 29, 2017 1:25 PM
  • Please do not keep posting the same question multiple time.  It will not get you an answer.


    Tuesday, August 29, 2017 4:40 PM