System Center Guide and Tutorial

Tuesday, 25 August 2015

Microsoft has released a pretty cool dashboard in recent SQL 2012 MP.
It gives awesome dashbaord view for the team to Monitoring and know you database perforamnce from single console
To Download latest MP click here --> Download

Get-SCOMaccesLicense where DEVICE_ID "Computername"
This will give you information whether the server is Virtual or Physical.Its agent managed or Agentless Managed.

Earlier to Jump Between different Application we have to Minimize one and maximize one.
Then we started using ALT+TAB button to switch between different Application windows
Now Microsoft has given a button next to Search Box in Windows 10
If you Click on it You can jump between various windows.
This has been done to make compaitable with Windows Tab (Surface) and Windows Phone

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

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

Manytime we get request from application owners who request for list of patches instaled and on what date
You can use the below command to get the list of Patches from the server. This will Create a html file called hotfix.html in your C: drive.