Thanks Misi - Appreciate your help! For now i am good as I needed to find information for few escalations which I was able to find with ObjProp and finding the pool info form Dev studio.
Thanks, Swanand On Thu, Jun 13, 2013 at 4:54 AM, Misi Mladoniczky <[email protected]> wrote: > Hi, > > Why not turn on the pool-number in the escalation list in dev-studio? > Window > Preferences > BMC Remedy Developer Studio -> Object List View -> > Escalations -> Pool Number? > > The def-file sometimes has a line break in the object-prop which might > potentially make you miss some pool numbers. > > I have code that does various reports from def files that handles that. > > Let me know if you are interested, and I can throw together a small utility > that performs a report on escalation pool numbers based on def-files. > > Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) > > Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11/12): > * RRR|License - Not enough Remedy licenses? Save money by optimizing. > * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. > Find these products, and many free tools and utilities, at http://rrr.se. > > > 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" > > > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "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"
