SCCM Report or Query to identify whether particular software is installed on machines

Question

Hi What would be the best way to query multiple software installation status against a machine.

I’m looking to see if a Machine has specific software installed i.e

Mcafee, SAP, Toad

I want every machine in a collection to show a result for each status in a seperate column of a table.

Example

(Header)Computer,  SAP , Mcafee , Toad
A, Installed,NotInstalled,Installed
B,Notinstalled,Installed,NotInstalled

etc

When I use query editor it locks the query down to only show machines where 1 of the apps is installed but does not show machines where not installed.

Note: this is not for deployments via SCCM so cannot use the deployment status.

 

 

in progress 0
BobbyM 1 month 2021-12-07T23:15:51+05:30 4 Answers 57 views Beginner 0

Answers ( 4 )

    0
    2021-12-09T18:21:53+05:30

    Hi Jitesh

    So unfortunately that will only show devices with it installed. I’m looking to see all devices and then a status column of installed not installed

  1. Hello, I think you can create a custom report to identify the installed application with the version from client machines! You can take a reference to the below post-

    + ConfigMgr Custom Report for Firefox Browser | SCCM | SQL Query
    https://www.anoopcnair.com/configmgr-custom-report-for-firefox-browser-sccm-sql-query/

Leave an answer

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