What line should I add in the custom report to show extended retention information instead of basic. Here is a part of script I’m running with basic retention string:
Return resuls in the given order
SELECT CASE WHEN S.VMClientId > 0 THEN (SELECT name FROM APP_Client WITH (NOLOCK) WHERE id = S.VMClientId)
ELSE CL.name END AS 'Client',
IDA.name + CASE WHEN S.VMClientId > 0 THEN (' in ' + CL.name) ELSE '' END AS 'Agent',
dbo.FixInstanceName(INS.name, A.appTypeId) AS 'Instance',
BS.name AS 'Backupset',
A.subclientName AS 'Subclient',
C.PolicyName AS 'Storage Policy',
C.CopyName AS 'Copy',
C.StorageType AS 'Storage Type',
CASE WHEN AGE.retentionDays < 0 THEN 'INFINITE' ELSE CAST(AGE.retentionDays AS VARCHAR(10))+ ' day(s);' + CAST(AGE.fullCycles AS VARCHAR(10)) +' Cycle(s)' END AS 'Retention',
CAST(S.dataRead/1024.0/1024.0/1024.0 AS DECIMAL(10,2)) AS 'Application Size (GB)',
CAST(S.dataWritten/1024.0/1024.0/1024.0 AS DECIMAL(10,2)) AS 'Data Written (GB)',
ISNULL(CG.ClientGroups, 'N/A') AS 'Client Group'
This is output print screen:
