Forum Discussion

CarolineKiel's avatar
CarolineKiel
Level 6
11 years ago

Export Backup Selection list via BEMCLI

Hi, Is there a chance, to export a (or all) backup selection lists via PowerShell in BE2012? If I use "get-bejobs", I only get a summary like "<servername> (Partial), C: (Partial), D: (Partial)"...
2012
Backup and Recovery
Backup Exec
Configuring
Documentation
Reporting
Tip-How to
Windows Server (2003-2008)
  • CarolineKiel's avatar
    CarolineKiel
    11 years ago

    Hi everyone,
    I found out, that it is possible by simply querying the database directly:

    SELECT t2.[JobName]
    ,t1.[DeviceSelectionName]
    ,t1.[PathName]
    ,t1.[FileName]
    ,t1.[OperType]
    FROM [BEDB].[dbo].[vwScriptPropertiesBackup] t1,[BEDB].[dbo].[vwScriptJob] t2
    WHERE t1.scriptname = t2.scriptname AND t1.ScriptID <> '10011001-1001-1001-0101-010101010101'
    AND t1.ScriptID <> '10011002-1001-1001-0101-010101010101' AND t2.jobname <> 'NULL' AND t1.DeviceSelectionName <> 'NULL'

    The results are filtered to drop the default exclusions that BE does automatically.

    All the best from over here,
    Oliver

CarolineKiel's avatar
CarolineKiel
Level 6
11 years ago

Hi everyone,
I found out, that it is possible by simply querying the database directly:

SELECT t2.[JobName]
,t1.[DeviceSelectionName]
,t1.[PathName]
,t1.[FileName]
,t1.[OperType]
FROM [BEDB].[dbo].[vwScriptPropertiesBackup] t1,[BEDB].[dbo].[vwScriptJob] t2
WHERE t1.scriptname = t2.scriptname AND t1.ScriptID <> '10011001-1001-1001-0101-010101010101'
AND t1.ScriptID <> '10011002-1001-1001-0101-010101010101' AND t2.jobname <> 'NULL' AND t1.DeviceSelectionName <> 'NULL'

The results are filtered to drop the default exclusions that BE does automatically.

All the best from over here,
Oliver