Need query to find ALL software on ALL machines...

[mcgowaw]

I want to find all software by name and version that is installed on all collected systems. I found a canned query that shows which machines have a specific piece of software/version, but I need an inventory of all software installed on all collected systems. Any help would be appreciated.
tony

 

[RodTrent]

Granted a query like this will take a lot of processing time, but check these out:

http://www.myitforum.com/articles/1/view.asp?id=1003

Rod Trent
Microsoft.MVP.SMS
=======================================
Main site:

http://www.myITforum.com

=======================================

 

[mcgowaw]

Thanks much, I'll give it a try and see what happens.
tony

 

[edsev]

If you have installed Web reporting that is included the SMS feature pack there is a query under Software Reports -

Count all installed products and versions.

It took a little while to run but I was quite surprised by the results. A found a lot of renegade software which should not be installed.

If you haven't installed web reporting yet... install it! I'm not sure why I waited so long.