theroadguy

Create a flow alert for the IPs/Subnets in this KB from Zoom Network firewall or proxy server settings for Zoom – Zoom Help Center

Welp it looks the configuration above worked... I was just being impatient

Did you make any progress on this at all? I am looking to make NetBox our SOT however I want to get data from Orion, actually I want it to sync if something is updated in NetBox I want it to automatically update in Orion.

@"jm_sysadmin" netbox is just a fancy spreadsheet, however it allows us to decom and circuit and keep it for historical purpose. The idea would be have someone enter the circuit in netbox and then have it feed to the correct interface in Orion.

the format of the date is 2015-05-01 year-month-day WHERE (CustomPollers.UniqueName = 'APCupsBasicBatteryLastReplaceDate') AND (CAST(CustomPollerStatus.Status AS Date) > DATEADD(year,-3,GETDATE())) i updated the query to this and now just getting this error Msg 241, Level 16, State 1, Line 1 Conversion failed when…

silverbacksays‌ thanks, still need to play with it a bit getting this error - don't think I can use the CAST name as a column name Msg 207, Level 16, State 1, Line 16 Invalid column name 'ReplacementDate'. to work I go

Thank you, we were able to get what we needed with the help of this post thanks again

silverbacksays‌ thanks, where do I but this CAST statement?

What about NPM 11.0.1? Any way to do it in the database?

What would have to be done to make this report show outage minutes by MachineType in the nodes table? Here is an example what I am looking to convert over from an excel spreadsheet I have narrowed the code down to only see our switches, see below SELECT MAX(VendorIcon) AS VendorIcon, MAX(Caption) AS Caption, NodeID,…

istefanos‌ did you ever get an answer on this?

I have found them in the NodeIPAddress table would would of thought, lol now just how to figure out how to get an sql query to pull the ip address when I select interface that it is attached too.