cancel
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

Hey,

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

0 Kudos