Can you provide SQL script for HEAT 2015.1 that will remove all but the last 2 months of ALL log files?

Version 1

    Details

    Can you provide SQL script for HEAT 2015.1 that will remove all but the last 2 months of ALL log files?




    Resolution

    This is an example that will delete all logs file within the last 60 days. 


    DELETE FROM [dbo].[Logs]
       WHERE LogTime < GETDATE()-60