SCCM Query find All Server count with OS Name

SCCM Query find All Server count with OS Name

• Recently I was asked to count of servers by OS
• It was quite Challenging as we need to understand the SCCM Structure very well to do the SQL Queries.
• Following are the Queries to fin the Server by OS Name and the count of Servers

SELECT VR.operatingSystem0,COUNT(VR.operatingSystem0) FROM v_R_System AS VR

WHERE VR.operatingSystem0 LIKE '%Windows Server%'

GROUP BY VR.operatingSystem0

How to get list of All commands for SCOM 2012 R2 Module in Powershell

How to get list of All commands for SCOM 2012 R2 Module in Powershell

• Today i am going to Show you how get list of all commands available in SCOM module.
• First Open the Powershell and Import the SCOM module

                    Import-Module OperationsManager

• This will load the SCOM module in Powershell
• Then to see all the commands in the OperationsManager Modulle type the below command

                   get-command - module OperationsManager | more

• This will list all the commands in SCOM.

SQL query to get all Distributed Applications created by users in SCOM

SQL query to get all Distributed Applications created by users in SCOM

• Distributed Application are stored in SCOM in ManagedEntity Table
• All Distributed Applications created by users start with "Service_" in the FullName column
• If you want to query all your distributed application that are created for reporting purpose use the below query

***********

SELECT * FROM [OperationsManagerDB].[ManagedEntity] where (FullName like 'Service_%' AND Name is NULL)

*****************

Where is All Programs in Windows 10. Its now called All Apps

Where is All Prgrams in Windows 10. Its now called All Apps

• Lot of Things have Changed in Windows 10.
• One Such important thing that change is All Programs.
• Earlier we use to Click Start-->All Programs to Find our Application.
• But with Windows 10, this has been Changed to Start -->All Apps
• This is Done so that its compatible with Windows Phone.
• So hope you get used to it :)