Skip to content

Releases: blakedrumm/SCOM-Scripts-and-SQL

SCOM-DataCollector - v3.7.8

03 Jan 22:09
@blakedrumm blakedrumm
v-3.7.8
8b8adb5
This commit was created on GitHub.com and signed with GitHub’s verified signature. The key has expired.
GPG key ID: 4AEE18F83AFDEB23
Expired
Verified
Learn about vigilant mode.
Compare
Choose a tag to compare
SCOM-DataCollector - v3.7.8

New / Updated SQL Queries

  • New OpsDB Query: Alerts_ByOldest.sql
  • Updated Query: Alerts_ByRepeat.sql
  • Added more information to Query: ConfigChurn_OpsDB.sql

Additions

  • Added ability to gather Reporting Version when SSRS detected, the output is in General Information.

Download Count v3.7.8

Assets 3
Loading

SCOM-DataCollector - v3.7.7

14 Dec 20:56
@blakedrumm blakedrumm
v-3.7.7
6df0bea
This commit was created on GitHub.com and signed with GitHub’s verified signature. The key has expired.
GPG key ID: 4AEE18F83AFDEB23
Expired
Verified
Learn about vigilant mode.
Compare
Choose a tag to compare
SCOM-DataCollector - v3.7.7

Additions

  • Added SQL Timeout information in the output of the console when running the script.
  • Added Event* to the list of SQL Queries PowerShell Jobs.

Bug Fixes

  • Fixed the PowerShell Jobs for SQL Queries, there will now be output for the files.
  • Fixed the questions you get asked when running the SQL Queries without -AssumeYes or -Yes.
  • Fixed installed software gathering.
  • Other minor bugfixes.

Download Count v3.7.7

Assets 3
Loading

SCOM-DataCollector - v3.7.6

07 Dec 06:28
@blakedrumm blakedrumm
v-3.7.6
3ebddb8
This commit was created on GitHub.com and signed with GitHub’s verified signature. The key has expired.
GPG key ID: 4AEE18F83AFDEB23
Expired
Verified
Learn about vigilant mode.
Compare
Choose a tag to compare
SCOM-DataCollector - v3.7.6
  • Removed -MSInfo32 Switch from the -All switch, as the Data Collection was taking too long and this data isn't used in every case. The data can still be gathered with -MSInfo32. Example: .\DataCollector -All -MSInfo32
  • Updated the MaintenanceMode.sql query to include IsInMaintenanceMode data.
  • Updated the UNIX_Agents.sql query to include FullName and DisplayName columns.
  • Added better error handling for script execution.
  • New argument -ManagementServers, you can now gather from specific Management Servers!
  • New argument -NoSQLQueries, you don't have to execute the SQL Queries!
  • Added ability to run jobs for SQL Queries that have Perf in the name!
  • Added new information to the General Information Text File, it now gathers AgentManagement information and SCOM 2019 UR3 Hotfix specific information.
  • Fixed Get-SCOMPendingManagement gathering for remote management servers.
  • Updated SQL internal version list.
  • Updated Events_ByComputer.sql to include the Rule. Thank you Alex K!
  • Major Update!

Download Count v3.7.6

Assets 3
Loading

SCOM-DataCollector - v3.7.5

14 Oct 12:05
@blakedrumm blakedrumm
v-3.7.5
8b77583
This commit was created on GitHub.com and signed with GitHub’s verified signature. The key has expired.
GPG key ID: 4AEE18F83AFDEB23
Expired
Verified
Learn about vigilant mode.
Compare
Choose a tag to compare
SCOM-DataCollector - v3.7.5
  • Fixed bug with Server Checker.
  • Fixed query for HealthService_Pending.sql, thank you Lorne!

Download Count v3.7.5

Assets 3
Loading

SCOM-DataCollector - v3.7.4

21 Sep 06:49
@blakedrumm blakedrumm
v-3.7.4
4eb0ff6
This commit was created on GitHub.com and signed with GitHub’s verified signature. The key has expired.
GPG key ID: 4AEE18F83AFDEB23
Expired
Verified
Learn about vigilant mode.
Compare
Choose a tag to compare
SCOM-DataCollector - v3.7.4
  • Fixed bug with General Information gathering. Everything should be working as intended now!

Download Count v3.7.4

Assets 3
Loading

SCOM-DataCollector - v3.7.3

16 Sep 05:36
@blakedrumm blakedrumm
v-3.7.3
afbebd0
This commit was created on GitHub.com and signed with GitHub’s verified signature. The key has expired.
GPG key ID: 4AEE18F83AFDEB23
Expired
Verified
Learn about vigilant mode.
Compare
Choose a tag to compare
SCOM-DataCollector - v3.7.3
  • SQL Queries: Replaced Where with Filter in SQL Queries Function.
  • Added new switch -GetSPN which will gather the SPN information from Active Directory for all the Management Servers and SQL Server as well as any servers defined with the -Servers switch.
ComputerName ServiceClass      sAMAccountName distinguishedName                              whenChanged           SPN                                     
------------ ------------      -------------- -----------------                              -----------           ---                                     
MS01-2019    HOST              MS01-2019$     CN=MS01-2019,CN=Computers,DC=contoso,DC=com    9/16/2021 12:25:14 AM HOST/MS01-2019.contoso.com              
MS01-2019    HOST              MS01-2019$     CN=MS01-2019,CN=Computers,DC=contoso,DC=com    9/16/2021 12:25:14 AM HOST/MS01-2019                          
MS01-2019    MSOMHSvc          MS01-2019$     CN=MS01-2019,CN=Computers,DC=contoso,DC=com    9/16/2021 12:25:14 AM MSOMHSvc/MS01-2019                      
MS01-2019    MSOMHSvc          MS01-2019$     CN=MS01-2019,CN=Computers,DC=contoso,DC=com    9/16/2021 12:25:14 AM MSOMHSvc/MS01-2019.contoso.com          
MS01-2019    MSOMSdkSvc        OMDAS          CN=OMDAS,OU=Service Accounts,DC=contoso,DC=com 9/15/2021 11:24:46 PM MSOMSdkSvc/MS01-2019.contoso.com        
MS01-2019    MSOMSdkSvc        OMDAS          CN=OMDAS,OU=Service Accounts,DC=contoso,DC=com 9/15/2021 11:24:46 PM MSOMSdkSvc/MS01-2019                    
MS01-2019    RestrictedKrbHost MS01-2019$     CN=MS01-2019,CN=Computers,DC=contoso,DC=com    9/16/2021 12:25:14 AM RestrictedKrbHost/MS01-2019             
MS01-2019    RestrictedKrbHost MS01-2019$     CN=MS01-2019,CN=Computers,DC=contoso,DC=com    9/16/2021 12:25:14 AM RestrictedKrbHost/MS01-2019.contoso.com 
MS01-2019    TERMSRV           MS01-2019$     CN=MS01-2019,CN=Computers,DC=contoso,DC=com    9/16/2021 12:25:14 AM TERMSRV/MS01-2019                       
MS01-2019    TERMSRV           MS01-2019$     CN=MS01-2019,CN=Computers,DC=contoso,DC=com    9/16/2021 12:25:14 AM TERMSRV/MS01-2019.contoso.com           
MS01-2019    WSMAN             MS01-2019$     CN=MS01-2019,CN=Computers,DC=contoso,DC=com    9/16/2021 12:25:14 AM WSMAN/MS01-2019                         
MS01-2019    WSMAN             MS01-2019$     CN=MS01-2019,CN=Computers,DC=contoso,DC=com    9/16/2021 12:25:14 AM WSMAN/MS01-2019.contoso.com             
MS02-2019    HOST              MS02-2019$     CN=MS02-2019,CN=Computers,DC=contoso,DC=com    9/16/2021 12:34:46 AM HOST/MS02-2019                          
MS02-2019    HOST              MS02-2019$     CN=MS02-2019,CN=Computers,DC=contoso,DC=com    9/16/2021 12:34:46 AM HOST/MS02-2019.contoso.com              
MS02-2019    MSOMHSvc          MS02-2019$     CN=MS02-2019,CN=Computers,DC=contoso,DC=com    9/16/2021 12:34:46 AM MSOMHSvc/MS02-2019                      
MS02-2019    MSOMHSvc          MS02-2019$     CN=MS02-2019,CN=Computers,DC=contoso,DC=com    9/16/2021 12:34:46 AM MSOMHSvc/MS02-2019.contoso.com          
MS02-2019    RestrictedKrbHost MS02-2019$     CN=MS02-2019,CN=Computers,DC=contoso,DC=com    9/16/2021 12:34:46 AM RestrictedKrbHost/MS02-2019.contoso.com 
MS02-2019    RestrictedKrbHost MS02-2019$     CN=MS02-2019,CN=Computers,DC=contoso,DC=com    9/16/2021 12:34:46 AM RestrictedKrbHost/MS02-2019             
MS02-2019    TERMSRV           MS02-2019$     CN=MS02-2019,CN=Computers,DC=contoso,DC=com    9/16/2021 12:34:46 AM TERMSRV/MS02-2019.contoso.com           
MS02-2019    TERMSRV           MS02-2019$     CN=MS02-2019,CN=Computers,DC=contoso,DC=com    9/16/2021 12:34:46 AM TERMSRV/MS02-2019                       
MS02-2019    WSMAN             MS02-2019$     CN=MS02-2019,CN=Computers,DC=contoso,DC=com    9/16/2021 12:34:46 AM WSMAN/MS02-2019                         
MS02-2019    WSMAN             MS02-2019$     CN=MS02-2019,CN=Computers,DC=contoso,DC=com    9/16/2021 12:34:46 AM WSMAN/MS02-2019.contoso.com             
MS03-2019    HOST              MS03-2019$     CN=MS03-2019,CN=Computers,DC=contoso,DC=com    9/6/2021 12:31:51 AM  HOST/MS03-2019.contoso.com              
MS03-2019    HOST              MS03-2019$     CN=MS03-2019,CN=Computers,DC=contoso,DC=com    9/6/2021 12:31:51 AM  HOST/MS03-2019                          
MS03-2019    MSOMHSvc          MS03-2019$     CN=MS03-2019,CN=Computers,DC=contoso,DC=com    9/6/2021 12:31:51 AM  MSOMHSvc/MS03-2019.contoso.com          
MS03-2019    MSOMHSvc          MS03-2019$     CN=MS03-2019,CN=Computers,DC=contoso,DC=com    9/6/2021 12:31:51 AM  MSOMHSvc/MS03-2019                      
MS03-2019    RestrictedKrbHost MS03-2019$     CN=MS03-2019,CN=Computers,DC=contoso,DC=com    9/6/2021 12:31:51 AM  RestrictedKrbHost/MS03-2019.contoso.com 
MS03-2019    RestrictedKrbHost MS03-2019$     CN=MS03-2019,CN=Computers,DC=contoso,DC=com    9/6/2021 12:31:51 AM  RestrictedKrbHost/MS03-2019             
MS03-2019    TERMSRV           MS03-2019$     CN=MS03-2019,CN=Computers,DC=contoso,DC=com    9/6/2021 12:31:51 AM  TERMSRV/MS03-2019.contoso.com           
MS03-2019    TERMSRV           MS03-2019$     CN=MS03-2019,CN=Computers,DC=contoso,DC=com    9/6/2021 12:31:51 AM  TERMSRV/MS03-2019                       
MS03-2019    WSMAN             MS03-2019$     CN=MS03-2019,CN=Computers,DC=contoso,DC=com    9/6/2021 12:31:51 AM  WSMAN/MS03-2019.contoso.com             
MS03-2019    WSMAN             MS03-2019$     CN=MS03-2019,CN=Computers,DC=contoso,DC=com    9/6/2021 12:31:51 AM  WSMAN/MS03-2019                         
MSSQL-2019   HOST              MSSQL-2019$    CN=MSSQL-2019,CN=Computers,DC=contoso,DC=com   9/16/2021 12:11:51 AM HOST/MSSQL-2019                         
MSSQL-2019   HOST              MSSQL-2019$    CN=MSSQL-2019,CN=Computers,DC=contoso,DC=com   9/16/2021 12:11:51 AM HOST/MSSQL-2019.contoso.com             
MSSQL-2019   RestrictedKrbHost MSSQL-2019$    CN=MSSQL-2019,CN=Computers,DC=contoso,DC=com   9/16/2021 12:11:51 AM RestrictedKrbHost/MSSQL-2019.contoso.com
MSSQL-2019   RestrictedKrbHost MSSQL-2019$    CN=MSSQL-2019,CN=Computers,DC=contoso,DC=com   9/16/2021 12:11:51 AM RestrictedKrbHost/MSSQL-2019            
MSSQL-2019   TERMSRV           MSSQL-2019$    CN=MSSQL-2019,CN=Computers,DC=contoso,DC=com   9/16/2021 12:11:51 AM TERMSRV/MSSQL-2019                      
MSSQL-2019   TERMSRV           MSSQL-2019$    CN=MSSQL-2019,CN=Computers,DC=contoso,DC=com   9/16/2021 12:11:51 AM TERMSRV/MSSQL-2019.contoso.com          
MSSQL-2019   WSMAN             MSSQL-2019$    CN=MSSQL-2019,CN=Computers,DC=contoso,DC=com   9/16/2021 12:11:51 AM WSMAN/MSSQL-2019                        
MSSQL-2019   WSMAN             MSSQL-2019$    CN=MSSQL-2019,CN=Computers,DC=contoso,DC=com   9/16/2021 12:11:51 AM WSMAN/MSSQL-2019.contoso.com
  • Updated General Information Output to have the correct version formatting for Current Version on Remote Servers.
  • Fixed formatting of the configuration registry data ..\Management Server Config\*, looks much better.
  • Small update to -GetRulesAndMonitors switch for formatting.
  • Updated the Output Zip file name to include the hour and minute as well as AM or PM: SDC_Results_09_16_2021_02-25-AM.zip
  • Other small changes.

Download Count v3.7.3

Assets 3
Loading

SCOM-DataCollector - v3.7.2

08 Sep 05:55
@blakedrumm blakedrumm
v-3.7.2
ba206d1
This commit was created on GitHub.com and signed with GitHub’s verified signature. The key has expired.
GPG key ID: 4AEE18F83AFDEB23
Expired
Verified
Learn about vigilant mode.
Compare
Choose a tag to compare
SCOM-DataCollector - v3.7.2
  • Added Switch: -GetInstalledSoftware which will allow you to gather software installed.
  • Resolved issue with MG Health Overview Output to CSV.
  • Added Broken_Relationships.sql and updated Orphaned.sql. - Thanks Brook Hudson!
  • Fixed issue with Management Servers that were removed from the Server array list still having the Data attempt to be gathered. This should result in much less errors in the Data Collector if a Management Server is not responding.
  • New Log File Created if there is an issue with Connectivity to a Management Server: Error.log
  • Added ability to gather from SQL Replica Nodes from SCOM SQL DB.

Download Count v3.7.2

Assets 3
Loading

SCOM-DataCollector - v3.7.1

31 Aug 00:51
@blakedrumm blakedrumm
v-3.7.1
9c09048
This commit was created on GitHub.com and signed with GitHub’s verified signature. The key has expired.
GPG key ID: 4AEE18F83AFDEB23
Expired
Verified
Learn about vigilant mode.
Compare
Choose a tag to compare
SCOM-DataCollector - v3.7.1

  • Edited the following SQL Query: MG_ResourcePools.sql to include the Membership Type. Thank you Alex Kremenetskiy for assisting me with this query!
    image

  • Fix Check Configuration step of Data Collection to error handle for Management Servers that are not accessible.

  • Added ability to gather Replica Nodes for a SQL Cluster. This will allow the Data Collector to connect to each SQL Node and gather SQL Error Logs in future versions of the Data Collector. SQL Query: SQL_Primary_Replicas_OpsMgr.sql and SQL_Primary_Replicas_DW.sql.

  • Added User Mapping, to allow us to detect the current set user mappings. SQL_UserMapping_OpsDB.sql and SQL_UserMapping_DW.sql.
    image

  • Added ability to gather RunAsAccounts, new query against Operations Manager DB: RunAsAccounts_OpsDB.sql
    image

Download Count v3.7.1

Assets 3
Loading

SCOM-DataCollector - v3.7.0

27 Aug 08:23
@blakedrumm blakedrumm
v-3.7.0
361bc0f
This commit was created on GitHub.com and signed with GitHub’s verified signature. The key has expired.
GPG key ID: 4AEE18F83AFDEB23
Expired
Verified
Learn about vigilant mode.
Compare
Choose a tag to compare
SCOM-DataCollector - v3.7.0
  • Major rewrite to the General Information Function. There is much better structure for that function now.
  • Increased Timeout for SQL Queries to 15 minutes.
  • New Data added to General Information Function, you can now see the Agent Action Account and the other relevant Management Group information for Agent Servers.
  • Other small changes.

Download Count v3.7.0

Assets 3
Loading

SCOM-DataCollector - v3.6.9

26 Aug 05:49
@blakedrumm blakedrumm
v-3.6.9
83c82b9
This commit was created on GitHub.com and signed with GitHub’s verified signature. The key has expired.
GPG key ID: 4AEE18F83AFDEB23
Expired
Verified
Learn about vigilant mode.
Compare
Choose a tag to compare
SCOM-DataCollector - v3.6.9
  • Modified all of the SQL Queries to include the following string if there are any references to non view tables: WITH(NOLOCK)
    The Data Collector should no longer lock the tables when querying data.

Download Count v3.6.9

Assets 3
Loading