Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

How do I create a report for "Acknowledged by"?

Good morning -

How do i create a report that provide information over the last seven days for items that have been acknowledged by someone wotking in Solarwinds?

Thank you for your time.

JBMoore

Find more posts tagged with

Accepted answers

AlexSoul

OK, this is good, you are pretty much on latest version.

There are two options to consider:

(1)

Build report in GUI

Hover over HOME tabe, then click on Reports. From there, got to Manage Reports > Create New Report
Select Custom Table > Select & Continue
I want to report on Alert Object (now, logically I would pick Alert History, but Acknowledgement data is not available through this object)
Add to Layout
Next - build your column you want to see. I advise you to experiment here - just add all of the and see which one give you most desirable result
Use preview button to check what you are getting. The go next, next, next, submit

With this option above I was not able to achieve result that I would like. Besides, I could not find the way to restrict to 7 last days. Therefore, I would opt for option 2 below

(2)

Build report with SQL script

Do step 1 and step 2 as above - they are same
Now, refer to first screenshot below. You need to select SQL as a source and then paste SQL querry. Notice that within SQL you can have umber of day you want to include from the past
The go and add colmns that fit you the most. Once happy, you can the even group some of them together for better result (see below)

SELECT *FROM AlertHistoryView ahvJOIN AlertStatusView asv ON asv.AlertDefID = ahv.AlertRefID AND ahv.AlertObjectID = asv.AlertObjectIDJOIN AlertDefinitionsView adv ON adv.AlertDefID = asv.AlertDefIDWHEREEventTypeWord = 'Acknowledged'ANDahv.TimeStamp > DATEADD(DAY, -7, GETDATE())

and this one is grouped by alert name

... to take it further, you can also JOIN nodes table and pull off all info you need about the nodes, etc... SQL is really cool thing

All comments

AlexSoul

This can be achieved either via web-based reports or with SQL query. What version of NPM you are on my friend? Just scroll all the way down on any page any copy-paste the very last info in footer section

jbmoore17

Good mornign Alex - 11.5.2

Orion Platform 2015.1.2, VNQM 4.2.2, IPAM 4.3, SAM 6.2.1, DPA 9.2.0, NCM 7.4, IVIM 2.1.0, QoE 2.0, NPM 11.5.2, NTA 4.1.1

AlexSoul

OK, this is good, you are pretty much on latest version.

There are two options to consider:

(1)

Build report in GUI

Hover over HOME tabe, then click on Reports. From there, got to Manage Reports > Create New Report
Select Custom Table > Select & Continue
I want to report on Alert Object (now, logically I would pick Alert History, but Acknowledgement data is not available through this object)
Add to Layout
Next - build your column you want to see. I advise you to experiment here - just add all of the and see which one give you most desirable result
Use preview button to check what you are getting. The go next, next, next, submit

With this option above I was not able to achieve result that I would like. Besides, I could not find the way to restrict to 7 last days. Therefore, I would opt for option 2 below

(2)

Build report with SQL script

Do step 1 and step 2 as above - they are same
Now, refer to first screenshot below. You need to select SQL as a source and then paste SQL querry. Notice that within SQL you can have umber of day you want to include from the past
The go and add colmns that fit you the most. Once happy, you can the even group some of them together for better result (see below)

SELECT *FROM AlertHistoryView ahvJOIN AlertStatusView asv ON asv.AlertDefID = ahv.AlertRefID AND ahv.AlertObjectID = asv.AlertObjectIDJOIN AlertDefinitionsView adv ON adv.AlertDefID = asv.AlertDefIDWHEREEventTypeWord = 'Acknowledged'ANDahv.TimeStamp > DATEADD(DAY, -7, GETDATE())

and this one is grouped by alert name

... to take it further, you can also JOIN nodes table and pull off all info you need about the nodes, etc... SQL is really cool thing

jbmoore17

Absoultely awesome and outstanding Alex. A huge step in the right direction for me. Thank you kindly for your time, patience, and knowledge.