0 Replies Latest reply on Mar 14, 2013 10:07 AM by skyview

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

    skyview

      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)

      something like:

      servicename 12.03.1403

       

       

       

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