SELECT name FROM actlink WHERE actlinkId IN (SELECT actlinkId FROM actlink_process WHERE command = 'PERFORM-ACTION-ACTIVE-LINK 128 1000001767');
Your query statement would have to look something like that when searching for the active links that contains that process action.. You may have to prefix the table name with dbo. If you are on MS-SQL depending on how you have it setup.. It may also be useful to use upper or lower function to make the search string case insensitive in case that action exists in more than one active link and if it is keyed in with different case each place.. Cheers Joe _____ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Hugo Ruesga Sent: Friday, December 14, 2012 12:58 PM To: arslist@ARSLIST.ORG Subject: Re: Finding a Active Link ID Hi Mark; Well actually, that qualification is built on the way, that seems that an AL Guide is building the qualification criteria for the option you selected from the Overview Panel. To be more specific and towards minimizing your search time; when you use All My Groups feature, qualification is build to retrieve all records, no matter the assignee, belonging your assigned gropus, and by all records I'm talking about all ITSM records you may be handling, unless you have modified the search parameters on the Options of the console. So you're more likely to receive the list of Incidents, problems, changes and tasks assigned to all of your support groups configured for your people record. And asking to your question about finding the AL, you'll need to use a friendly tool such as ARUtilities to find out the field 1000001767 and found the AL that performs action to that field, that will retrieve you the list of all AL related. Happy Friday for you too. Hugo Ruesga Software Development Advisor US 972.577.7000 x 332.3868 MX +52 (33) 3332.3868 P Please consider the environment before printing this email The information contained in and transferred with this electronic message is intended only for the recipient(s) designated above, it is protected by law and it may contain information which is privileged and confidential. If you are not the intended recipient, please do not read, copy, or use it, and do not disclose it to others. Please notify the sender of the delivery error by replying to this message, and then delete it from your system. Thank you. _____ Date: Fri, 14 Dec 2012 12:50:35 -0500 From: mbritt...@navisite.com Subject: Finding a Active Link ID To: arslist@ARSLIST.ORG ** Hi All & TGIF, We are new to ITSM. One question that has come is what is search criteria when I select Assigned to All My Groups in the Incident Console? Let's say I am in the IT Staff group. Are the results where the Assigned Group = IT Staff, the Owner Group i= IT Staff or both? I tried to figure this out by running Active Link logging and thought I had it until I encountered PERFORM-ACTION-ACTIVE-LINK 128 1000001767 Is there an easy way to find the active link? Thanks Mark Mark Brittain Remedy Developer ITILv3 Foundation NaviSite - A Time Warner Cable Company mbritt...@navisite.com Office: 315-453-2912 x5335 Mobile: 315-882.5360 _____ This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"