I would like to create a table chart (Modern Dashboard) that shows the total number of devices, as well as the status of devices (How many are in UP, Waring, Critical) for Cisco Palo Alto and Fortigate. Please help some one.
Hello, is any chance to get report like this: Node Name / % port used / port available / port used/ but grouped by type of interface ? For example if device has 24 ports 1G + 4 ports 10G I would like to have two rows in report. I have devices with ports 1G, 10G, 100G and simple number of free port is useless. Regards Andrew
Created a really simple report that lists all interfaced with a polling interval of 8 minutes (480 seconds) or less. This was so that I could find which intervals have polling intervals which are faster than default (9 minutes).…
So I have this query: SELECT CPS.NodeID, N.Caption, N.IPAddress, CPS.Status AS SerialNumber, N.Vendor, N.Location, N.Contact, N.IOSVersion, N.MachineType, N.NodeDescription, N.LastBoot FROM Orion.NPM.CustomPollerStatusOnNode AS CPS JOIN Orion.Nodes N ON CPS.NodeID = N.NodeID WHERE CPS.DisplayName LIKE '%Module Level1%'…
I've seen a similar question asked before but it was never answered. I'm trying to make report for Node status from last month using custom properties. the problem is there are few nodes that did not show up in the report (3 out of 100 nodes), is there any idea why this happening? I've added the nodes and can seen them…
Anyone successfully got a SQL report to show on a Modern Dashboard? It it even possible since Modern Dashboard widgets only appear to use SWQL. Example of the code: SELECT TOP 10 RowID, CreateDate, SORTORDER, TYPE, COUNT FROM XXXXXX.XXXXX.XXXXX <- name of the DB in question on the same DB server I found this request.. (+)…
Hi, Anyone please help me with query to create a nodes availability report including downtime in minutes. similar to attached images including ip address, node name, device type, vendor, availability in percentage, downtime in minutes. Thanks
How do you change the the default look back days on Remote Access VPN Tunnel Report History in Reports from the default of 2 day to 30. Currently Running SQL 2018. For the record I'm a novice SQL user...... Thanks
Count of Triggered Alerts from Last month to current date. Counts display for Each Alert Triggered as well as a second column that display the entities and the # of alerts each entity has triggered. A Huge Shout out to dhanson for the precursor to this report! This is adjusted to work in current 12.X - cahunt Loop1…
can we get any report option to fetch below SSL cert details from template. see attached screen short Issuer: Valid From: Valid To: Subject: Subject Alternative Name: Thumbprint
It looks like you're new here. Sign in or register to get started.