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. --------------------------------------------------------