commvault Reporting

Question

hi vaulter community, is there a report in commvault that can show when client’s first time backup date? thanks a lot in advanceDing

dingdong · Accepted Answer

hi All,i can get the data from commServe Table APP_ClientInstallHistoryquery :SELECT [clientId], dateadd(ss, installTime%86400, dateadd(dd, installTime/86400, '01/01/1970')) as InstallDate, dateadd(ss, uninstallTime%86400, dateadd(dd, uninstallTime/86400, '01/01/1970')) as unInstallDate   FROM [CommServ].[dbo].[APP_ClientInstallHistory]the result will be similar like thisclientId InstallDate unInstallDate2 2019-12-19 04:55:10.000 1970-01-01 00:00:00.0003 2019-12-19 07:34:54.000 1970-01-01 00:00:00.0004 2019-12-19 07:34:58.000 1970-01-01 00:00:00.000copied the dateadd syntax from commserve getdatetime.sqlcannot get first time backup. but still can represent the first time bakcup if the client really configured and backup in the same day.thanksDing.hi vaulter community,is there a report in commvault that can show when client’s first time backup date?thanks a lot in advanceDing

Orazan · Answer

Ding,Good morning. Have you tried to run a Job Summary report from the Command Center for the client mentioned? You can select the client and a time range and it will show all jobs within that range:

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded