Video Screencast Help
Scheduled Maintenance: Symantec Connect is scheduled to be down Saturday, April 19 from 10am to 2pm Pacific Standard Time (GMT: 5pm to 9pm) for server migration and upgrade.
Please accept our apologies in advance for any inconvenience this might cause.

Export Selection Lists in Backup Exec 2010 R2

Created: 26 Apr 2011 • Updated: 26 Apr 2011 | 6 comments
This issue has been solved. See solution.

We are running Backup Exec 2010 R2 and I'm looking for a way to export the selection lists, is this possible?

I need to create a database of the folders/files we backup for each job and figured exporting to an excel spreadsheet would work but I don't see this option available.

Comments 6 CommentsJump to latest comment

ZeRoC00L's picture

There is no direct way to export the selection lists.

You probably can export it, but you will need to dig into the database. It can be done with excel or something.

If this response answers your concern, please mark it as a "solution"

mbjoe's picture

I found kind of a workaround, I can copy/paste the selection lists from the Properties window.

Not as simply as exporting but it will work.

AmolZeroCool's picture

Not sure if the below link will work for BE2010.

http://www.symantec.com/docs/TECH43218

Amol

MCITP | STS | SCP 
______________________________________________________________
If this response answers your query, do mark it as a solution
RahulG's picture
To query the Backup Exec Database (BEDB) and to export the backup selection lists to an external Microsoft Excel Spreadsheet, perform the following steps:
 
1) Confirm that Microsoft Office Excel is installed on the media server.
2) Open the Excel application.
3) Click on the Data Menu.
4) Click on "from other sources"  then select "From SQL Server".  The Data Connection Wizard then opens up.
5) Enter the server name: BackupExecMediaServerName\BKUPEXEC
6) Select the log on credentials to "Use Windows Authentication" and click "Next".
7) Select the BEDB database.
8) Check the option "connect to a specific table".
9) Select the following view: "vwScriptPropertiesBackup".
10) Click finish on the "Save data connection file and finish" Window.
11) Click OK in the "import data" window.  This opens the Excel sheet with all the details.  "ScriptName" list the names of all the jobs including backup jobs.
14) The ScriptName column can be sorted by the DeviceSelectionName, PathName and FileName to list the selection details for folders and file level detail.
 
Note:  Excel must have access to SQL Database ODBC Driversfor the procedure above to be successful.  These steps also only access the database as read-only, hence the database is not changed or altered in any way.
 
SOLUTION
Ken Putnam's picture

This comes up every so often here on the boards

I think there is a thread in the Ideas area on this already, if not you could add it there.  If it gets enough "thumbs up" it may be included in a future build

If this response answers your concern, please mark it as a "solution"

ZeRoC00L's picture

Ken,

I have searched and found the idea in the forum.

For those who like to vote, here you can find the idea:

https://www-secure.symantec.com/connect/idea/backup-exec-job-selection-exportimport

If this response answers your concern, please mark it as a "solution"