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 [email protected] Shane Buchholz <sha...@samhealth .ORG> To Sent by: "Action [email protected] Request System cc discussion list (ARSList)" Subject <arsl...@arslist. Location Table Names ORG> 03/31/2010 12:43 PM Please respond to [email protected] RG ** 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"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
<<inline: graycol.gif>>
<<inline: pic24987.gif>>
<<inline: ecblank.gif>>
