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 <[email protected]> |
| To: | [email protected] |
| Date: | 03/31/2010 11:05 AM |
| Subject: | Re: Location Table Names |
| Sent by: | "Action Request System discussion list(ARSList)" <[email protected]> |
**
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:[email protected]] On Behalf Of Barb Wagner
Sent: Wednesday, March 31, 2010 10:59 AM
To: [email protected]
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
[email protected]
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 <[email protected]>
Sent by: "Action Request System discussion list(ARSList)" <[email protected]> 03/31/2010 12:43 PM
|
|
**
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"_
