Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Fileversion via APM - WMI?

PeterLyttle

Hello,

Does anyone know how to find the file version of an executable via a WMI query (or any other method). I've tried

Select * from CIM_Datafile where Name = '\\${IP}\\c$\\Program Files\\Folder\\file.exe'

and

also Win32_FileSpecification

Anyone have any ideas?

Find more posts tagged with

apm_wmi_win32_version

Accepted answers

jiri.tomek

For this you can write script that will compare version of both files and if they are different, it returns failure and you can alert on this.

You can also return file version in "Message" fields of script result and then you can create a report that will include these data so you can see it "on paper" for all your monitored machines.

Regarding backed-up folders, you could poll them using script as well and store them in the message filed but it's currently limited to 250 characters so you won't be able to put much data there.

All comments

PeterLyttle

Typical, 5mins after posting this I get the query.

select * from CIM_Datafile where Name = 'c:\\Program Files\\Folder\\executable.exe'

The question is now how do I return a string value rather than the Statistical Data of 0? Then also how do I add this value one of the node views so I dont have to go into APM just to view the value?

jiri.tomek

Hello Peter,
unfortunately statistical data can be only a number so you either have to modify your query to return a number or you have to write a Windows script (VBScript/JScript) that will execute WMI query and transform data to number.

PeterLyttle

Are there any examples of how to do this? Reason being my version would come back as "12.5.2213"

jiri.tomek

Hello Peter,

one way is to use FileSystemObject in VBscript and provide UNC path to file. Short example is here: http://www.devguru.com/technologies/vbscript/14068.asp

Then it depends on how you need to alert on version. You can return it in "Message" but to be able to set alerts on it, you will have to convert it to number somehow and return it as "statistic" as well. How to do this conversion depends only on your needs.

If you want to use WMI, longer example can be found here: http://blogs.technet.com/b/heyscriptingguy/archive/2005/04/18/how-can-i-determine-the-version-number-of-a-file.aspx