Skip to content

SCOM-DataCollector - v3.7.3

Compare
Choose a tag to compare
@blakedrumm blakedrumm released this 16 Sep 05:36
· 855 commits to master since this release
afbebd0
  • 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