Showing results for 
Show  only  | Search instead for 
Did you mean: 
Level 9
Report Inappropriate Content
Message 1 of 1

Quota archive fields interpretation

Hello there,

Is anybody able to provide an explanation of the comma separated values contained in each record of the quota.db?

We are going to deploy quotas to our organisation (it is currently configured for test users belonging to a particular active directory group only). When someone exceeds a volume quota (day, week or month), a blocking page will be displayed, where the user is able to decide to push a button and activate a time session with limited bandwidth, to keep on browsing anyway but with reduced resources; we also created a summary page for every user to check its current consumption. What we need now is a daily report to inform about the number of users who exceeded their quota.

From each node of the same runtime group we are able to extract the quota situation (/usr/bin/sqlite3 -line /opt/mwg/plugin/data/quota/quotas.db 'SELECT userConfig FROM userTable;'); here is what we get: userConfig = 1463409193#-120|v,0,0,0,0,1432343,154387102,113750908,0,0.

If we knew the meaning of the most relevan fields, we could crontab a script to extract the current status, isolate the relevant fields, count the records where the value exceeds the quota and transfer the results somewhere.

Up to now it would appear that v is for volume quota, c is for coaching quota, and that the three values (third, fourth and fifth from the right) indicate the current user situation, but which value corresponds to what parameter (day, week, month)?

Thank you and best regards,


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