Schedule Report for "Load Balancing -> Custom Chart - Concurrent Connections by Virtual Server "

luyennt04

In Solarwinds NPM, I want to create Schedule Report for " F5 Load Balancing -> Custom Chart - Concurrent Connections by Virtual Server ".

I try to create report with table as below:

SELECT VSS.DateTime, VSS.VirtualServer.Name, VSS.Connections
FROM Orion.F5.LTM.VirtualServerStats VSS
WHERE (VSS.DateTime >= ADDDATE('HOUR', -24, GETUTCDATE())) AND (VSS.VirtualServerID = 78)
ORDER BY VSS.DateTime, VSS.VirtualServer.Name ASC

But I haven't received result.

Pls guide me

stuartd

I am far from being a coder, but I have never managed to get ADDDATE to work.

So I've replicated your query into my environment and changed the Server ID to 80 (I don't have a 78). I edited the WHERE line to be:

WHERE (VSS.DateTime > ADDDAY(-1, GETDATE()))

If you want hours, then I believe ADDHOUR(-24, - will work.