ADSM-L

Re: filespace reporting question

2001-12-12 12:00:16
Subject: Re: filespace reporting question
From: "Seay, Paul" <seay_pd AT NAPTHEON DOT COM>
Date: Wed, 12 Dec 2001 11:56:11 -0500
I have not tried it but typically, SQL dates are in a format of
YYYY-MM-DD-hh.mm.ss.nnnnnn.

Have you tried Current_timestamp?

The following sql command generated output like what follows:

select filespace_name as "Filespace", node_name as "Node",
current_timestamp-backup_end as "time since backup" from filespaces

SYSTEM OBJECT          NPRDBPN1                      0 13:43:08.000000
\\nprdbpn1\c$          NPRDBPN1                      0 13:48:14.000000
\\nprdbpn1\e$          NPRDBPN1                      0 13:48:06.000000
\\nprdbpn1\f$          NPRDBPN1                      0 13:47:58.000000
\\nprdbpn1\g$          NPRDBPN1                      0 13:46:29.000000
\\nprdbpn1\h$          NPRDBPN1                      0 13:46:11.000000
\\nprdbpn1\i$          NPRDBPN1                      0 13:43:27.000000

Based on a quick look at the SELECT help, it looks like you could do almost
anything.

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