Re: [ITM] Extracting bulk EIF specific slot

Gilles: If you want to use some SQL via kdstsns (or via kshsoap direct
SOAP/object call), you can get what you want:

SELECT ID,MAP FROM O4SRV.EVNTMAP WHERE ID="<sitname>";

The MAP column contains more than just the mapped msg literal, but you can
use Perl or awk/sed to look for:

literalString value="

And then take everything after that up to and including the next double
quotation mark as the msg slot value (attribute tokens not interpolated of
course).  I think the best way to do it is to place a one-liner in cron
that calls kdstsns and pipes the output to perl or a sed/awk combo, then
redirects the sitname/msg_slot combinations to a file.  A few technotes
exist showing how to setup and manually call kdstsns from the CLI to
execute the necessary SQL, but let us know if you are having a problem.

Toben

On Tue, Jan 22, 2013 at 12:31 PM, Julius Loman <[email protected]> wrote:

> On Tue, Jan 22, 2013 at 06:23:19PM +0000, "Brodeur, Gilles" <
> [email protected]> wrote:
> > Hi,
> >
> > I would like to setup a view to see 2 columns:
> >
> >
> > 1)      Situation Name
> >
> > 2)      EIF slot named MSG (basic one)
> >
> > Using EIB Schema of TEMS/TEPS, SOAP or ITMSUPER
> >
> > Any clue?
> I guess you want a view in TEP showing Actual situations and corresponding
> MSG
> slots from EIF events raised by those situations. But ITM does not have any
> history of EIF events sent by situations, so this seems pretty impossible.
>
> If you need to know the default text - that was not modified in EIF
> customization window, it's always the situation formula.
>
>
> --
>
> [ Julius Loman ][ [email protected] ][ http://lomo.kyberia.net ][
> icq:35732873 ]
>
>
> _______________________________________________
> TME10 mailing list
> [email protected]
> Unsubscribe:[email protected]
>
>


-- 
"Sometimes I think that's the only right thing to do:
To dream. to live in the world of dreams.
But it doesn't last forever--wakefulness always comes to take me back..."

_______________________________________________
TME10 mailing list
[email protected]
Unsubscribe:[email protected]