I am new to SQL query and need a hand.
If I run this: q act begind=-1 s=ANR1420
I obviousley get something like this,
09/18/06 15:35:44 ANR1420W Read access denied for volume QB3164 - volume access mode = "unavailable". (SESSION: 91400)
09/18/06 15:36:18 ANR1420W Read access denied for volume QB2887 - volume access mode = "unavailable". (SESSION: 91103)
The thing is, there can be thousands of lines like this, and I just want a simple query to take this data from a specific day and show me the list of tapes.
How would this be done?
If I run this: q act begind=-1 s=ANR1420
I obviousley get something like this,
09/18/06 15:35:44 ANR1420W Read access denied for volume QB3164 - volume access mode = "unavailable". (SESSION: 91400)
09/18/06 15:36:18 ANR1420W Read access denied for volume QB2887 - volume access mode = "unavailable". (SESSION: 91103)
The thing is, there can be thousands of lines like this, and I just want a simple query to take this data from a specific day and show me the list of tapes.
How would this be done?