Reports on Day to Day activity tracking

Question

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

mesverrum · Answer

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.

sw2174873 · Answer

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

sw2174873 · Answer

Hey,

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