Well, you can check the SESSIONS table to answer the question as to
whether the DOMAIN appears in there (it does not).

So do a SELECT from the SESSIONS table and add a WHERE criterion that
includes a subquery from the NODES table. The subquery can return node
names that are in the desired domain.

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Product Development
Level 3 Team Lead
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

IBM Tivoli Storage Manager support web page:
http://www.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 06/03/2008
01:48:15 PM:

> Is there a select statement that would show only
> client sessions for a particular donmain.
>
> The domain field doesnt appear in the results of a q session or q
> session f=d
>
> Tim Brown
> Systems Specialist - Project Leader
> Central Hudson Gas & Electric
> 284 South Ave
> Poughkeepsie, NY 12601
> Email: tbrown AT cenhud DOT com <mailto:tbrown AT cenhud DOT com>
> Phone: 845-486-5643
> Fax: 845-486-5921
> Cell: 845-235-4255