Software Version Query

[dtorres]

Is there a way in SMS to query software version numbers?

I have deployed both a standalone and network version of AutoDesk Architectural Desktop and would like to have SMS do a software search to determine who has what version.

Any information on this would be greatly appreciated.

Thank You

 

[snyderj]

Here's some WQL that may get you started:

select SMS_G_System_SoftwareFile.FileName, SMS_G_System_SoftwareFile.FileVersion, SMS_G_System_SoftwareProduct.ProductName, SMS_G_System_SoftwareProduct.ProductVersion from SMS_R_System inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_SoftwareProduct on SMS_G_System_SoftwareProduct.ResourceID = SMS_R_System.ResourceId where SMS_R_System.Name = ##PRM:SMS_R_System.Name## and SMS_G_System_SoftwareFile.FileName = ##PRM:SMS_G_System_SoftwareFile.FileName##

This assumes you have SMS 2 and inventory for extensions appropriate for your search of AutoDesk (or whatever).


snyderj