1 Reply Latest reply on May 7, 2018 4:48 PM by rschroeder

    Need help pulling software version and make a report from it.


      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:




      For the service name, the version is after the name (which is standard)

      something like:

      servicename 12.03.1403




      Not sure how to approach this, any help would be appreciated.  Thanks in advance.