select node_name, collocgroup_name from nodes order by collocgroup_name Cheers
Jim ----- Original Message ----- From: "Crosskey, Adam - Corporate Core - ICT Services" <[EMAIL PROTECTED]> To: <ADSM-L@VM.MARIST.EDU> Sent: Thursday, December 06, 2007 11:17 AM Subject: [ADSM-L] select query for nodes in no collocation group Can anybody help? I need to be able to run a query to quickly show me that my colleagues have been adding new nodes to collocation groups as they should. Either a select query returning nodes in no collocation group, or a query listing all nodes and showing the collocation group they are in would be ok. Thanks, Adam Crosskey Principal Systems Engineer Corporate Core - ICT Services Oxfordshire County Council Clarendon House 52 Cornmarket Street Oxford OX1 3HJ Tel: (0845) 8521000 Oxfordshire County Council - rated a four-star 'Excellent' council by the Audit Commission The information in this e-mail, together with any attachments, is confidential. If you have received this message in error you must not print off, copy, use or disclose the contents. The information may be covered by legal and/or professional privilege. Please delete from your system and inform the sender of the error. As an e-mail can be an informal method of communication, the views expressed may be personal to the sender and should not be taken as necessarily representing the views of the Oxfordshire County Council. As e-mails are transmitted over a public network the Oxfordshire County Council cannot accept any responsibility for the accuracy or completeness of this message. It is your responsibility to carry out all necessary virus checks. You should be aware that all emails received and sent by this Council are subject to the Freedom of Information Act 2000 and therefore may be disclosed to other parties under that Act. www.oxfordshire.gov.uk This message has been scanned for viruses by Cattles and Sophos Pure Message scanning services. Cattles plc Registered in England No: 543610 Kingston House, Centre 27 Business Park, Woodhead Road, Birstall, Batley, WF179TD. The views and opinions expressed herein are those of the author and not of Cattles plc or any of its subsidiaries.The content of this e-mail is confidential, may contain privileged material and is intended solely for the recipient(s) named above. If you receive this in error, please notify the sender immediately and delete this e-mail. Please note that neither Cattles plc nor the sender accepts any responsibility for viruses and it is your responsibility to scan the email and attachments(if any). No contracts or agreements may be concluded on behalf of Cattles plc or its subsidiaries by means of email communications. This message has been scanned for Viruses by Cattles and Sophos Puremessage scanning service.
