Comments
-
I've had the same with my custom dashboard, I've found using the following in my query converts the time to GMT CAST(dateadd(hour,DATEdiff(hour,[SolarWindsOrion].[dbo].[AlertActive].[TriggeredDateTime] AT TIME ZONE 'GMT Standard Time',[SolarWindsOrion].[dbo].[AlertActive].[TriggeredDateTime]…
-
I've managed to get this working so for anyone else trying to achieve this here's my SQWL query I've used Select nodes.Caption as NODE, cpson_dia_dc1.DisplayName as DC1_DIA_Name, cpson_dia_dc1.Status as DC1_DIA_Status, cpson_mpls_dc1.DisplayName as DC1_MPLS_Name, cpson_mpls_dc1.Status as DC1_MPLS_Status FROM Orion.Nodes as…
-
Are you able to provide a screenshot please as I don't seem to see that, I see the following. Thanks
-
I thought that may be the case, I was thinking last 4 hours would suffice thanks
-
Great thanks, I'll give that a go.
-
It has worked, I've applied the config across all our switches last night and can see wired clients! thank you very much for your assistance!
-
Great thanks, I've configured a switch with the following and I'm now not getting that error on the UDT compatibility checker so hopefully device tracker should start to populate. snmp-server view <OURGROUP> internet included snmp-server view <OURGROUP> system included snmp-server view <OURGROUP> interfaces included…
-
Thanks for that, I assume this may have something to do with it?
-
No problem, is it the following? UDT monitored Nodes UDT Monitored Interfaces
-
All switches are UDT Monitored nodes along with all interfaces
-
In Device inventory in UDT yes, it appears to be only showing wireless devices which will be from our Meraki platform but not wired devices.
-
Thanks I'll try SWQL. I have just managed to get it working with an SQL query too with a bit of trial and error. Also needed to enable HTML tags for the relevant column for it to show the hyper link to the device/node. CONCAT('',[SolarWindsOrion].[dbo].[NodesData].[Caption],'') as 'Device'