List applications and Client login ID

[Odd Bjørn Andersen]

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

[peteh]

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

[Odd Bjørn Andersen]

Thank you! Just what I was looking for.

Regards
Odd Bjørn

"peteh" <ph******@intellicare.com> wrote in message
news:11*********************@g10g2000cwb.googlegro ups.com...

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