List applications and Client login ID

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Odd Bjørn Andersen - 19 May 2006 08:14 GMT

When I right click on a database in Control Center and choose 'Applications'
I get listed alle the applications connected at the moment, and among other
things I get to know the 'Client login ID'. For some reason I want to have
this information written to a file, but this is not possible from the GUI. I
try 'list application show detail' but the information about Client login ID
is not included there.

Is there a simple way to get that information so that I can write that to a
file?

Regards
Odd Bjørn A
ErgoGroup AS, Oslo, Norway

Reply to this Message

peteh - 19 May 2006 15:14 GMT

Check out the snapshot table functions. We use SQL like the following.
Output could be directed to a file pretty easily...Here's an example:
            SELECT a.Agent_ID
                , a.Appl_Name
                , a.DB_Name
                , a.Auth_ID
                , a.Execution_ID
            FROM TABLE(SYSPROC.SNAPSHOT_APPL_INFO(CURRENT SERVER,-1)) as a
            inner join TABLE(SYSPROC.SNAPSHOT_STATEMENT(CURRENT SERVER,-1)) as
b
                on a.agent_id = b.agent_id

Good luck!

Pete H

Reply to this Message

Odd Bjørn Andersen - 22 May 2006 07:01 GMT

Thank you! Just what I was looking for.

Regards
Odd Bjørn

> Check out the snapshot table functions. We use SQL like the following.
> Output could be directed to a file pretty easily...Here's an example:
[quoted text clipped - 11 lines]
>
> Pete H

Reply to this Message