Fetch report to get application in add remove from all machines.

Question

Hi all,

I am looking what all applications are installed in ADD/remove program from all collections? is there any sql query where will get all softwares are install from all machines? pls suggest

in progress 0
Rajesh Kumar 4 weeks 2021-04-19T15:34:06+05:30 5 Answers 21 views Beginner 0

Answers ( 5 )

    0
    2021-04-21T15:20:06+05:30

    You just need to run this query from SQL..or you can create a custom report.

    Again, I don’t recommend collecting this info and this is not very useful report..

    0
    2021-04-21T15:15:39+05:30

    Thanks Anoop.

    Just query, can we get same report from SCCM inbuild report option or create custom report in sccm?

    thanks
    Raj

    1
    2021-04-19T16:11:13+05:30

    You can easy get this report … but this report is similar to get all the details of software’s from all computers via sccm … that is going to almost put lot of load on sql and more over it won’t be helpful at all

    https://www.anoopcnair.com/configmgr-custom-report-for-chrome-browser-sccm-sql-query/

    Just remove everything after “where” condition from the query mentioned in the above post. Remove Where condition as well

      0
      2021-04-19T18:42:04+05:30

      Hi Anoop

      I can’t open in sccm to get all software list from all machines as need report where have all software installed on machine so that will target those machine which having any trial or 3rd party software installed. pls suggest

      thanks
      Raj

        0
        2021-04-19T19:47:57+05:30

        What you mean by you can’t get all the software list from all machines? I have given you the SQL query … you can use that query to get the list … Don’t use the part from WHERE clause?

        But this is not good practice at all

Leave an answer

Sorry, you do not have a permission to answer to this question .