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

Tag Trap

Hi,

I need setting a tag trap with trap viewer.

In which DB table need I find the recorded message ? (and which sql query to issue ?)

Thanks.

Find more posts tagged with

Accepted answers

All comments

tag the trap (based on criteria you set with the alert) with some text. Initially I would use something bizarre for testing like "catdog" or something.

the table it will reside in is the "Traps" table. an example query might be:

select
COUNT(tag) as occurances,
tag as TagName
from Traps
group by Tag

that would simply give you this type of output for a query

occurances    TagName
90
10                  catdog

I tagged 10 traps with "catdog" and I had a where clause limiting to 100. The other 90 were not tagged.

I'm willing to bet you could create a report in report writer natively without having to do the custom SQL, but I haven't tried.

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Help
Best Of