Hi Adam

Domain_name='CASESENSITIV'

Regards
joachim   

-----Ursprüngliche Nachricht-----
Von: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] Im Auftrag 
von Crosskey, Adam - Resources, ICT Services
Gesendet: Dienstag, 31. Januar 2006 15:32
An: ADSM-L AT VM.MARIST DOT 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:Joachim.Schaub AT 
ABRAXAS DOT CH]
Sent: 31 January 2006 14:03
To: ADSM-L AT VM.MARIST DOT 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:ADSM-L AT VM.MARIST DOT EDU] Im Auftrag 
von Crosskey, Adam - Resources, ICT Services
Gesendet: Dienstag, 31. Januar 2006 14:55
An: ADSM-L AT VM.MARIST DOT 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