Query Backup Exec 12.5 to see which tapes are used for specific day

I am new to backup exec adn trying to figure some things out.
Currently running Backup exec 12.5 winth mssql on windows 2003 r2 box.

I want to query the bedb to be able to find which tapes are used on which days for each month.
does anyone know what table and or fields are used to get the daily tape information ?

the goal is to link this to an excel sheet and be able to select a day, a month, from a drop down
and have it pull up which tapes where used for that nights backup.

any help would be greatly appreciated.
mndthegap1Asked:
Who is Participating?
 
denbosseConnect With a Mentor Commented:
I don't have an example, but some of these links may get you started:
http://msdn.microsoft.com/en-us/library/aa468547.aspx 
http://www.w3schools.com/Dom/dom_nodes_get.asp
http://www.devguru.com/technologies/xml_dom/15891.asp


You could list all the files in the directory with the FileSystemObject (FSO) and only get those with a modified date of yesterday for example: http://www.devx.com/tips/Tip/13807 

By opening only the files for a certain date range and then getting values friom inside the XML to identify Import/Export job, tapes and dates.
0
 
oztrodamusCommented:
Your B/E logs tell you the name of the media used for that job. When you fist insert a tape B/E will auto assign a name to the tape. I would relabel your media so it's more meaningful. Also, if you have an autoloader you can partition it so the same tape is always used for a particular day. I do this for my Mon - Thurs tapes and rotate out my Friday Weeklys.
0
 
mndthegap1Author Commented:
thanks for the information, that actuallty helps with another issue. but what we change tapes each week. basically we have 6 tapes for the 1st monday of first week of month, 6 tapes for 2nd monday of 2nd week of month, and so on for each day.  so basically i would have to create a partition for each day of the month ?

but as for the excell sheet, we keep a writen log of the tapes used and i was just trying to automate this a little bit by pullling the info from the execdb.

i tried the following:

Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=BEDB;Data Source=libackup01\BKUPEXEC;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=MK00425;Use Encryption for Data=False;Tag with column collation when possible=False


this sort of works BUT if a tape is pulled for the nightly jobs say next morning, it will show up under that day not the night before.  i was looking to see if i can query when tapes are imported and exported.
It seems as thought there is not an entry in a table for that, since it only shows up on the xml file for the job history.

any help would be great.  also if you can explain your above aswell that would be much appreciated since that was something else i was looking into.

thanks again for all your help thus far i appreciate the info.
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
denbosseCommented:
Why not write a script that parses the XML of a job log (found in the data subfolder). That XML contains information about the name of the job (<name> tag), the start date/time (<start_time> tag) and the tapes used (<media_label> tag).
0
 
mndthegap1Author Commented:
that sounds like an excellent idea, but im not sure how to do that.
do you have a website or something that i can reference to write a script for that ?
0
 
mndthegap1Author Commented:
the other issue i have is the xml files change daily.
i would also need to specify only the import/export job history
0
 
mndthegap1Author Commented:
the issue with above is there are approx 6-7 xml files created each day and i need to run this for each day. BUT only 2 are for the imported media. so it will still pull every xml doc in the folder.
i appreciate the help.

im going to see if there is anything i can do with each of those.
and see if i can do something with it.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.