Re: select statement for active sessions based on policy domain

2008-06-04 Thread Choudarapu, Ramakrishna (GTS)
select session_id,client_name from sessions where session_type='Node'
and client_name in (select node_name from nodes where
domain_name='DOMAIN_NAME')

-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Tim Brown
Sent: Tuesday, June 03, 2008 4:48 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] select statement for active sessions based on policy
domain


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


This message w/attachments (message) may be privileged, confidential or 
proprietary, and if you are not an intended recipient, please notify the 
sender, do not use or share it and delete it. Unless specifically indicated, 
this message is not an offer to sell or a solicitation of any investment 
products or other financial product or service, an official confirmation of any 
transaction, or an official statement of Merrill Lynch. Subject to applicable 
law, Merrill Lynch may monitor, review and retain e-communications (EC) 
traveling through its networks/systems. The laws of the country of each 
sender/recipient may impact the handling of EC, and EC may be archived, 
supervised and produced in countries other than the country in which you are 
located. This message cannot be guaranteed to be secure or error-free. This 
message is subject to terms available at the following link: 
http://www.ml.com/e-communications_terms/. By messaging with Merrill Lynch you 
consent to the foregoing.



Re: select statement for active sessions based on policy domain

2008-06-03 Thread Andrew Raibeck
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 ADSM-L@VM.MARIST.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: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
 Phone: 845-486-5643
 Fax: 845-486-5921
 Cell: 845-235-4255