Thanks Jesse, I'll certainly download the utility from Supportweb as it looks really useful.
For my particular issue I need to identify the filter using workflow as the emails and alerts are created so the looking back to the data dictionary doesn't help much. Thanks again Cheers Peter -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jesse Kona Sent: 07 December 2006 15:28 To: arslist@ARSLIST.ORG Subject: Re: Identify which filter created a notification I wrote a control panel that can search the metatables. It can search for notifications by a string in the subject or the body, or by recipient. The defs are about 1 meg zipped, so I won't send it to the list, but it is in the Developer Downloads section of the BMC supportweb under the name "Metatable Spyglass" If you don't want the entire tool, below are the SQL statements it uses. You could just build a display-only form with a subject field and a body field that runs these statements as direct SQL active links and returns lists of filters/escalations that could send these notifications. Filters by Subject: SELECT o.name, arschema.name, o.fOrder, o.enable, n.userName, n.actionIndex, o.filterId, n.subjectText, n.notifyText, o.opSet FROM filter_notify n, filter o, filter_mapping map, arschema WHERE n.filterId = o.filterId AND o.filterId = map.filterId AND map.schemaId = arschema.schemaId AND n.subjectText LIKE '%$Notification Subject +$%' Order By arschema.name, o.fOrder Filters by Body: SELECT o.name, arschema.name, o.fOrder, o.enable, n.userName, n.actionIndex, o.filterId, n.notifyText, n.subjectText, o.opSet FROM filter_notify n, filter o, filter_mapping map, arschema WHERE n.filterId = o.filterId AND o.filterId = map.filterId AND map.schemaId = arschema.schemaId AND n.notifyText LIKE '%$Notification Text +$%' Order By arschema.name, o.fOrder Filters by recipient: SELECT o.name, arschema.name, o.fOrder, o.enable, n.userName, n.actionIndex, o.filterId, n.notifyText, n.subjectText, o.opSet FROM filter_notify n, filter o, filter_mapping map, arschema WHERE n.filterId = o.filterId AND o.filterId = map.filterId AND map.schemaId = arschema.schemaId AND n.userName LIKE '%$Notify Whom +$%' Order By arschema.name, o.fOrder Let me know if you need the escalation searches also. -Jesse -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Peter Romain Sent: Monday, December 04, 2006 7:20 AM To: arslist@ARSLIST.ORG Subject: Re: Identify which filter created a notification Doug, That's a good trick but unfortunately I can't use it here as it doesn't work for alerts! Cheers Peter Tanner, Doug writes: > FYI: One of my tricks is to include a unique description on the > "Organization" line within the filter (2nd Tab on the Notify action) > Example: Respond to Requester - Ticket Created > > Then I assure I track these Unique Descriptions to the exact filter name > > This is a very powerful feature, as I can report on this, fire > additional workflow, enhance audit, etc.. > > Doug > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Urbanek, Clint > Sent: Monday, December 04, 2006 10:02 AM > To: arslist@ARSLIST.ORG > Subject: Re: Identify which filter created a notification > > Peter, > > The tool is designed for exactly what you thought, finding stuff after > the fact. You are also correct in the fact many emails use field values > and keywords in the subject and text section. So far this hasn't been a > problem because I can search on any partial text and/or replace the text > with the keyword or field value that I believe generated the text. If > all else fails showing all notification actions is typically not > overwhelming and easy to sort through. > > What the tool does that may help is it contains the filted id and > action. It may be possible to key off of these two things. > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Peter Romain > Sent: Sunday, December 03, 2006 1:52 PM > To: arslist@ARSLIST.ORG > Subject: Re: Identify which filter created a notification > > Clint, > > Forgive me if I'm wrong but your tool sounds great if someone turns up > with an email and you need to find out which piece of workflow generated > it. > > My problem is that I have to identify the filter creating emails and > alerts dynamically. > > Also, many of the notification actions use field values for the > text/subject which are replaced with values when the filter runs. The > increasing use of such data driven workflow makes it increasingly > difficult to query the data dictionary to find things. > > Thanks for your mail, and if I've misunderstood what your tool does > please let me know. > > Cheers > > Peter > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Urbanek, Clint > Sent: 01 December 2006 19:20 > To: arslist@ARSLIST.ORG > Subject: Re: Identify which filter created a notification > > Peter, > I have built a tool to allow me to search for notifications and > messages based on notification subject, notification text, message > number, message type or message text. > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen > Sent: Friday, December 01, 2006 10:49 AM > To: arslist@ARSLIST.ORG > Subject: Re: Identify which filter created a notification > > Peter, > > I use codes that appear in the lower right corner of the html email in a > small font. You could also make the codes (or names of filters) in > hidden text. The text would be visible when you open the email in a text > editor. > > For HPD:HelpDesk notifications, I use H01 - H##, for CHG:Change I use > C01 - C##, etc. In each filter that sends an email I added this code. > It was tedious to do but I am glad I did it. Every email in the system > now links back to a filter or active link. > > > On a related note, it would be great if BMC added a few keywords that > correspond to the names of filters, active links, escalations, etc. For > example $FILTERNAME$, $ACTLINKNAME$, $ESCNAME$. Or simply $ARSOBJECT$ > that works in all action objects. This would make troubleshooting and > auditing much easier. > > Stephen > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Peter Romain > Sent: Friday, December 01, 2006 12:14 PM > To: arslist@ARSLIST.ORG > Subject: Identify which filter created a notification > > Hi All, > > Has anyone ever found a way to dynamically identify which filter caused > a particular email or alert? > > The scenario is that when a mail or alert record is generated no mail or > alert is sent unless the filter creating the notification is in a list > of allowed filters (maintained by users). > > The solution so far is to embed the filter id into the notification text > but this is clunky and not server independent (filter name takes too > many characters out of the 255 limit for an alert). > > I won't bore you with any more background other than that simply > disabling the filters is not considered an option! > > Cheers > > Peter > > ARS6.3 Patch 18 > Oracle > ITSM 6 > > ________________________________________________________________________ > _______ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > > ________________________________________________________________________ > _______ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > > ________________________________________________________________________ > ____ > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > > ________________________________________________________________________ > _______ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > > ________________________________________________________________________ > _______ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > > DISCLAIMER Important! This message is intended for the above named person(s) only and is CONFIDENTIAL AND PROPRIETARY. If you are not the intended recipient of this e-mail and have received it in error, please immediately notify the sender by return email and then delete it from your mailbox. This message may be protected by the attorney-client privilege and/or work product doctrine. Accessing, copying, disseminating or re-using any of the information contained in this e-mail by anyone other than the intended recipient is strictly prohibited. Finally, you should check this email and any attachments for the presence of viruses, as the sender accepts no liability for any damage caused by any virus transmitted by this email. Thank you. > > ____________________________________________________________________________ ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"