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://learn.microsoft.com/en-us/mem/configmgr/develop/core/understand/sqlviews/application-management-views-configuration-manager

Thank You!

0 comments

1 answer

Rahul Jindal 11,636 Reputation points

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.
Was this answer helpful?
HanyunZhu-MSFT 1,846 Reputation points Microsoft External Staff

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://learn.microsoft.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