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 NodeID Index ParentIndex Available LastUpdate 44 1 44 1 11/10/2019 10:03 44 5 44 1 11/10/2019 10:03 44 8 44 1 11/10/2019 10:03 44 11 44 1 11/10/2019 10:03 44 1 44 1 11/10/2019 09:53 44 5 44 1 11/10/2019 09:53 44 8 44 1 11/10/2019 09:53 44 11 44 1 11/10/2019 09:53 44 1 44 1 11/10/2019 09:43 44 5 44 1 11/10/2019 09:43 44 8 44 1 11/10/2019 09:43 44 11 44 1 11/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

This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.

You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Where is the Node Availability data in SQL DB

garystorr over 4 years ago

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

NodeID	Index	ParentIndex	Available	LastUpdate
44	1	44	1	11/10/2019 10:03
44	5	44	1	11/10/2019 10:03
44	8	44	1	11/10/2019 10:03
44	11	44	1	11/10/2019 10:03
44	1	44	1	11/10/2019 09:53
44	5	44	1	11/10/2019 09:53
44	8	44	1	11/10/2019 09:53
44	11	44	1	11/10/2019 09:53
44	1	44	1	11/10/2019 09:43
44	5	44	1	11/10/2019 09:43
44	8	44	1	11/10/2019 09:43
44	11	44	1	11/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

Top Replies

alphabits over 4 years ago in reply to black_kcy +2

Using SWQL you can query Orion.ResponseTime Here are the columns available: NodeID , DateTime, Archive, AvgResponseTime, MinResponseTime, MaxResponseTime, PercentLoss, PercentDown, Availability , ObservationTimestamp…

0 alphabits over 4 years ago

You can use ResponseTime in views.
Cancel
Vote Up 0 Vote Down

Cancel
0 black_kcy over 4 years ago in reply to alphabits

can i have the swql request which you use ?
Cancel
Vote Up 0 Vote Down

Cancel
0 alphabits over 4 years ago in reply to black_kcy

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.
Cancel
Vote Up +2 Vote Down

Cancel
0 black_kcy over 4 years ago in reply to alphabits

thank
Cancel
Vote Up 0 Vote Down

Cancel