Getting an output of selections
I am looking to get an output of the selections of a particular backup job in Backup Exec. I want this output to be as a list to .txt format or to an Excel spreadsheet. I have tried querying the database and directing the output to Excel (.xls) but the column headers do not stay intact; by this I mean that all column headers are within one cell.
I can see in the database that there is a table called dbo.Resource which has three columns: ServerName, ResourceName, Resource2Name. By querying this table...
SELECT ServerName, ResourceName, Resource2Name FROM dbo.Resource
...you can easily get an output, but how do I know, infact how does the system know, which selection relates to which backup job? I have noticed there is another column called ResourceTypeId, maybe this is the identifier for the backup job that selection relates to? It would be nice to have something like:
SELECT ServerName, ResourceName, Resource2Name FROM dbo.Resource WHERE JobId = 'job1'
My overall aim is to output a list of the selections of a chosen backup job. I am aware that you can go to the Selections > View Selection Details (tab) which will give you an output but the kind of output looks like this:
D:\Users\*.* /SUBDIR D:\UselessStuff\*.* /SUBDIR /EXCLUDE \\A_SERVER\D:\directory1\*.* /SUBDIR \\A_SERVER\D:\directory2\*.* /SUBDIR \\ANOTHER_SERVER\D:\directory1\*.* /SUBDIR ... ...
Which has been deemed unreadable by most of our clients. They want an easy-to-read list of what is, and what isn't, being backed up.
I hope somebody out there can help me :)
Thank you in advance.