MSSQL Query (Local)

(4 votes, average: 3.75 out of 5)

Loading...

This script can monitoring a SqlServer using MSSQL Querys. 

Example: 

"<PowershellPATH>powershell.exe" querysql.ps1 -H hostname(optional) -U username(optional) -P password(optional) -Q 'MSSQL Query' 

If you run as Administrator the script, and your sql account has permissions too, this is the execution: 

"<PowershellPATH>powershell.exe" querysql.ps1 -Q 'MSSQL Query' 

Module data

module_begin 
module_name SQL Query 
module_type generic_data or generic_data_string 
module_exec "<PowershellPATH>powershell.exe" querysql.ps1 -H hostname(optional) -U username(optional) -P password(optional) -Q 'MSSQL Query' 
module_end

Files:

querysql.ps1