I am planning to Archive and purge all the Tickets created before 1st jan 2016.
Can someone help me what additional query needs to be added while creating Archive and purge rule.
There are many OOTB Archive and Purge rules provided with CA SDM.
By default, these rules have an INACTIVE status.
You can simply activate one of the OOTB Archive and Purge rules (or create your ow) and set the value for the DAYS INACTIVE appropriately.
Please refer to the following documentation for further details
How to Archive and Purge Historical Data - CA Service Management - 17.1 - CA Technologies Documentation
Retrieving data ...