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




      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,