Thanks Much for all the information!
On Tue, Jun 11, 2013 at 11:10 AM, Longwing, Lj <[email protected]> wrote: > ** > 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_ >> > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > -- S.J.Deshpande _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
