I've already written a VB script to determine the tape in the drive and report it back via the agent log. I've only tested it on BackupExec 10 so far. However, I plan on extending it to verify that the correct tape is in the drive. This requires allowing for various backup tape rotations and naming schemes to be supported. I'm trying to design something that's very flexible. If the wrong or no tape is inserted the plan is to notify the on-site person(s) and myself. This way I can "watchdog" that proper tape rotation is being followed.
I also plan on VB scripts to"watchdog" other backup methods. I currently have clients using tape, hard drive, DVD, and CD based backups.