I just noticed that in my post I missed out a bracket but then if you have already attempted to use that statement you might have already figured that out..
The statement should have been.. select name from actlink where schemaid in (select schemaid from arschema where name = '<your schema name>'); If you do not get a distinct set of results and its not ordered you could modify it as select distinct name from actlink where schemaid in (select schemaid from arschema where name = '<your schema name>') ordered by name; Cheers Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Sabyson Fernandes Sent: Monday, December 14, 2009 2:47 PM To: arslist@ARSLIST.ORG Subject: Re: fast way to find the object in Remedy ** Another option is if you have a documentation utility like ARInside (www.arinside.org). From here you can view all fields and workflow related to the form and go down to the field level as well. If you still want to stick to the admin tool, as Joe pointed out, it can be slow at times. If I need to do this, I restrict the number of objects I am viewing by using the View -> By form functionality in the admin tool. Saby ---------------------------------------------------------------------------- -- From: Joe D'Souza <jdso...@shyle.net> To: arslist@ARSLIST.ORG Sent: Mon, December 14, 2009 2:16:40 PM Subject: Re: fast way to find the object in Remedy ** Atif, Since you say 'quickest' technically the AR Admin tool isn't the 'quickest' way to find objects especially if you have all those OTB apps of ITSM installed.. The quickest way would be trying a database search.. For e.g. if you want to search for all AL's tied to a particular form: select name from actlink where schemaid in (select schemaid from arschema where name = '<your schema name>'; You could also use the exist clause instead of in, which I am told has a performance advantage.. These searches will take no more than a few seconds (1 to 2 or 3 seconds) as opposed to nearly a minute or more on the Admin tool.. You could run similar searches for other objects like filters, menus, etc.. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of ITN (Atif Akbar) Sent: Monday, December 14, 2009 7:09 AM To: arslist@ARSLIST.ORG Subject: fast way to find the object in Remedy ** Hi, I am using Remedy 7 and need to know the quickest way to find that Objects (e.g. active links, Filters) related to Form. Thanks & Regards Atif Akbar DISCLAIMER: "This e-mail message including any of its attachments is intended solely for the addressee(s) and may contain privileged information. If you are not the addressee or you have received this email message in error. Please notify the sender and delete the email destroying any hard copies of the original e-mail message and The sender will remove your details from its database. You are not authorized to read, copy, disseminate, distribute or use this e-mail message or any attachment to it in any manner. This e-mail message does not contain financial instructions or commitments of any kind. Any views expressed in this message are those of the individual sender and do not necessarily reflect the views of Emirates NBD PJSC, or any other related subsidiaries, entities or persons." _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
