I get many requests from my applications support team to run queries as a monitoring tool.
In these requests they would like to see what is returned by the query and not just the numerical value. Are there any plans to include this in a future release?
Obviously you would have limitations on how many rows and columns could be returned but just to show a numerical value on a DB query, especially from an application support standpoint is pointless.
Right now I have this query...
Select * from DOM.xxx_DO_PICKTICKET
Which should return values than mean something to my Apps team.... like this....
01165027 28-FEB-13 10.15.01.000000000 PM
01165031 28-FEB-13 10.15.01.000000000 PM
01165026 28-FEB-13 10.15.01.000000000 PM
To run this correctly in SAM I have to change the query to
Select count (*) from DOM.xxx_DO_PICKTICKET
Which only returns a number, giving my apps team no useful information.
We just recently moved to SolarWinds from SiteScope.... and while I really like how much easier SW is, SiteScope handled this kind of monitor brilliantly by returning what the query asked for.
Thanks for consideration
Wes Gardner