{"id":1585,"date":"2017-12-18T09:20:03","date_gmt":"2017-12-18T09:20:03","guid":{"rendered":"https:\/\/pandorafms.com\/library\/?p=1585"},"modified":"2024-03-05T12:50:35","modified_gmt":"2024-03-05T11:50:35","slug":"mssql-query-local","status":"publish","type":"post","link":"https:\/\/pandorafms.com\/library\/mssql-query-local\/","title":{"rendered":"MSSQL Query (Local)"},"content":{"rendered":"

[et_pb_section fb_built=”1″ _builder_version=”4.16″ global_colors_info=”{}”][et_pb_row _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”]<\/p>\n

\n <\/p>\n

Important Notice:<\/strong> This plugin is no longer actively maintained or updated. We strongly advise you to explore alternative plugins available in our library for the latest features and support.<\/p>\n<\/div>\n

<\/p>\n

This script can monitoring a SqlServer using MSSQL Querys.\u00a0<\/p>\n

Example:\u00a0<\/p>\n

\"<PowershellPATH>powershell.exe\" querysql.ps1 -H hostname(optional) -U username(optional) -P password(optional) -Q 'MSSQL Query'\u00a0<\/pre>\n
If you run as Administrator the script, and your sql account has permissions too, this is the execution:\u00a0<\/p>\n
\"<PowershellPATH>powershell.exe\" querysql.ps1 -Q 'MSSQL Query'\u00a0<\/pre>\n
Module data<\/h2>\n
module_begin\u00a0\r\nmodule_name SQL Query\u00a0\r\nmodule_type generic_data or generic_data_string\u00a0\r\nmodule_exec \"<PowershellPATH>powershell.exe\" querysql.ps1 -H hostname(optional) -U username(optional) -P password(optional) -Q 'MSSQL Query'\u00a0\r\nmodule_end<\/pre>\n
Files:<\/h2>\n
querysql.ps1<\/a>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"
Important Notice: This plugin is no longer actively maintained or updated. We strongly advise you to explore alternative plugins available in our library for the latest features and support. This script can monitoring a SqlServer using MSSQL Querys.\u00a0 Example:\u00a0 “<PowershellPATH>powershell.exe” querysql.ps1 -H hostname(optional) -U username(optional) -P password(optional) -Q ‘MSSQL Query’\u00a0 If you run as Administrator […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"
\r\n  \r\n  
Important Notice:<\/strong> This plugin is no longer actively maintained or updated. We strongly advise you to explore alternative plugins available in our library for the latest features and support.
\r\n<\/div>\r\n\r\n
\r\n\r\nThis script can monitoring a SqlServer using MSSQL Querys.\u00a0\r\n\r\nExample:\u00a0\r\n
\"powershell.exe\" querysql.ps1 -H hostname(optional) -U username(optional) -P password(optional) -Q 'MSSQL Query'\u00a0<\/pre>\r\n\r\nIf you run as Administrator the script, and your sql account has permissions too, this is the execution:\u00a0\r\n\r\n
\"powershell.exe\" querysql.ps1 -Q 'MSSQL Query'\u00a0<\/pre>\r\n\r\n\r\n\r\n
Module data<\/h2>\r\n
module_begin\u00a0\r\nmodule_name SQL Query\u00a0\r\nmodule_type generic_data or generic_data_string\u00a0\r\nmodule_exec \"powershell.exe\" querysql.ps1 -H hostname(optional) -U username(optional) -P password(optional) -Q 'MSSQL Query'\u00a0\r\nmodule_end<\/pre>\r\n
Files:<\/h2>\r\nquerysql.ps1<\/a>","_et_gb_content_width":"","footnotes":""},"categories":[24],"tags":[199,559],"_links":{"self":[{"href":"https:\/\/pandorafms.com\/library\/wp-json\/wp\/v2\/posts\/1585"}],"collection":[{"href":"https:\/\/pandorafms.com\/library\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pandorafms.com\/library\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pandorafms.com\/library\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/pandorafms.com\/library\/wp-json\/wp\/v2\/comments?post=1585"}],"version-history":[{"count":2,"href":"https:\/\/pandorafms.com\/library\/wp-json\/wp\/v2\/posts\/1585\/revisions"}],"predecessor-version":[{"id":8414,"href":"https:\/\/pandorafms.com\/library\/wp-json\/wp\/v2\/posts\/1585\/revisions\/8414"}],"wp:attachment":[{"href":"https:\/\/pandorafms.com\/library\/wp-json\/wp\/v2\/media?parent=1585"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pandorafms.com\/library\/wp-json\/wp\/v2\/categories?post=1585"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pandorafms.com\/library\/wp-json\/wp\/v2\/tags?post=1585"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}