Hello, I am trying to convert a query I have confirmed working in the database using SQL into a SWQL query in order for me to place it as a custom query resource on the page.
I am trying to gather specific data from the VOIPJitterOperationResults_Detail, Hourly, and Daily tables.
SELECT COUNT (RecordTimeUtc)*100/3759.0
AS 'SVG1_Weekly'
FROM [SolarWindsOrion].[dbo].[VoipJitterOperationResults_Detail]
WHERE Latency > 120 AND VoipOperationInstanceID like 105
SELECT COUNT (RecordTimeUtc)/552.0*100
AS 'SVG1_Monthly'
FROM [SolarWindsOrion].[dbo].[VoipJitterOperationResults_Hourly]
WHERE AvgLatency > 120 AND VoipOperationInstanceID like 105
SELECT COUNT (RecordTimeUtc)/80.0*100
AS 'SVG1_Quarterly'
FROM [SolarWindsOrion].[dbo].[VoipJitterOperationResults_Daily]
WHERE AvgLatency > 120 AND VoipOperationInstanceID like 105
I've looked all around on thwack and the success center, where people talk about the benefits of using SWQL over SQL, etc. I did not see any general guide on using it to compare specific table data though. I confirmed the COUNT operation is supported in SWQL, perhaps the changes I am doing to the data to get a percent are not working? I'm dividing the data by the total amount of rows possible and multipkying by 100 to get the percentage of total where this value is matched.
Any help would be great.