cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Former Member
Not applicable
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
JoeBidgood
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

You Deserve an Award
Don't forget, when your helpful posts earn a kudos or get accepted as a solution you can unlock perks and badges. Those aren't the only badges, either. How many can you collect? Click here to learn more.

Community Help Hub

    New to the forums or need help finding your way around the forums? There's a whole hub of community resources to help you.

  • Find Forum FAQs
  • Learn How to Earn Badges
  • Ask for Help
Go to Community Help

Join the Community

    Thousands of customers use the McAfee Community for peer-to-peer and expert product support. Enjoy these benefits with a free membership:

  • Get helpful solutions from McAfee experts.
  • Stay connected to product conversations that matter to you.
  • Participate in product groups led by McAfee employees.
Join the Community
Join the Community