SCCM SQL Query to get application name which has dependent

Boopathi S 3,386 Reputation points
2021-08-18T16:13:19.017+00:00

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.

Microsoft Configuration Manager Application
Microsoft Configuration Manager Application
Microsoft Configuration Manager: An integrated solution for for managing large groups of personal computers and servers.Application: A computer program designed to carry out a specific task other than one relating to the operation of the computer itself, typically to be used by end users.
481 questions
0 comments
Accepted answer
  1. Amandayou-MSFT 11,061 Reputation points
    2021-08-19T03:10:37.21+00:00

    Hi @Boopathi S ,

    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.

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Boopathi S 3,386 Reputation points
    2021-08-19T11:56:33.247+00:00

    Hello Amandayou,

    Thanks.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.