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
|