Hi all, I would like to create a report that counts the number of active users per office location per month. In the ‘nodes’ table I have custom properties for each node that includes for example ‘Region’ and ‘Location’. Using these custom properties I would like to count the number of active users per month to allow me to…
Hi - new here. Looking for a report of all Configured reports that show: 1. Alert name 2. Enabled - true or false 3. Trigger Condition 4. Trigger action The Web 'All Configured Alerts' does not included Trigger Condition and Trigger Action. THANKS !!!
All, I created an user account lockout report for our help desk to use so that they can find out why the user was locked out. This report looks at user lockout events. It will list who is locked out and which system the lockout originated from. I had to use a SQL query in order to strip out the user and the system where…
Gives a bit more connectivity info to the endpoint report:
I am wondering how we can get an SWQL report for UnDP's to have the output 'rows' as columns instead. I see a lot of older threads about reports from UnDP, but no one seems to have found solutions except to write extremely complicated SQL queries. Is there an easier solution to this? See example below: Current Output of…
I searched online for a long time to Frankenstein queries together and nothing ever worked like I wanted, so I started from scratch and put together a no-nonsense, to-the-point report for downtime. Hope this will help someone, wish I had done this a long time ago! SELECT *, CAST(SUM(OutageDurationInMinutes) / 1440 AS…
Hi, I am testing the following SQl quarry to grab total device count for Cisco devices and total Cisco devices running complaint IOS version in order to calculate the percentage and display it in a graph. I am not a SQL guy and have pieced this together but It would be nice to auto calculate the % of compliant devices and…
Hi all, I've seen this around in other posts but not in a direct way or even with a solution, if there is any. We use the availability report to get a weekly list of availability of our groups but it counts unmanaged as down, which doesn't make any sense in a report of this nature. Is there any way to overcome this? I've…
Hello, I wanted to know if there is a report available to list Windows services running on nodes.
I am looking at this portion of the Interface Details resource on an Interface Details page in NPM 11.0.1; and this information would be useful for me, but i can't seem to find any way to report on this information in the SWQL 3.0 schema, or the server based Report Writer application, or any other place I can think of.…
It looks like you're new here. Sign in or register to get started.