Query for status code 84/86, grouped by tape library
We have two StorageTek SL8500 running most of our tape backups, and they are located in two different facilities. The one facility is not optimal and we want to compare drive read/write errors between the two libraries to see if the poor facility is having an effect.
My initial idea was an SQL query joining the domain_JobArchive table (for the statusCode column) with the domain_TapeLibrary table (for the serialNumber column). This did not work, as the count of status code 84 and 86 was the same for both libraries
The problem is that the domain_JobArchive does not store the statusCode information by anything I can use to distinguish the libraries, as far as I can tell.
Anyone have any ideas? Thanks in advance.
Caspar
If you look in nom_NBJob instead you can use the storage unit to correlate. Granted you might have multiple entries but at least it would tell you TLD X or TLD Y.