AW: [ADSM-L] Query occupancy for nodes in a policy domain
2006-01-31 04:02:50
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
|
<Prev in Thread] |
Current Thread |
[Next in Thread> |
- AW: [ADSM-L] Query occupancy for nodes in a policy domain,
Schaub Joachim Paul ABRAXAS INFORMATIK AG <=
|
|
|