Include/Exclude list and missed files

Hi all,

I ran into an issue over the weekend that I can't seem to figure out. We
had one of our developers delete a folder from one of our Windows
shares. I attempted to recover and realized that TSM had not been
backing up this particular share! They ended up spending all weekend
recreating the documents and I felt like a boob.

This is really a two part question. The first is this:

Does anyone have a query I can run against the database directly that
will give me a list of all files backed up for a node during the last
session? This will help as part of normal reporting. Previously we've
been relying on checking for errors on our jobs but obviously this won't
tell me WHAT was backed up.

The second part is the client option set for the server I'm pasting
below. Can anyone tell me why the \\clanas01\devteam share was NOT
getting backed up based on this? I know I'm missing something simple but
I want to make sure something else hasn't been getting missed. I created
a test directory with a few different filetypes under that share and
none of them got backed up last night.

The server is running on Win2k and is TSM Version 5, Release 2, Level 3.0

Thanks in advance,
John

                     Optionset: CLANAS01
                   Description: Specific option set for the NAS
Last Update by (administrator): ADMIN
              Managing profile:



         Option: CHANGINGRETRIES
Sequence number: 0
       Override: Yes
   Option Value: 3

         Option: DOMAIN
Sequence number: 0
       Override: Yes
   Option Value: \\clanas01\backup

         Option: DOMAIN
Sequence number: 1
       Override: Yes
   Option Value: \\clanas01\devteam

         Option: DOMAIN
Sequence number: 2
       Override: Yes
   Option Value: \\clanas01\documentation

         Option: DOMAIN
Sequence number: 3
       Override: Yes
   Option Value: \\clanas01\HPNT

         Option: DOMAIN
Sequence number: 4
       Override: Yes
   Option Value: \\clanas01\InstallPoint

         Option: DOMAIN
Sequence number: 5
       Override: Yes
   Option Value: \\clanas01\Paul

         Option: DOMAIN
Sequence number: 6
       Override: Yes
   Option Value: \\clanas01\Reporting

         Option: DOMAIN
Sequence number: 7
       Override: Yes
   Option Value: \\clanas01\SHR_CIO

         Option: DOMAIN
Sequence number: 8
       Override: Yes
   Option Value: \\clanas01\Users

         Option: DOMAIN
Sequence number: 9
       Override: Yes
   Option Value: \\clanas01\VSS-Webloan

         Option: DOMAIN
Sequence number: 10
       Override: Yes
   Option Value: \\clanas01\distribution

         Option: INCLEXCL
Sequence number: 0
       Override: Yes
   Option Value: "EXCLUDE '\\clanas01\users\...\NTUSER.DAT'"

         Option: INCLEXCL
Sequence number: 1
       Override: Yes
   Option Value: "EXCLUDE.DIR '\\clanas01\users\...\Recent\'"

         Option: INCLEXCL
Sequence number: 2
       Override: Yes
   Option Value: "EXCLUDE.COMPRESSION '*:\...\*.zoo'"

         Option: INCLEXCL
Sequence number: 3
       Override: Yes
   Option Value: EXCLUDE.COMPRESSION '*:\...\*.zip'

         Option: INCLEXCL
Sequence number: 4
       Override: Yes
   Option Value: EXCLUDE.COMPRESSION '*:\...\*.arc'

         Option: INCLEXCL
Sequence number: 5
       Override: Yes
   Option Value: EXCLUDE.COMPRESSION '*:\...\*.arj'

         Option: INCLEXCL
Sequence number: 6
       Override: Yes
   Option Value: EXCLUDE.COMPRESSION '*:\...\*.avi'

         Option: INCLEXCL
Sequence number: 7
       Override: Yes
   Option Value: EXCLUDE.COMPRESSION '*:\...\*.bz2'

         Option: INCLEXCL
Sequence number: 8
       Override: Yes
   Option Value: EXCLUDE.COMPRESSION '*:\...\*.bzip2'

         Option: INCLEXCL
Sequence number: 9
       Override: Yes
   Option Value: EXCLUDE.COMPRESSION '*:\...\*.cab'

         Option: INCLEXCL
Sequence number: 10
       Override: Yes
   Option Value: EXCLUDE.COMPRESSION '*:\...\*.dll'

         Option: INCLEXCL
Sequence number: 11
       Override: Yes
   Option Value: EXCLUDE.COMPRESSION '*:\...\*.exe'

         Option: INCLEXCL
Sequence number: 12
       Override: Yes
   Option Value: EXCLUDE.COMPRESSION '*:\...\*.gho'

         Option: INCLEXCL
Sequence number: 13
       Override: Yes
   Option Value: EXCLUDE.COMPRESSION '*:\...\*.gif'

         Option: INCLEXCL
Sequence number: 14
       Override: Yes
   Option Value: EXCLUDE.COMPRESSION '*:\...\*.gzip'

         Option: INCLEXCL
Sequence number: 15
       Override: Yes
   Option Value: EXCLUDE.COMPRESSION '*:\...\*.gz'

         Option: INCLEXCL
Sequence number: 16
       Override: Yes
   Option Value: EXCLUDE.COMPRESSION '*:\...\*.jpeg'

         Option: INCLEXCL
Sequence number: 17
       Override: Yes
   Option Value: EXCLUDE.COMPRESSION '*:\...\*.jpg'

         Option: INCLEXCL
Sequence number: 18
       Override: Yes
   Option Value: EXCLUDE.COMPRESSION '*:\...\*.lha'

         Option: INCLEXCL
Sequence number: 19
       Override: Yes
   Option Value: EXCLUDE.COMPRESSION '*:\...\*.lzh'

         Option: INCLEXCL
Sequence number: 20
       Override: Yes
   Option Value: EXCLUDE.COMPRESSION '*:\...\*.mov'

         Option: INCLEXCL
Sequence number: 21
       Override: Yes
   Option Value: EXCLUDE.COMPRESSION '*:\...\*.mp3'

         Option: INCLEXCL
Sequence number: 22
       Override: Yes
   Option Value: EXCLUDE.COMPRESSION '*:\...\*.mpeg'

         Option: INCLEXCL
Sequence number: 23
       Override: Yes
   Option Value: EXCLUDE.COMPRESSION '*:\...\*.mpg'

         Option: INCLEXCL
Sequence number: 24
       Override: Yes
   Option Value: EXCLUDE.COMPRESSION '*:\...\*.png'

         Option: INCLEXCL
Sequence number: 25
       Override: Yes
   Option Value: EXCLUDE.COMPRESSION '*:\...\*.psd'

         Option: INCLEXCL
Sequence number: 26
       Override: Yes
   Option Value: EXCLUDE.COMPRESSION '*:\...\*.rar'

         Option: INCLEXCL
Sequence number: 27
       Override: Yes
   Option Value: EXCLUDE.COMPRESSION '*:\...\*.sea'

         Option: INCLEXCL
Sequence number: 28
       Override: Yes
   Option Value: EXCLUDE.COMPRESSION '*:\...\*.sit'

         Option: INCLEXCL
Sequence number: 29
       Override: Yes
   Option Value: EXCLUDE.COMPRESSION '*:\...\*.sitx'

         Option: INCLEXCL
Sequence number: 30
       Override: Yes
   Option Value: EXCLUDE.COMPRESSION '*:\...\*.swf'

         Option: INCLEXCL
Sequence number: 31
       Override: Yes
   Option Value: EXCLUDE.COMPRESSION '*:\...\*.tgz'

         Option: INCLEXCL
Sequence number: 32
       Override: Yes
   Option Value: EXCLUDE.COMPRESSION '*:\...\*.tiff'

         Option: INCLEXCL
Sequence number: 33
       Override: Yes
   Option Value: EXCLUDE.COMPRESSION '*:\...\*.tif'

         Option: INCLEXCL
Sequence number: 34
       Override: Yes
   Option Value: EXCLUDE.COMPRESSION '*:\...\*.wav'

         Option: INCLEXCL
Sequence number: 35
       Override: Yes
   Option Value: EXCLUDE.COMPRESSION '*:\...\*.Z'

         Option: INCLEXCL
Sequence number: 36
       Override: Yes
   Option Value: EXCLUDE '*:\...\*.avi'

         Option: INCLEXCL
Sequence number: 37
       Override: Yes
   Option Value: EXCLUDE '*:\...\*.gho'

         Option: INCLEXCL
Sequence number: 38
       Override: Yes
   Option Value: EXCLUDE '*:\...\*.mov'

         Option: INCLEXCL
Sequence number: 39
       Override: Yes
   Option Value: EXCLUDE '*:\...\*.mp3'

         Option: INCLEXCL
Sequence number: 40
       Override: Yes
   Option Value: EXCLUDE '*:\...\*.mpeg'

         Option: INCLEXCL
Sequence number: 41
       Override: Yes
   Option Value: EXCLUDE '*:\...\*.mpg'

         Option: INCLEXCL
Sequence number: 42
       Override: Yes
   Option Value: "EXCLUDE '*:\...\pagefile.sys'"

         Option: INCLEXCL
Sequence number: 43
       Override: Yes
   Option Value: "EXCLUDE '*:\...\temporary internet files'"

         Option: INCLEXCL
Sequence number: 44
       Override: Yes
   Option Value: "EXCLUDE '\\clanas01\HPNT\GHOST\*.txt'"

         Option: INCLEXCL
Sequence number: 45
       Override: Yes
   Option Value: "EXCLUDE '*:\...\ntuser.dat'"

         Option: INCLEXCL
Sequence number: 46
       Override: Yes
   Option Value: EXCLUDE.SYSTEMOBJECT SYSFILES

         Option: INCLEXCL
Sequence number: 47
       Override: Yes
   Option Value: "EXCLUDE 'E:\...\*'"

         Option: INCLEXCL
Sequence number: 48
       Override: Yes
   Option Value: "EXCLUDE 'E:\*'"

         Option: INCLEXCL
Sequence number: 49
       Override: Yes
   Option Value: "EXCLUDE '\\clanas01\users\...\temporary internet
files\*'"

         Option: INCLEXCL
Sequence number: 50
       Override: Yes
   Option Value: "EXCLUDE '\\clanas01\users\...\temporary internet
files\...\*'"

         Option: INCLEXCL
Sequence number: 51
       Override: Yes
   Option Value: "EXCLUDE '?:\...\temporary internet files\...\*'"

         Option: INCLEXCL
Sequence number: 97
       Override: Yes
   Option Value: "INCLUDE '\\clanas01\Backup\...\*' LARGEMGMT"

         Option: INCLEXCL
Sequence number: 98
       Override: Yes
   Option Value: "INCLUDE '\\clanas01\Backup\Accounting01_backup\*.bak'
                  LARGEMGMT"

         Option: INCLEXCL
Sequence number: 100
       Override: Yes
   Option Value: "INCLUDE '\\clanas01\devteam\...\*' "

         Option: INCLEXCL
Sequence number: 101
       Override: Yes
   Option Value: "INCLUDE '\\clanas01\devteam\*' "

         Option: INCLEXCL
Sequence number: 103
       Override: No
   Option Value: "INCLUDE '\\clanas01\devteam\...\*.war' WARFILES_MGMT"

         Option: INCLEXCL
Sequence number: 104
       Override: Yes
   Option Value: "INCLUDE '\\clanas01\devteam\vssdb\*' VSSDB_MGMT"

         Option: INCLEXCL
Sequence number: 105
       Override: Yes
   Option Value: "INCLUDE '\\clanas01\devteam\vssdb\...\*' VSSDB_MGMT"

         Option: INCLEXCL
Sequence number: 107
       Override: Yes
   Option Value: "INCLUDE '\\clanas01\g$\devteam\vssdb\...\*' VSSDB_MGMT"

         Option: INCLEXCL
Sequence number: 108
       Override: Yes
   Option Value: "INCLUDE '\\clanas01\g$\devteam\vssdb\*' VSSDB_MGMT"