cancel
Showing results for 
Search instead for 
Did you mean: 
denniz
Level 9
Report Inappropriate Content
Message 1 of 2

Database keeps growing, need cleanup

Our EPO database keeps growing, and i'm looking to see if i can cleanup some tables (mostly log records). I've enabled some purge server task within Epo 4.6.6, so many tables are cleaned now.

But there is one table that draws my attention: dbo.EPOProductSettingValues.

It has a rowcount of 32235, and i'm wondering (looking at the name of the table) if Epo really has 32-thousand different product settings....

Is there a way to cleanup this table, and with which query?

Also i found some other tables that seem very large. Is it possible to purge some records?

Here a complete list of our large tables:

TableRowCnt
dbo.EPOProductSettingValues32345
dbo.OUIs12550
dbo.EPOServerEvents10321

Message was edited by: denniz on 1/8/14 5:04:31 AM CST
1 Reply
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 2 of 2

Re: Database keeps growing, need cleanup

Hi...

This is almost certainly normal. EPOProductSettingValues can have a very large rowcount - it contains every single setting for each product installed on every machine. Please do not, under any circumstances, try to modify this table.

OUIs contains a list of vendor MAC addresses, and should essentially be static. We update the contents of this table occasionally but it should stay pretty much the same.

EPOServerEvents contains details of things like pull tasks and replication tasks, as far as I know.

HTH -

Joe