I'm trying to poll certain nodes that I specify that have a particular piece of software running on them. Ultimately I'm trying to spit out a report that details the version of the software that they're running.
The version is kept in 2 places: a MS SQL table and also in the service name.
The SQL Table is in the same instance name everywhere (SWIZE) and the same database name (SWIZE) within that instance, same table (W_CONFIG) and same column (WCFG_SETTING).
Essentially my query is:
Select WCFG_SETTING from W_CONFIG where WCFG_TAG='CORE_VERSION'
For the service name, the version is after the name (which is standard)
Not sure how to approach this, any help would be appreciated. Thanks in advance.