Increasing Service Portal log (sp_log) to more than 90-day default - Support and Troubleshooting

Increasing Service Portal log (sp_log) to more than 90-day default Issue  For reporting purposes, you might want to have the Service Portal Log Entries table (sp_log) store data for more than the 90-day default.

Note – Increasing the number of days stored in the log to more than the 90-day default could cause significant performance issues.

Release All versions using Service Portal

Resolution Days are stored in seconds so determine the number of seconds in the number of days you want to use. The OOB value of 90 days is 7,776,000 secs. Navigate to System Maintenance > Table Cleanup. Search for a rule with the tablename sp_log and open the record. Change Age in seconds to 31536000 (365 days in seconds). Save/submit the record. Related Links Apply Table Rotation