https://jimetrics.com/ 2026-05-04T08:08:00-0500 https://jimetrics.com/ https://jimetrics.com/lib/tpl/dokuwiki/images/favicon.ico text/html 2018-05-14T22:00:13-0500 Anonymous (anonymous@undisclosed.example.com) https://jimetrics.com/doku.php?id=windows:powershell:insertdbfilestats&rev=1526353213&do=diff Here is a PowerShell script to gather SQL Server database file information such as names, size, size used, max size, growth property (percentage or not). Please create a SQL Server Agent job for this. The domain account that this job runs under needs to have access to the instances. text/html 2018-05-14T22:00:13-0500 Anonymous (anonymous@undisclosed.example.com) https://jimetrics.com/doku.php?id=windows:powershell:insertinstance&rev=1526353213&do=diff Here is a PowerShell script to discover SQL Server instances installed on the server hosts in the Host table. Please create a SQL Server Agent job for this. The domain account that this job runs under needs to in the local administrator's group on the host whose metrics it is trying to get. text/html 2018-05-14T22:00:13-0500 Anonymous (anonymous@undisclosed.example.com) https://jimetrics.com/doku.php?id=windows:powershell:insertinstanceconfig&rev=1526353213&do=diff Here is a PowerShell script to gather SQL Server instance configuration information. It comes from sys.configurations view. Please create a SQL Server Agent job for this. The domain account that this job runs under needs to have proper access to the instances in question and be able to insert data into the JiMetrics database. text/html 2018-05-14T22:00:13-0500 Anonymous (anonymous@undisclosed.example.com) https://jimetrics.com/doku.php?id=windows:powershell:insertinstancedmvperfcounter&rev=1526353213&do=diff Here is a PowerShell script to gather selectedSQL Server instance performance counters. The data comes from sys.dm_os_performance_counters view. Please create a SQL Server Agent job for this. The domain account that this job runs under needs to have proper access to the instances in question and be able to insert data into the JiMetrics database. text/html 2018-05-14T22:00:13-0500 Anonymous (anonymous@undisclosed.example.com) https://jimetrics.com/doku.php?id=windows:powershell:insertstorage&rev=1526353213&do=diff Here is a PowerShell script to gather Windows host disk info such as disk label, drive letter, total size, free size. Please create a SQL Server Agent job for this. The domain account that this job runs under needs to in the local administrator's group on the host whose metrics it is trying to get. text/html 2018-05-14T22:00:13-0500 Anonymous (anonymous@undisclosed.example.com) https://jimetrics.com/doku.php?id=windows:powershell:inserttablestats&rev=1526353213&do=diff Here is a PowerShell script to gather SQL Server database table information such as database name, schema name, table name, row count, data size, index size. Please create a SQL Server Agent job for this. The domain account that this job runs under needs to have access to the instances. text/html 2018-05-14T22:00:13-0500 Anonymous (anonymous@undisclosed.example.com) https://jimetrics.com/doku.php?id=windows:powershell:powershellstart&rev=1526353213&do=diff PowerShell is Microsoft's scripting language/shell that comes with Windows server and desktop per-installed nowadays. It has tight integration with the operating system and Microsoft's various server products. For automating tasks on Windows, it is a pretty compelling choice because of this bundling. text/html 2018-05-14T22:00:13-0500 Anonymous (anonymous@undisclosed.example.com) https://jimetrics.com/doku.php?id=windows:powershell:updatehost&rev=1526353213&do=diff Here is a PowerShell script to gather Windows host info such as OS version, hardware model, memory size, CPU type, core count, BIOS version, BIOS release date, Host hardware serial number. Please create a SQL Server Agent job for this. The domain account that this job runs under needs to in the local administrator's group on the host whose metrics it is trying to get. text/html 2018-05-14T22:00:13-0500 Anonymous (anonymous@undisclosed.example.com) https://jimetrics.com/doku.php?id=windows:powershell:updateinstance&rev=1526353213&do=diff After server host SQl Server instance(s) have been discovered, here is a PowerShell script to update those instances with information like SQL Server edition, product version, service pack level, etc. Please create a SQL Server Agent job for this. The domain account that this job runs under needs to have access to the instances.