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
|
