SQL Query to fetch DetectionMethod details

DS 51

Hi All,

Outside the WMI approach, is there a way to fetch all the details of an Application DeploymentType using SCCM SQL query.

I am looking for a way to find the detection method details set within an application object via SCCM SQL query approach.

I referred the below link but did not find any view this would provide the detection method details:

https://video2.skills-academy.com/en-us/mem/configmgr/develop/core/understand/sqlviews/application-management-views-configuration-manager

Thank You!

1 answer

Rahul Jindal [MVP] 9,881 Reputation points MVP

2021-06-12T20:52:40.83+00:00

The values are stored in sdmpackagedigest in form of xml within sql. You will need to run xquery to fetch the details.
Please sign in to rate this answer.
HanyunZhu-MSFT 1,846 Reputation points Microsoft Vendor

2021-06-14T09:26:21.307+00:00

As RahulJindal said above, the application properties is stored in table with column called: SDMPackageDigest if the version of your Configuration Manager is 2012.
And we could run XQuery to query the XML data in SQL server Management studio.
Here is an article can be used as a reference:
https://video2.skills-academy.com/en-us/archive/blogs/hhoy/how-to-query-configuration-manager-2012-xml-data-with-sql-xquery
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Your answer