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. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
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 Shane Buchholz sha...@samhealth .ORG To Sent by: Action arslist@ARSLIST.ORG Request System cc discussion list (ARSList)Subject arsl...@arslist. Location Table Names ORG 03/31/2010 12:43 PM Please respond to arsl...@arslist.o 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.gifinline: pic24987.gifinline: ecblank.gif
Re: Location Table Names
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.gifinline: image003.pnginline: image004.png
Re: Location Table Names
** Shane, Site information is spread over several forms. If you are just wanting a list of already defined sites, take a look at SIT:Site Alias Company LookUp. If you are wanting your users to create sites, that's a different issue. Thad Esser Remedy Developer From: Shane Buchholz sha...@samhealth.org To: arslist@ARSLIST.ORG Date: 03/31/2010 11:05 AM Subject: Re: Location Table Names Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG ** 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:arslist@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 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_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ *IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature. * _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_
Re: Location Table Names
** Shane, You would want to reference the view name andnot the table name for such things as it will still retain the connectionafter migrations just in case the sqltable name changes because of a different table id depending on how you perform yourrefreshes from dev to prod.. The view names would be just like the form names you see in the AR System through the admin or the user interface..Only you would need to replace any special characters such as colons or spaces with an underscore.. So SIT:Site would be SIT_Site. There is more to the convention, but for your purpose, this information should be good enough.. The convention is similar for field names... Joe From: Shane Buchholz sha...@samhealth.orgTo: arslist@ARSLIST.ORGSent: Wed, March 31, 2010 2:05:08 PMSubject: Re: Location Table Names** 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 WagnerSent: Wednesday, March 31, 2010 10:59 AMTo: arslist@ARSLIST.ORGSubject: Re: Location Table Names ** Hi Shanethe location information (not department) is stored in the tables that begin with the prefix SITBarb WagnerRemedy ArchitectIBM Global Services(612) 397-2955Tie Line 608-1958bar...@us.ibm.comShane 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 toarslist@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.5ITSM 7.6Windows Server 2008SQL 2005Thanks,Shane BuchholzSystems Analyst II - RemedyInformation Services OperationsSamaritan Health Services _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_