Export Veritas Backup Exec Selection Details using SQL

For a change, here is something different from PowerShell.

Below is SQL script for fetching Veritas backup selection details from Backup Exec.

Note: The backup job names in the backup server are having words “Monthly, weekly and daily” which we are using to in the script to fetch the selection information.

USE BEDB;
SELECT DISTINCT
	JobName
	, SC.ScriptDescription
	, RC.UserDefinedName
	,  DeviceSelectionName + '\' +  [PathName]  + [FileName]  as [PathName1]
FROM Scripts SC
LEFT JOIN [vwScriptPropertiesBackup] SPB
ON SC.ScriptID = SPB.ScriptID
LEFT JOIN jobs jj
ON SC.ScriptID = jj.ScriptID
LEFT JOIN [vwResourceContainer] RC
ON SPB.ResourceContainerID = RC.RCID
WHERE (
	jobname LIKE '%monthly%'
 -- OR jobname LIKE '%daily%'
 -- OR jobname LIKE '%weekly%'
 -- OR jobname LIKE '%yearly%'
 )
	AND [FileName] NOT LIKE ''
	AND jobname NOT LIKE '%Lotus%'
ORDER BY JobName, RC.UserDefinedName

By executing the above SQL script in SSMS, Here comes the output as shown below

The script works with Exec 16. Please test it for other versions of Backup Exec.

Thank you for reading my post. Hope this is helpful to you.

---