ekarella · IT Infrastructure Analyst / Systems Administrator · ✭✭✭✭✭

I changed cs.RawStatus to cs.Status and it fixed it! Thank you for your help!

That at least updated to show the NodeIDs properly, but the SerialNumber column is still showing all "NULL" values

It does not, but I can't figure out where it is wrong.

Thanks Chad! We will give that a try!

Thanks for the response. That only partially accomplishes what we are trying to do. The downside to that is it does not, at all times, identify the node and AG name while also identifying which is primary/secondary. We need that functionality so we can display it to our DBAs on a modern dashboard like so:

Here is the SWQL query we are using: SELECT n.ActiveUsers, n.ObservationTimestamp FROM Orion.asa.RemoteAccessDetail n JOIN orion.nodes a on a.nodeid=n.NodeID and a.Caption like '%<ASA_NAME>%' WHERE n.ObservationTimestamp > ADDDAY(-30,GETUTCDATE()) I believe the data that is queried here is suppoed to roll up into Hourly…