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. 

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.


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. 


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.


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