select node_name, collocgroup_name from nodes order by collocgroup_name
Cheers
Jim
----- Original Message -----
From: "Crosskey, Adam - Corporate Core - ICT Services"
<Adam.Crosskey AT OXFORDSHIRE.GOV DOT UK>
To: <ADSM-L AT VM.MARIST DOT 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.
|