Report for new Monitors Created

I am trying to set up a report that will show all new Nodes and Application \ Component Monitors that have been added in the previous month.

I don't mind having these on two separate reports if that's easier.

Is anyone able to assist with this?

Find more posts tagged with

Accepted answers

All comments

naveensingh43

Hi @rbooker69590

Try the below steps:

Go to Reports > Manage Reports.
Click Create New Report.
Choose Custom Table as the report type.
Add the following objects:
- Orion Object: Node
- Orion Object: Application
- Orion Object: Component Monitor
Add columns like:
- Node Name
- Application Name
- Component Monitor Name
- Status
- Last Polled Time

Filter by Last Month:

Use the Time Filter in the report builder:
- Set it to Last Month or use a custom date range (e.g., from August 1 to August 31).
You can also filter by Application Status or Node Group.

HerrDoktor

SELECT ev.TimeLoggedUtc
      ,ev.AccountID
      ,ev.AuditEventMessage
      ,ev.NetworkNode
      ,ev.NetObjectID
      ,ev.DetailsUrl
      ,ev.DisplayName
FROM Orion.AuditingEvents AS ev 
WHERE ev.ActionTypeID in (33,112,229) AND ev.Timeloggedutc >= ADDMONTH(-1,GETUTCDATE())
ORDER BY ev.timeloggedutc desc 
-- Action types: (33 node created, 112 Template assigned, 229 Interface added)

This Query should get you started. As the creation/deletion is not stored on the Node/Application itself you need to start off of the Audit Events.

Make sure your Database Cleanup Settings are keeping the Events for longer than 30 days.