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

Filter event widget

this is a bit of a beginner question, but I'm building a dashboard for a group of objects (UPS's), and i want to show the last X events and audit events (separate widgets) for devices in these groups.

I've tried adding in many different event widgets, but they are all global, and I want this dashboard to only display events related to those devices.

Some of these prebuilt event widgets i'm only able to change the title of the widget, and others I can't edit at all.

I tried making a custom table, and I'm able to filter the custom table to show just the events for the required devices, but i'm unable to get thedifferent status images, or the alternating cell shading.

Thanks!

Find more posts tagged with

Accepted answers

All comments

bobmarley

Try this, you can do something similar for Audit Events.

SELECT TOP 200  
       [Events].Nodes.Caption
,      [Events].Nodes.IP_Address
,      TOLOCAL(EventTime) AS LocalEventTime
,      [Events].Message

FROM Orion.Events 

Where [Events].Message LIKE '%YOUREVENTMESSAGEFILTERHERE%'

Order by EventTime DESC

NorthernNetGuy

Thanks for the Reply,

That query gets me what I can already build in a custom table, but not quite what i'm trying to build.

for reference, I'm filtering on a set of subnets where the devices reside..

Here's what I'm trying to get:

But this is what I'm able to create:

bobmarley

Do you have a custom property set to identify a UPS? Otherwise you could use: And [Events].Nodes.IP_Address Like '10.10.10.%'

And keep using that for each subnet until you have all the UPS's on your Where statement

NorthernNetGuy

I do have a custom property to idetify device types, applied to all my UPS devices.

Feature wise my chart works already, i'm jsut trying to get the event images and the alternating cell shading that comes with the prebuilt event tables, as it is much easier to read