Hi Adam Domain_name='CASESENSITIV'
Regards joachim -----Ursprüngliche Nachricht----- Von: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Im Auftrag von Crosskey, Adam - Resources, ICT Services Gesendet: Dienstag, 31. Januar 2006 15:32 An: ADSM-L@VM.MARIST.EDU Betreff: Re: [ADSM-L] AW: [ADSM-L] Query occupancy for nodes in a policy d omain Joachim, I have tried this, using my domain names for 'mydomain' but I get no match found. Adam -----Original Message----- From: Schaub Joachim Paul ABRAXAS INFORMATIK AG [mailto:[EMAIL PROTECTED] Sent: 31 January 2006 14:03 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] AW: [ADSM-L] Query occupancy for nodes in a policy domain select node_name, sum (cast(physical_mb as decimal(12,4))) as OCC_MB from occupancy where node_name in (select node_name from nodes where domain_name='mydomain') group by node_name order by occ_mb Regards Joachim -----Ursprüngliche Nachricht----- Von: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Im Auftrag von Crosskey, Adam - Resources, ICT Services Gesendet: Dienstag, 31. Januar 2006 14:55 An: ADSM-L@VM.MARIST.EDU Betreff: [ADSM-L] Query occupancy for nodes in a policy domain Does anyone have a select statement that will tell me the Occupancy for all the nodes in a given Policy Domain? TSM 5.3.2.1 on Windows 2003. Thanks in advance, Adam Crosskey Oxfordshire County Council 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. www.oxfordshire.gov.uk 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. www.oxfordshire.gov.uk