Solved

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

Posted on 2010-09-09
7
913 Views
Last Modified: 2012-05-10
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.
0
Comment
Question by:mndthegap1
  • 4
  • 2
7 Comments
 
LVL 7

Expert Comment

by:oztrodamus
Comment Utility
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
 

Author Comment

by:mndthegap1
Comment Utility
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
 
LVL 7

Expert Comment

by:denbosse
Comment Utility
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:mndthegap1
Comment Utility
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
 

Author Comment

by:mndthegap1
Comment Utility
the other issue i have is the xml files change daily.
i would also need to specify only the import/export job history
0
 
LVL 7

Accepted Solution

by:
denbosse earned 500 total points
Comment Utility
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
 

Author Comment

by:mndthegap1
Comment Utility
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

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Microservice architecture adoption brings many advantages, but can add intricacy. Selecting the right orchestration tool is most important for business specific needs.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
This tutorial will walk an individual through the process of installing of Data Protection Manager on a server running Windows Server 2012 R2, including the prerequisites. Microsoft .Net 3.5 is required. To install this feature, go to Server Manager…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now