We use JIVE Onpremise & over period of time the DB has outgrown in size. We need to optimize DB usage by clearing all content older than 1 year.
Kindly provide steps / SQL script to clean up the data older than 1year without affecting the functionality and configuration.
We need a way to clear data in bulk for JIVE_MAIN, JIVE_Analytics & JIVE_Activity.
NOTE: Its a Test DB system in Test environment hence we are ok to delete data but should not affect functionality / configurations.
Retrieving data ...