05-11-2021 05:41 AM - edited 05-11-2021 06:04 AM
Good afternoon All,
I was hoping is someone could point out which report template I could modify to report back only with server names with "DB" in it. I have looked through the templates but nothing seems to really fit what I am trying to achieve. Our SQL admins want a report that list the db servers, policy and backup selection. I am trying to write a custom query but I don't have the necessary experience.
Thank in advance :)
Ooops sorry could this be moved to the correct forum please. Did not mean to post it in the NetBackup forum. Thnx
05-11-2021 06:28 AM - edited 05-11-2021 06:29 AM
05-11-2021 06:30 AM
Well there is such report in Client Reports/Client summary dashboard.
export it to excel and then in excel filter out by column client name which contains db in there...
hope this helps?
05-11-2021 06:55 AM
Please can it be moved to OPScenter forum
05-11-2021 11:46 AM
05-12-2021 05:24 AM
Thanks for your suggestion. I took a look at the output and yes as you state we can filter on client names. But They want this on a regular schedule and I don't want to have to have any involvement and I wanted OPScenter to send it to them. Set and forget approach. The search continues :)
05-13-2021 04:01 AM - edited 05-13-2021 04:08 AM
I am not a DBA but maybe you can try this - if you have OpsCenter Analytics option. Go to My reports/new report
Run SQL query
and there try this out
select * from domain_Client where name like '%db%';
select name from domain_Client where name like '%db%';
05-21-2021 06:12 PM
Hi @Slartybardfast ,
To save yourself some valuable time, ask your DB support team to provide you lists of all their servers they want to backup or that are already in Netbackup policy. Once you receive this list, create an Opscenter view by adding the servers info provided to the view. Now set up opscenter report based on what they want to see such as policy information, start time/end time, backup size e.t.c.
You can then schedule an opscenter daily report that will be sent directly to the SQL team provided email address using this report.
How to create opscenter view : https://www.veritas.com/support/en_US/article.100045695?profileURL=https%3A%2F%2Fvam-profile.veritas...
Creating opscenter report : https://www.veritas.com/support/en_US/doc/67898349-127431275-0/v34977559-127431275
Schedule opscenter report : https://www.veritas.com/content/support/en_US/doc/67898349-127431275-0/v34977934-127431275