Not sure if you found a solution to this yet, and I don't have an environment where I can research this further - but I found the following info:
Apparently there is a "hidden" parameter under Backup All Jobs that is described as such:
Instance Name - Name of the database instance backed up (hidden field)
If they really mean "database instance", I would expect that parameter to have the database names that were backed up in the SQL backup job. If not, well ...
The only other thing I can think of - you mention that "you" cannot run a query to the database(s); is DPA set up in a manner that it can query the database(s) and find out if they have been backed up? If so, you could just point at the SQL server and databases instead of pointing at the Avamar jobs.
Not a SQL or DPA guru - but I have been known to creatively skin felines on occasion.
connolly
2 Intern
•
132 Posts
0
July 12th, 2019 08:00
Not sure if you found a solution to this yet, and I don't have an environment where I can research this further - but I found the following info:
Apparently there is a "hidden" parameter under Backup All Jobs that is described as such:
Instance Name - Name of the database instance backed up (hidden field)
If they really mean "database instance", I would expect that parameter to have the database names that were backed up in the SQL backup job. If not, well ...
The only other thing I can think of - you mention that "you" cannot run a query to the database(s); is DPA set up in a manner that it can query the database(s) and find out if they have been backed up? If so, you could just point at the SQL server and databases instead of pointing at the Avamar jobs.
Not a SQL or DPA guru - but I have been known to creatively skin felines on occasion.