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/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] 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" <[email protected]> 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: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > Phone: 845-486-5643 > Fax: 845-486-5921 > Cell: 845-235-4255
