Barb, Thanks for your quick response. I am looking more for the SQL Table Name that stores this information so that we can reference that for our Web Interface. I know the information is located in many, but I am trying to find the most direct table to query.
Thanks, Shane Buchholz Systems Analyst II - Remedy Information Services Operations Samaritan Health Services From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barb Wagner Sent: Wednesday, March 31, 2010 10:59 AM To: arslist@ARSLIST.ORG Subject: Re: Location Table Names ** Hi Shane the location information (not department) is stored in the tables that begin with the prefix SIT Barb Wagner Remedy Architect IBM Global Services (612) 397-2955 Tie Line 608-1958 bar...@us.ibm.com [cid:image001.gif@01CAD0C2.06620380]Shane Buchholz ---03/31/2010 12:46:29 PM---** Does anyone know what table stores the location information? I am looking specifically for Region, Site Group, Site, Organ Shane Buchholz <sha...@samhealth.org> Sent by: "Action Request System discussion list(ARSList)" <arslist@ARSLIST.ORG> 03/31/2010 12:43 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Location Table Names ** Does anyone know what table stores the location information? I am looking specifically for Region, Site Group, Site, Organization and Department. We are trying to provide a real-time interface for our users to update their information as it changes. The information itself would push into Active Directory, and then modify the People record in Remedy. What we need to do initially is to have a list of valid options for them to choose from. Without valid location information they are currently unable to submit tickets through our online interface. Any help or direction would be appreciated. ARS 7.5 ITSM 7.6 Windows Server 2008 SQL 2005 Thanks, Shane Buchholz Systems Analyst II - Remedy Information Services Operations Samaritan Health Services ________________________________ Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
<<inline: image001.gif>>
<<inline: image003.png>>
<<inline: image004.png>>