0 Replies Latest reply on Mar 30, 2017 1:58 PM by mattwisner

    NPM 12 - Macro/Variable for number of rows returned on custom query

    mattwisner

      Hello,

       

      I have several Solarwinds dashboards running custom queries.  I am looking for a way to access and display (as part of the window's title) the number of rows returned by the query.  For example, rather than the title only saying "Offline Stores", I would like to be able to do something like this:

       

      ${RowsSelected} Offline Stores

       

      So if 5 stores were returned by the query, the title would be "5 Offline Stores", and if zero rows were returned, the title would be "0 Offline Stores".

       

      I have searched the manuals and also several sites that have "SWQL tricks"  (Use SolarWinds Query Language (SWQL - SWIS) - SolarWinds Worldwide, LLC. Help and Support ), all to no avail.

       

      Thanks in advance,

      Matt