Tag Archives: Owner

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('([email protected])[1]’, ‘nvarchar(MAX)’) [Owners], SDMPackageDigest.value('([email protected])[1]’, ‘nvarchar(MAX)’) [Support Contact] FROM  CI_ConfigurationItems WHERE CIType_ID = 10 […]

Configuration Manager, Microsoft, System Center 2012 Also tagged , , , , , , , Leave a comment