Creating SMS query

[overide]

I want to gather data about how many copies of a software application are installed on computers throughout the organization. Does anyone know how to create one?
Thanks

 

[snyderj]

A WQL query such as this for admin console should get you started. Replace iexplore.exe with whatever file name you are seeking, keeping in mind whether SMS is actually inventorying it or not.

select distinct SMS_R_System.Name, SMS_G_System_SoftwareFile.FileVersion from SMS_R_System left join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FileName = "iexplore.exe"

This will give you a list of computer names where the given file is installed. This does not indicate whether the software is being used, installed correctly or properly licensed.

 

[RodTrent]

>>This will give you a list of computer names where the >>given file is installed. This does not indicate whether >>the software is being used, installed correctly or >>properly licensed.

BTW: You can get this information using the new Extended Software Inventory application:

http://www.netimpress.com/shop/product.asp?product_id=NI-SMS20-2

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

http://www.myITforum.com

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