SCCM SQL Query to get application name which has dependent

Boopathi S 3,806 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 Security Intune Configuration Manager Application
0 comments No comments
{count} votes

Accepted answer
  1. Amandayou-MSFT 11,156 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 No comments

1 additional answer

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

    Hello Amandayou,

    Thanks.

    0 comments No 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.