NDMP backup reporting.

        I know that many of us in TSM land have started to jump on the
NDMP bandwagon, me included. I have a few questions that I'm hoping
someone else has already figured out. I'm not finding it in the
archives, so I will ask.

        Basically it has to do with the scheduling and reporting of the
NDMP backups.

        We have a ton of volumes and q-trees that we have just started
to back up through NDMP. We are running the "backup node NETAPP
/vol/vol1" type commands on  the TSM server. To automate this, the
logical way is to create a script with a bunch of "backup node" commands
with "wait=yes" after each one to run them serially to the tape drive.

        Simple enough, however when we group them this way, when the
administrative schedule fails to run one of the backups, it's very
non-descript as to which backup failed, so you have to slog through the
accounting log looking for it.
        
        I was thinking that this problem could be somewhat fixed if I
could put out a report that told me which NDMP q-trees/volumes were
backed up in the last 24 hours and which ones were not. Any volume that
didn't get a backup in the last 24 hours would need to be looked into.

        The output from a "q nasbackup NETAPP *" is a good start, with
output like this:

Node Name       Filespace   Object Type Object Size  Creation  Has Table
of 
                Name                           (MB)    Date    Contents

                                                               (TOC)?

--------------- ----------- ----------- ----------- ----------
-------------
BOFS11          /common     Full Image        428.5 04/22/05   Yes

                                                     13:24:15

BOFS11          /common     Differenti-       361.2 04/25/05   Yes

                             al Image                12:14:54

BOFS11          /temp       Full Image        409.4 04/22/05   Yes

                                                     13:25:37

BOFS11          /temp       Differenti-       268.5 04/25/05   Yes

                             al Image                15:21:19

BOFS11          /secure     Full Image    662,875.1 04/22/05   Yes

                                                     15:27:12

BOFS11          /secure     Differenti-     7,899.1 04/25/05   Yes

                             al Image                12:15:27       

        So, I'm thinking that with some clever sql queries, I could
generate what I want, however, I can't find the tables/columns that
generate this output. The filesspace name and the dates seem to come
from the FILESPACE table, but I'm not finding where it gets the  Object
size, the Object type or the TOC listing from. Any ideas?

        Or more importantly, does anyone have a better way to report on
NDMP backup failures/successes before I go and reinvent the wheel?

Thanks,
Ben