Producing the Statistic out of a SQL Server User experience monitor

How would one produce the statistic for this?

Select Round (
((SELECT [StatisticData] as Statistic
FROM [SolarWindsOrion].[dbo].[APM_AlertsAndReportsData]
where NodeName LIKE '%jsmhpxweb02a%' and ApplicationName LIKE '%CMD Glassfish%' and ComponentName LIKE '%Memory Heap Used%') /

(SELECT [StatisticData] as Statistic
FROM [SolarWindsOrion].[dbo].[APM_AlertsAndReportsData]
where NodeName LIKE '%jsmhpxweb02a%' and ApplicationName LIKE '%CMD Glassfish%' and ComponentName LIKE '%Memory Heap Max%'))*100, 2) as perc;

Find more posts tagged with

SAMux

SQL Server User Experience

user experience

Accepted answers

All comments

bobmarley

mcmillrl

I am not a SQL expert this query only prints out 1 value what does the format look like of the statistic command. Statistic: ???? There is no example I can find on the SolarWinds Guides.

sum_giais

It just has to be a numeric int, single column with a single row return if no message... but have you tested your sql query in something like SSMS, or Orions Database Manager (I see its querying the SolarWinds database it appears)

Knowing that I usually force it to a SELECT TOP 1 so there's no way it will return more if there's the chance it could.

mcmillrl

Yes I have run it in MSQL Server Management the Query puts out the Statistic label and one number