Skip to main content
Question

Custom report using sql query


Forum|alt.badge.img+6

Hi Team,

 

I am trying to create a custom report for job count of different groups coming from different comcells. I need help in creating a sql query which can be used to fetch the data. 

 

Select jobhistory from table where comcellname is abc and clientgroup is xyz. 

Could someone please help me with this. 

4 replies

Forum|alt.badge.img+7

Hi @Rahul Nair 

my recommendation is to use the sql query from the built in backup summary report as a starting point and then modify it.


Forum|alt.badge.img+6
  • Author
  • Byte
  • 30 replies
  • June 14, 2024

Hi Team,

 

I am trying to use client backup history from metrics which has the input options to select the commserve and the client name but i want to modify the report to show counts of job history status in tabular format for different groups. Single report showing multiple tables of different groups. With this report i need to configure multiple reports for different groups. Is there a way wherein this can be modified in a single report. 


Forum|alt.badge.img+6
  • Author
  • Byte
  • 30 replies
  • June 28, 2024

Can someone please help me with this as a starting point. 

For eg Show last month job history where comcell name is abc and client group is xyz.


Scott Moseman
Vaulter
Forum|alt.badge.img+18

You might get in touch with your Account Team and see about engaging Commvault’s Personalization team for assistance with a custom report.

Thanks,
Scott
 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings