ADSM-L

Re: sql for available drives?

2003-08-01 09:46:08
Subject: Re: sql for available drives?
From: Richard Foster <Richard.Foster AT HYDRO DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 1 Aug 2003 15:45:42 +0200
> In tsm v5 where path and drive status are stored seperately, can
> anyone help with a sql query that would return the number of
> drives that are EMPTY and where the drive is online and the path
> to the drive is online.

Try

select count(*) from drives, paths where drives.online='YES' and
paths.online='YES' and drives.DRIVE_NAME=paths.DESTINATION_NAME and
drives.drive_state='EMPTY'






***********************************************************************
NOTICE: This e-mail transmission, and any documents, files or previous
e-mail messages attached to it, may contain confidential or privileged
information. If you are not the intended recipient, or a person
responsible for delivering it to the intended recipient, you are
hereby notified that any disclosure, copying, distribution or use of
any of the information contained in or attached to this message is
STRICTLY PROHIBITED. If you have received this transmission in error,
please immediately notify the sender and delete the e-mail and attached
documents. Thank you.
***********************************************************************

<Prev in Thread] Current Thread [Next in Thread>