Question

Custom reports for fetching job started by and job started from

  • 23 February 2024
  • 4 replies
  • 35 views

Badge +1

I want to fetch the job details by  “job started by” and “job started from”

 

job started by will give the admin/system who started the job

and job started from will give started by schedule or manual or gui etc.

 

Motive is to get the job details with the schedule details as well such that I can filter out only scheduled jobs excluding manually initiated jobs.

 

Can someone please help me to get the details form csdb , I am not able to find which db and which table to search for these details.


4 replies

Userlevel 2
Badge +9

Hi @ARVVI 

Fetching the above details from SQL server is not recommended because there are multiple tables involved to present the report on the webpage.

Hence you can download and import below client backup history report to understand the JOB ID and schedule name.

you may also use backup job summary report and add required columns to get more information on Job started details and who started

https://store.commvault.com/webconsole/softwarestore/store.do#!/135/660/29081

Userlevel 4
Badge +10

Hi @ARVVI ,

As far as I can see we don’t currently provide any default report that will allow to sort by user starting jobs or schedule triggering the job.

In order to meet your requirements, please contact your Sales Representative to discuss our Professional Services offering that will be able to assist reporting on the data you require.

Badge +1

Hi Javier,

 

Using this report we are seeing null data:

 

Userlevel 4
Badge +10

Hi @ARVVI ,

The Client Backup Details Report required to have The Metrics Private Server collection enabled. If this feature is not configured in your environment, the report will not show any information.

https://documentation.commvault.com/2023e/essential/metrics_reporting.html

Reply