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"
