cancel
Showing results for 
Search instead for 
Did you mean: 

Query for status code 84/86, grouped by tape library

Caspar_Thorup
Level 2
Partner

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

1 ACCEPTED SOLUTION

Accepted Solutions

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

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.

View solution in original post

3 REPLIES 3

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

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.

Caspar_Thorup
Level 2
Partner

That did it. Thank you Riaan. 

Br Caspar

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

Pleasure.