Hi Erwann!
As a matter of fact this one requires a little more care. Null can be the
result of a filespace backup which is interrupted and never restarted (i.e.
because it has been excluded from the backup) but you will also see null when
the filespace is only used for archiving. Creating an arc
You could get a bit more complicated in the archive case, and exclude
filespaces where o.type='Arch'
On Fri, Jan 29, 2016 at 03:09:22PM +, Loon, EJ van (ITOPT3) - KLM wrote:
> Hi Erwann!
> As a matter of fact this one requires a little more care. Null can be the
> result of a filespace backup
If you get to a definitive sql statement, would love to see it!
Rick
-Original Message-
From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Skylar
Thompson
Sent: Friday, January 29, 2016 10:14 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: SQL statement
You could get a
This is what I came up with:
SELECT -
f.node_name, -
f.filespace_name, -
f.backup_end, -
CAST(ROUND(o.physical_mb/1024) as int) as "GB Stored" -
FROM -
filespaces f, -
occupancy o -
WHERE -
o.node_name=f.node_name -
AND o.filespace_name=f.filespace_name -
AND ((o.type<>'
