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 […]