This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Show Enabled Alert Actions Using Custom HTML And JavaScript (Dynamic Tables)

Rather than another lengthy "How To" post, I figured I'd just show the end results, as well as provide the copy/paste material(s) needed to achieve said results.

For more details on using this method, please check the link below.

How-To: Insert Google Charts (Table Data) within Custom HTML

I was looking through various posts around here, and found a nice SWQL query from mesverrum​​.

SQL Query to View All Enabled alert and its action

I found his query to be very helpful and so I started to use it. While using it, I simply wanted a better, more "clicky", way navigate the results.

And that is the story of how this little diversion came to be... THE END...

Well, almost. Here is what it looks like:

There are 3 widgets on this page, 2 of which are "Custom HTML", and the other a "Custom Query". The custom query (2nd column, 2nd row) simply has the SWQL query from mesverrum​'s reply/answer in the post referenced above.

(1) This is the navigation widget. Clicking on a value here will populate the results widget (2), changing results as you click. These are the alert types.

(2) This is the list of results, once you select a value from the navigation widget (1).

CustomSWQLQueries - JS_DynamicTableData_BEFORE_20191023_1709.png

For this example, let's say you wanted to view only the alert actions for the object type "Nodes". The navigation widget shows us there are 12 results for the "Nodes" category/type.

Clicking the line containing "Node" will populate the results widget (2).

CustomSWQLQueries - JS_DynamicTableData_20191023_1701.png

The contents of the attached file can be placed in a single custom HTML widget (2), and should work just fine. (You may need to adjust some of the table width/height settings to fit your display.)

Alternatively, you can cut line 143, and paste it into the navigation widget (1), which will give you the split/double widget layout.

Again, nothing fancy here, just rehashing an old JavaScript code to display a very useful SWQL query donated to THWACK.

For more ways to customize your SolarWinds environment, make sure to check out this link, by CourtesyIT

How to do various customizations with your Solarwinds

Thank you,

-Will