ADSM-L

[ADSM-L] another sql query problem

2013-07-31 13:57:23
Subject: [ADSM-L] another sql query problem
From: "Lee, Gary" <GLEE AT BSU DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 31 Jul 2013 17:55:09 +0000
If I run the following script with the command

Run listback node_name 20

I receive a list of 128 objects.

However, a check of the dsmsched.log file shows the following:

07/31/2013 07:53:26 Total number of objects inspected:      634,241
07/31/2013 07:53:26 Total number of objects assigned:        61,461
07/31/2013 07:53:26 Total number of objects backed up:       13,732

What is up with this?
I am trying to get a report of all files backed up for this run.

Script follows:




/* parms:  node_name hours from today */
/* sample command: */
/* run listbackfiles libdi 24 */
/* */
/* lists files backed up for node libdi 1 day before today */
/* */

set sqldisp wide
select filespace_name, concat(hl_name, ll_name) as name, -
backup_date -
from backups where -
date(backup_date)> date(current_timestamp - $2 hours) -
and node_name = upper('$1') -
order by backup_date

<Prev in Thread] Current Thread [Next in Thread>
  • [ADSM-L] another sql query problem, Lee, Gary <=