cancel
Showing results for 
Search instead for 
Did you mean: 

OPS Center custom report

Slartybardfast
Level 5

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

7 REPLIES 7

Nicolai
Moderator
Moderator
Partner    VIP   

@Slartybardfast 

Where do you want it moved to ? OPScenter ?

/Nicolai

quebek
Moderator
Moderator
   VIP    Certified

Hey

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?

Please can it be moved to OPScenter forum

Nicolai
Moderator
Moderator
Partner    VIP   

Hi @Slartybardfast 

Post moved

Best Regards
Nicolai

Hi quebek,

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 :)

quebek
Moderator
Moderator
   VIP    Certified

Hello

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

or just 

select name from domain_Client where name like '%db%';

Dollypee
Moderator
Moderator
   VIP    Certified

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