SDMPackageDigest Reporting

Hello,

I am wondering if anyone has been able to create a report that shows requirements in the AppMgmtDigest xml. I am using the following query...for the requirements all I am returning is "OneOf", and looking for the query that will return the results of Oneof and operating system requirements (like All Windows 7 x64).

;WITH XMLNAMESPACES ( DEFAULT 'http://schemas.microsoft.com/SystemCenterConfigurationManager/2009/AppMgmtDigest' )
select
app.SDMPackageDigest.value('(/AppMgmtDigest/DeploymentType/Title/@ResourceId)[1]','nvarchar(MAX)')[ResourceID],
app.SDMPackageDigest.value('(/AppMgmtDigest/DeploymentType/Title)[1]','nvarchar(MAX)')[Title],
app.SDMPackageDigest.value('(/AppMgmtDigest/DeploymentType/Description)[1]','nvarchar(MAX)')[Description],
app.SDMPackageDigest.value('(/AppMgmtDigest/DeploymentType/Requirements)[1]','nvarchar(MAX)')[Requirements],
app.SDMPackageDigest.value('(/AppMgmtDigest/DeploymentType/Technology)[1]','nvarchar(MAX)')[Technology],
app.SDMPackageDigest.value('(/AppMgmtDigest/DeploymentType/Installer/Contents/Content)[1]','nvarchar(MAX)')[Content],
app.SDMPackageDigest.value('(/AppMgmtDigest/DeploymentType/Installer/CustomData/EnhancedDetectionMethod/Settings)[1]','nvarchar(1000)')[Detection Method]

from v_configurationItems as app
where app.CITYPE_ID = 21 AND app.IsLatest = 1

November 23rd, 2012 11:17pm

;WITH XMLNAMESPACES ( DEFAULT 'http://schemas.microsoft.com/SystemsCenterConfigurationManager/2009/06/14/Rules', 'http://schemas.microsoft.com/SystemCenterConfigurationManager/2009/AppMgmtDigest' as p1)

found the solution is to use the definition above in my query.

  • Marked as answer by BBowron Wednesday, November 28, 2012 8:30 PM
Free Windows Admin Tool Kit Click here and download it now
November 26th, 2012 6:06pm

Can you give more detail. I tried :

;WITH XMLNAMESPACES ( DEFAULT 'http://schemas.microsoft.com/SystemsCenterConfigurationManager/2009/06/14/Rules',
 'http://schemas.microsoft.com/SystemCenterConfigurationManager/2009/AppMgmtDigest' as p1)

select 
SDMPackageDigest.value('(/AppMgmtDigest/DeploymentType/Title/@ResourceId)[1]','nvarchar(MAX)')[ResourceID],
app.SDMPackageDigest.value('(/AppMgmtDigest/DeploymentType/Title)[1]','nvarchar(MAX)')[Title],
app.SDMPackageDigest.value('(/AppMgmtDigest/DeploymentType/Description)[1]','nvarchar(MAX)')[Description],
app.SDMPackageDigest.value('(/AppMgmtDigest/DeploymentType/Requirements)[1]','nvarchar(MAX)')[Requirements],
app.SDMPackageDigest.value('(/AppMgmtDigest/DeploymentType/Technology)[1]','nvarchar(MAX)')[Technology],
app.SDMPackageDigest.value('(/AppMgmtDigest/DeploymentType/Installer/Contents/Content)[1]','nvarchar(MAX)')[Content],
app.SDMPackageDigest.value('(/AppMgmtDigest/DeploymentType/Installer/CustomData/EnhancedDetectionMethod/Settings)[1]','nvarchar(1000)')[Detection Method]


from v_configurationItems as app
where app.CITYPE_ID = 21 AND app.IsLatest = 1

But this gives me all NULL fields for all my records

November 27th, 2014 11:04am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics