SCOM 2012 R2 Data warehouse command to get information on Various Tables and how much space they are talking

SCOM 2012 R2 Data warehouse command to get information on Various Tables and how much space they are talking

• SCOM Data warehouse is the one where we store all data for longtime.
• Usually this will be in terabytes of data and will fill very fast if not confiureged properly
• Most offten you can see that the Datawarehouse if Full or going to be full and you want to find out what is the configuration and which Table is taking the most data
• Microsoft has pushed a command line tool in SCOM 2012 R2 called dwdatarp.exe
•  To get the list of tables using more space and configuration use the below command

dwdatarp.exe -s SQLServer\DatabaseName -d OperationsManagerDW > c:\dwoutput.txt

• This will give you the output with Space used and the How many days of data is stored.

SCOM Data access Service and Config Service failing to start after recent SCCM Patching

SCOM Data access Service and Config Service failing to start after recent SCCM Patching

• After recent SCCM patching window where the SCOM servers got patched, i got a call from support team that the SCOM Data access service (SDK service) and Config Service are not starting.
• Further investigation revealed that a particular patch KB2677070 was causing the issue as it was trying to access the intenet to check on revoked trusted certificates.
• As most corporate enviorment internet is blocked from prouction servers this started faining can caused the service not to start.
• After uninstall the patch and reboot the server, the services started without any issue.
• Another solution is that you have go to th registry
• HKLM\Software\Policies\Microsoft\SystemCertificates
• Right-click AuthRoot, select New, and then click DWORD.
• Type DisableRootAutoUpdate, and then press Enter.
• Right-click DisableRootAutoUpdate, and then click Modify.
• In the Value data box, type 1, and then click OK.