SMS query for visio

[ragnar71]

I'm trying to create a query to disply all computers with visio installed. I want the query to show the machine name, the file name (visio.exe), version, the last logged on user, and the product name. Everything seems okay until I try to show the product name. When I do this it pulls all the product names on each machine and not just the visio product name. Any help would be appreciated.

Thanks

 

[mojo31]

Have you got the web repoting tool enabled? Its a breeze with that. Go into search for file, and then put the file name in(VISIO32.exe). Assuming you have your sinv set up to record exe files it should list them there by machine name and user name.
If not, create a new query with the following SQL statement

select SMS_G_System_COMPUTER_SYSTEM.Name, SMS_R_System.LastLogonUserName 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_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FileName = "visio32.exe" order by SMS_G_System_COMPUTER_SYSTEM.Name


hope this helps!