Sorting Alerts by date/time

When I go to the Alerts page to see "Triggered Alerts for All Network Devices" the display was sorted by Network Object.
I would prefer to see the alerts sorted by Date/Time, with the most recent alerts at the top.

After digging around I found the right place and added code to do so.
The code to add is:

        DataView alertView = new DataView(alertTable,
                                                              "alertID <> '' ",
                                                              "AlertTime DESC",
                                                              DataViewRowState.CurrentRows);
        table.DataSource = alertView;
        table.DataBind();

In the line "alertID <> '' ", the end of that line is 2 single quotes followed by a space and a double quote. All other quotes shown are double quotes.

This code is added to the function GenerateReport in file x: \InetPub\SolarWinds\Orion\Controls\AlertsReportControl.ascx.cs
Your drive letter may vary.

Specifically, the code goes in the GenerateReport function, after the closing brace for the clause:
if (!this.Printable)

and just above the line
this.AlertActionsTable.Visible = this.Profile.AllowEventClear

If you would like your list sorted with the oldest alerts at the top, then replace "AlertTime DESC", with "AlertTime ASC".

I'm running NPM 10.0 SP1.
So far I haven't seen any adverse effects from the change, and I'm not a developer so I can't guarantee there are not other implications of adding this code.
This snippet was generated after browsing through a few developer forums and MSDN reference pages.

AlertsReportControl.ascx.cs

Find more posts tagged with

sort

Alert

network_monitoring

network_management

npm

Accepted answers

bshopp

With 10.1 we added a new page called Message Center which allows you to show Syslog, Traps, Alerts and Orion Events in a single page. You can filter out any of these if you don't want to see them and header sorting works there

All comments

sirpaw

Hi,

Is this applicable in v9.5.1?Has anyone tried it yet?

Thanks!

Paulo

wbrown

Given the version difference, I wouldn't try to overwrite your file with my version.

My suggestion would be to go to the specified file, and see if the GenerateReport function is there.
If so, make a backup of the file, then try placing the code snippet into your file and see what happens.

The code doesn't modify any data, it just changes the sort of what's displayed.
I haven't received any feedback (positive or negative), and I haven't experienced any issues, so I don't believe there are any adverse effects.

bshopp

sirpaw

I'm actually looking for a temporary solution for this since we can't upgrade yet to 10.1 as we are planning to upgrade our servers first, so I'm making the most of what we have right now. By the way, i tried placing the code snippet and i encountered an error when I launched the Alerts view.

d09h

Does this change the way other alert resources display? If I have an Active Alerts resource on a summary page, is that resource sorted? Or is this limited to the Alerts summary that is there by default within Solarwinds?

wbrown

This modification only affects the Alerts page in NPM 10.0. If you have any later version then you don't want to be making these changes as the capability has already been added to the product.

Regarding how this affects 10.0, according to my memory this affected the active alerts report but did not affect any other pages or resources.