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
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 :)
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%';
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