Terry, the date is available from the sql backup table. Try a query like
this --
select hl_name, ll_name, date(backup_date) as bkdate, -
date(deactivate_date) as deldate, class_name -
from adsm.backups -
where state = 'INACTIVE_VERSION' -
and type = 'FILE' -
and node_name = 'fillin_in_uppercase' -
and filespace_name = 'fillin_case_matters' -
> c:\sql.out
The query results will be in file c:\sql.out. The dashes at the end of
each line are needed. I suggest you cut and paste this to a file such as
c:\sql.in, then in a cmdline admin client say --
macro c:\sql.in
--
--------------------------
--------------------------
Bill Colwell
Bill Colwell
C. S. Draper Lab
Cambridge, Ma.
bcolwell AT draper DOT com
--------------------------
In <OFF17459A6.31D14F5C-ON852568BD.0050793D AT champint DOT com>, on 04/10/00
In <OFF17459A6.31D14F5C-ON852568BD.0050793D AT champint DOT com>, on 04/10/00
at 02:59 PM, Terry Taylor <taylota AT CHAMPINT DOT COM> said:
>Hello all,
>Do any of you know a way to determine the date that a file on a server
>goes to Inactive? I have an NT file server that keeps the last inactive
>version around for 180 days. If I bring the ADSM client up on the
>server, I can display both active and inactive files. And I can see the
>dates that the file was created and backed up. But I would also like to
>see the date that the file went inactive. This would also be the date
>the file was deleted from the file server.
>In the particular instance I am looking at, I have a file that was last
>backed up on 2/20/1999. It is the ONLY version of the file and it is
>currently flagged as inactive. I would like to verify that this file
>will indeed drop off after 180 days. But without being able to determine
>when the file was actually deleted, or the date it went inactive(should
>be the same day), I'm not sure how this can be accomplished. Any ideas?
>Due to ongoing capacity issues(sound familiar?), I need to verify that
>things are dropping off when they should. Thanks!
>Particulars:
>ADSM Server: 3.2.2.20
>ADSM Client: 3.1.06
|