question

BoopathiSubramaniam-6294 avatar image
0 Votes"
BoopathiSubramaniam-6294 asked BoopathiSubramaniam-6294 answered

SCCM SQL Query to get application name which has dependent

Hi,

I searched in Google for a SCCM SQL Query to get the Application Name and its Dependent Application name if it has. But did not get it.

Please share the query to get the Application Name and its Dependent Application name.
This will be use for cleanup content.

mem-cm-application
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Amandayou-MSFT avatar image
0 Votes"
Amandayou-MSFT answered

Hi @BoopathiSubramaniam-6294,

We could put this query in SQL Query, and the application name and its dependent application name if it has will be shown:

select from fn_ListLatestApplicationCIs(1033)*

Here is the screenshot we could refer to:

124467-819.png
124533-8191.png

Hope it helpful.



If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



819.png (25.5 KiB)
8191.png (9.2 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

BoopathiSubramaniam-6294 avatar image
0 Votes"
BoopathiSubramaniam-6294 answered

Hello Amandayou,

Thanks.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.