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)

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