Koyb,
That information is stored in the ARSchema table within the database,
specifically the SchemaID column. The schema ID's are generated during
the install and my vary by implementation.
If you're using SQL, you can do something like:
Select Name, SchemaID from ARSchema
Where Name IN ('CTM_People_Organization', 'CTM_Support_Group', '
SIT_Site')
Then just prepend a 'T' to the schema ID and you're set.
Cheers!
Eli
________________________________
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Koyb P. Liabt
Sent: Wednesday, December 08, 2010 9:00 AM
To: [email protected]
Subject: Remedy Table
**
Hi,
Which Remedy table has the Support Organization, Support Group, and the
Location?
_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
