Skip to main content
Question

Custom report using sql query

  • 14 June 2024
  • 4 replies
  • 28 views

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

Userlevel 3
Badge +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.

Badge +6

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. 

Badge +6

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.

Userlevel 6
Badge +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