Do we have any report to get all configured retention details ?

rajasekar

Do we have any report to get all configured retention details? If any have means please share.

Seashore

Hi

You can use below query as a base to create the report:

SELECT 
    S.SettingID
    ,S.Name
    ,S.Description
    ,S.Units
    ,S.Minimum
    ,S.Maximum
    ,S.CurrentValue
    ,S.DefaultValue
    , CASE
        WHEN S.CurrentValue!=S.DefaultValue THEN 'Not Default'
        WHEN S.CurrentValue=S.DefaultValue THEN 'Default'
    END AS Status
FROM Orion.Settings AS S
WHERE Name LIKE '%Retention%'