Clear audit data?

Moderator: NorbertKrupa

Post Reply
User avatar
Julie
Master
Master
Posts: 221
Joined: Thu Apr 19, 2012 9:29 pm

Clear audit data?

Post by Julie » Tue Sep 20, 2016 9:01 pm

Anyone know if there is a function to clear the LICENSE_AUDITS system table?
Thanks,
Juliette

scutter
Master
Master
Posts: 302
Joined: Tue Aug 07, 2012 2:15 am

Re: Clear audit data?

Post by scutter » Wed Sep 21, 2016 1:08 pm

I would hope that there’s no way to clear it. Otherwise HP would have no way to know if you’ve been within your license limit.

I see from the LICENSE_AUDITS view definition that it’s basedon vs_license_audits rather than a dc table which could be flushed.

—Sharon
Sharon Cutter
Vertica Consultant, Zazz Technologies LLC

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

Re: Clear audit data?

Post by NorbertKrupa » Sat Sep 24, 2016 9:08 pm

Julie wrote:Anyone know if there is a function to clear the LICENSE_AUDITS system table?
Create a new cluster. :lol:
Checkout vertica.tips for more Vertica resources.

Post Reply

Return to “Vertica SQL Functions”