Skip to main content
Solved

commvault Reporting


Forum|alt.badge.img+3

hi vaulter community, 

is there a report in commvault that can show when client’s first time backup date?

 

thanks a lot in advance

Ding

 

Best answer by dingdong

hi All, 

i can get the data from commServe Table APP_ClientInstallHistory

 

query :

 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 this

clientId    InstallDate    unInstallDate
2    2019-12-19 04:55:10.000    1970-01-01 00:00:00.000
3    2019-12-19 07:34:54.000    1970-01-01 00:00:00.000
4    2019-12-19 07:34:58.000    1970-01-01 00:00:00.000

copied the dateadd syntax from commserve getdatetime.sql 

cannot get first time backup. but still can represent the first time bakcup if the client really configured and backup in the same day.

 

thanks

Ding.

dingdong wrote:

hi vaulter community, 

is there a report in commvault that can show when client’s first time backup date?

 

thanks a lot in advance

Ding

 

 

View original
Did this answer your question?
If you have a question or comment, please create a topic

3 replies

Forum|alt.badge.img+15
  • Vaulter
  • 630 replies
  • March 12, 2022

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:

 


Forum|alt.badge.img+3
  • Author
  • Bit
  • 8 replies
  • March 12, 2022

hi @Orazan ,

thank you for responding, 

yes i had seen the report there but can not see the first time backup.

year ago i see it somewhere in csv report (too bad i lost it) 

hoping vaulter have idea how to get list of clients first time it was backup, maybe with custom reports.

thanks

Ding

 

Orazan wrote:

.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:

 

 


Forum|alt.badge.img+3
  • Author
  • Bit
  • 8 replies
  • Answer
  • March 13, 2022

hi All, 

i can get the data from commServe Table APP_ClientInstallHistory

 

query :

 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 this

clientId    InstallDate    unInstallDate
2    2019-12-19 04:55:10.000    1970-01-01 00:00:00.000
3    2019-12-19 07:34:54.000    1970-01-01 00:00:00.000
4    2019-12-19 07:34:58.000    1970-01-01 00:00:00.000

copied the dateadd syntax from commserve getdatetime.sql 

cannot get first time backup. but still can represent the first time bakcup if the client really configured and backup in the same day.

 

thanks

Ding.

dingdong wrote:

hi vaulter community, 

is there a report in commvault that can show when client’s first time backup date?

 

thanks a lot in advance

Ding

 

 


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