PENDING SCCM Report status (installed or not) for a specific software on a collection

[scoterland]

Guys,

I'm looking for a SCCM SSRS Report to know the status (installed or not) of a specific software/application on a specific collection.

Do you know about this?

I have this .rdl as base (SSRS 2012). Remember to change the dataset.
https://1drv.ms/u/s!ApU3gCm4YRBIhN12OGV1U0sLofQZsg

Something like this.


Appreciate the help.

 

[Garth]

It is unclear to me, what your question is.
Have you created the SQL query to do what you want?

 

[scoterland]

No, i have this report that do a part of the job. I can search by the software on specific collection but don't returns what I would like.



I would like to return the list of the computers into this collection and if have this software installed or not.

 

[Garth]

You need to write the query before you can create the report.

 

[scoterland]

Do have an idea about the query? I tried to do it already but it's not so easy lol

Thanks for the help.

 

[Garth]

try this

Two Software Titles – sccmug