Archieve sys audit

[Ak Islam]

Hi,

Just wondering if I can archive audit data (sys_audit). Seems like this table is not available for selection in the archive rules section.

Any help will be appreciated.

Thanks

Ak

[HarshTimes]

Hi Amdadul

Why you want to archive it? Servicenow have a feature of table rotation. sys_audit is part of this.You can find more details about the table rotation in below link.

http://wiki.servicenow.com/index.php?title=Table_Rotation#gsc.tab=0

[sergiu_panaite]

Not a good idea to archive sys_audit. What would be the reason for why you would like to archive it?

harshtimes Table sys_audit is under Table Rotation, but it is set to an "Extension" type rather than rotation which means it's not cleaned, but data stays permanently there.

[Ak Islam]

Hi,

Thanks for the reply. The reason to archive sys_audit is, the table has grown extremely large is size.

I understand that there are table rotation and expansion, but this capabilities still keep the data within parent table. Am I right?

Thanks

Ak  

[sergiu_panaite]

It is normal for sys_audit to grow large. As long as it has the right indexes on it (there are a number of indexes added out of box) then it should be ok. Keep in mind that audit table is not there for reporting, just for audits. From my own experience archiving is not a good idea for audit. What kind of challenges you have with this table, besides the fact it's large?