Query details on what I was looking for:
WITH XMLNAMESPACES ( DEFAULT 'http://schemas.microsoft.com/SystemCenterConfigurationManager/2009/AppMgmtD igest' ) 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 From: Johan van Dijk [mailto:[email protected]] Sent: Tuesday, February 04, 2014 10:51 AM To: '[email protected]' Subject: RE: [mssms] RE: Question And just found the answer for it. J For anyone who is interested: http://blogs.technet.com/b/hhoy/archive/2012/07/19/how-to-query-configuratio n-manager-2012-xml-data-with-sql-xquery.aspx From: [email protected] [mailto:[email protected]] On Behalf Of Johan van Dijk Sent: Tuesday, February 04, 2014 10:39 AM To: [email protected] Subject: RE: [mssms] RE: Question And there it is indeed.. J So..anyone has an example to get this in a report.? What I'm trying to do is to get a report with applications and their support/owner info in it. Especially since it's nowhere visible either in the catalog or sc. From: [email protected] [mailto:[email protected]] On Behalf Of Jason Sandys Sent: Monday, February 03, 2014 8:03 PM To: [email protected] Subject: RE: [mssms] RE: Question It's probably within the XML blob of the application within the DB. J _____ From: [email protected] <[email protected]> on behalf of Johan van Dijk <[email protected]> Sent: Monday, February 3, 2014 12:51 PM To: [email protected] Subject: [mssms] RE: Question Select * from fn_ListLatestApplicationCIs(1033) doesn't give it.. L Anyone.? From: Johan van Dijk [mailto:[email protected]] Sent: Saturday, February 01, 2014 4:17 PM To: '[email protected]' Subject: Question Anyone has any idea which view or function this info can be found in.? And I guess they forgot to add this info somewhere in the Application Catalog & Software Center.?
<<image001.png>>
