Alert Acknowledge massage in Report with event details.

OK, let's clarify few bits first - what are you expecting to see in "Event Type" and "Event Message"? Those are event- related fields. The rest are Alert-related fields. Please send few screenshots where do you see this info and explain reasoning behind this report - what are you trying to achieve by showing all those fields? Is this for yourself? To see what?

actually i would like to achieve there, all alert trigger and they are being acknowledged by infra team member, i want such type of report who and when the alert acknowledged with what notes,

Did you try web-based reporting? There is an out-of-the-box report for it, it is called "All Active Alerts". I suggest you create a copy and fine tune to your liking. Let me know if anything is not quite working there - we will look at it further

Here is demo:

http://oriondemo.solarwinds.com/Orion/Report.aspx?ReportID=6071&ReturnTo=aHR0cDovL29yaW9uZGVtby5zb2xhcndpbmRzLmNvbS9Pcml…

Ok That is nice, that is being used only for active alert, i were used the same but the point is, what about those alert which one has reset and someone did acknowledged or someone not, If you can do something, that would be good,

Thanks in advance.

Active Alert is "Active" regardless whether someone has acknowledged it or not. Those alerts that have been reset are not active anymore - they are history. You have another out-of-the-box report for those historical alerts - I will let you to find yourself (practise makes perfect). You can even combine both of them into one report in Layout Builder by having multiple sections

If you want to go extra mile and want to link them both together into a single table - there are two different SQL Views that you need to check and possibly link together, one being [AlertStatusView] and another one [AlertHistoryView].

"Nothing happens until something moves!" - Albert Einstein

Alex - really i did the all efforts by the thwack team member, but unfortunately not get success for correct report, that's why i involved you also, if you really know the important of this report, kindly try to find the way where we can get the same report,

Again thanks in advance for you.

You need to be as specific as you can. I am just guessing that on this occasion you could not find out-of-the-box reports for your historical alerts. ... here you go... try this:

(1)

Reports > All Reports

(2)

Use search in top-right corner > search for "alert"

(3)

Here you go - your historical reports, including reset alerts, etc

(4)

Create a copy of any of those if you wish (just not to mess up with original) and change any settings, update, fine-tune to your liking. I bet even the way it is by default would suit your needs (but I am guessing again here...)

Some extra reading for you

Manage reports in the Orion Web Console with NPM - SolarWinds Worldwide, LLC. Help and Support

Hi Alex,

These alert are working based on event log, and as you advise that trigger alert and event have not any co-relation,

then this would be work,

Could you please advise to solarwinds support team so they can help us also on this report. by the way i worked with team and they have advise us they are not supporting the customization, update the request in the thwack so that any one can help u on same.

Case Update: 980589

Thanks

K

My friend, I am not representing SolarWinds anyhow... I am just like you - user/customer who seeks my own answers and also helps others to get theirs. What exactly is not working for you? Why you don't like out-of-the-box alerts and reports which I have shown above as an examples?

Thanks i am respecting your word

But the given example o report os not fruitful

If you really understand the requirement of report then pleade let us know

the way to get the same report

Thanks

K

How would it look like if it were "fruitful" then?

Hi Alex,

Actually as you know with previous conversation , the report is working based on event and if we want to add below column details

which is not showing the correct output, we have posted the number of sql query which we have used,

May i know you are not using the such type of report In your infra,

you are interested to know ho many alert is generated every day and in which alert is not being acknowledge by team or not.

i want to such type of report where team is working on all alert and crating a ticket. or you can say acknowledged or not

thanks

k

Hi Alex,

Actually as you know with previous conversation , the report is working based on event and if we want to add below column details

which is not showing the correct output, we have posted the number of sql query which we have used,

May i know you are not using the such type of report In your infra,

you are interested to know ho many alert is generated every day and in which alert is not being acknowledge by team or not.

i want to such type of report where team is working on all alert and crating a ticket. or you can say acknowledged or not

thanks

k