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
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.
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.