it is probably stored in the DB in the same manner...you would need to search in the objprop (I think that's the column) for the property 60024, then parse the string apart to find the value...not likely all that easy to get to :)
On Tue, Jun 11, 2013 at 10:05 AM, swanand deshpande < [email protected]> wrote: > ** > Thanks Much! > > Is there a query that can be run in TOAD to find out the information on > escalation and escalation pool number running on a particular pool number? > > > On Tue, Jun 11, 2013 at 10:57 AM, Longwing, Lj <[email protected]> wrote: > >> ** >> Swanand, >> Apparently it's stored in object properties for the object >> >> object-prop : 6\60006\4\0\\60008\40\0\60009\4\0\\60010\4\0\\* >> 60024\2\5*\90002\4\26\Remedy Foundation Elements\ >> object-prop : 2\*60024\2\8*\90002\4\22\Remedy Asset Inventory\ >> >> What you see there is that the first example is in pool 5, and the second >> is 8...so if you look for property 60024, the second value past the >> property value will be the pool number.... >> >> If the escalation doesn't have a pool number, you don't have that >> property defined. >> >> >> On Tue, Jun 11, 2013 at 9:46 AM, swanand deshpande < >> [email protected]> wrote: >> >>> ** >>> Good Morning :-) >>> >>> Hope all is well! >>> >>> How to find out the Pool Number information for escalation from the >>> escalation def file? >>> >>> Thx, >>> Swanand >>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> >> >> _ARSlist: "Where the Answers Are" and have been for 20 years_ >> > > > > -- > S.J.Deshpande > _ARSlist: "Where the Answers Are" and have been for 20 years_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
