Configuration Manager 2012: Query for the Application Owners and Support Contacts

Below is an example of how to formulate a SQL query to obtain the “first” app owner and support contact on an Application.

 

1
2
3
4
5
6
7
8
9
WITH XMLNAMESPACES ( DEFAULT 'http://schemas.microsoft.com/SystemCenterConfigurationManager/2009/AppMgmtDigest' )
SELECT
SDMPackageDigest.value('(/AppMgmtDigest/Application/Title)[1]', 'nvarchar(MAX)') [Title],
SDMPackageDigest.value('(/AppMgmtDigest/Application/Owners/User/@Id)[1]', 'nvarchar(MAX)') [Owners],
SDMPackageDigest.value('(/AppMgmtDigest/Application/Contacts/User/@Id)[1]', 'nvarchar(MAX)') [Support Contact]
FROM  CI_ConfigurationItems
WHERE
CIType_ID = 10
AND IsLatest = 1
This entry was posted in Configuration Manager, Microsoft, System Center 2012.

Leave a Reply