Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 8

Reports on Day to Day activity tracking

Do we have a way to get a report which can give details about events that happens on a daily basis,

Like i can run the SWQL query to see what activities happened today which can give me the complete details for day to day

  • Node Caption
  • Alert Name
  • Alert Message
  • Object that triggered the alert
  • Triggered DateTime
  • Active Time
  • Alert Reset
  • Comments (default custom property)
  • AcknowledgeDateTime
  • AcknowledgeBy
  • Acknowledged 
  • etc

I have NPM & NCM module 2019.4 version

0 Kudos
4 Replies

Almost sounds like you just want a pretty version of the alerthistory table?
- Marc Netterfield, Github

Thanks for replying,

Is there any SQL or SWQL query which we can run to get the daily activities happening on the network monitoring

I have seen some query but when i am looking for the query i am not able to find it

Thanks for your help

0 Kudos

You should be able to build what you need fairly simply by opening up the database manager on your orion server and starting with

select top 100
from alerthistory ah
join alertobjects ao on ao.alertobjectid=ah.alertobjectid
join alertconfigurations ac on ac.alertid=ao.alertid

You should be able to comb through the results there and find everything you asked for and pretty it up however you like.
- Marc Netterfield, Github
0 Kudos


Yes basically a table which can give us report on Daily activities

0 Kudos