We have 18000 site collections, and on site collection creation, auditing was enabled with all options, because at some point auditing logs will need to be checked, probably with an external tool like docAve.
The point here is that this uses lots of data, and 5 of our content dbs are over 100GB already.
When we checked the tables, in every content DB, the audit table is over 30GB. Is there a way to specifiy to sharepoint via powershell or something that the auditing should be kept for a specified number of days? what is the default number of days? or is this data kept forever?