Where is the Node Availability data in SQL DB

Question

Hi,

I have a requirement to pull the node availability and WAP availability data straight out of the SQL database every 24hrs. I have found the data i need for the WAPs in the table dbo.Wireless_AccessPoints_Detail - details below

NodeIDIndexParentIndexAvailableLastUpdate44144111/10/2019 10:0344544111/10/2019 10:0344844111/10/2019 10:03441144111/10/2019 10:0344144111/10/2019 09:5344544111/10/2019 09:5344844111/10/2019 09:53441144111/10/2019 09:5344144111/10/2019 09:4344544111/10/2019 09:4344844111/10/2019 09:43441144111/10/2019 09:43

but i cant find the equivalent for the Nodes. What table can i find the details that shows the status of each node for each of the polls, whether its up/down/warning/unmanaged etc?

I can build a report to show the data but im unsure as to what tables its referencing to get the info

Regards

black_kcy · Answer

thank

alphabits · Answer

Using SWQL you can query Orion.ResponseTime

Here are the columns available:

NodeID, DateTime, Archive, AvgResponseTime, MinResponseTime, MaxResponseTime, PercentLoss, PercentDown, Availability, ObservationTimestamp, ObservationFrequency, Weight, DisplayName, Description, InstanceType, Uri, InstanceSiteId

Just join in to nodes (using Nodeid) to get the caption etc.

I'll check back in Monday. About to head out.

Hope this helps.

black_kcy · Answer

can i have the swql request which you use ?