1 Reply Latest reply on Apr 7, 2011 7:47 AM by njoylif

    Tag Trap

    contracer

      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.

        • Re: Tag Trap
          njoylif

          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.