How can I get sended quota

[Alberto Sousa]

Hello guys.
I would like to get values from quota and actual quota usage trough another script, to generate a simple report.
How can I get this values from database or cached files? Thanks in advance!

 

[Vpul Shah]

Hello Sousa,

You can run DB Query and get Quota actual usage in your script.

 

[Alberto Sousa]

Thank you Shah!
Can you help me with a little sample of script in php to get this values? I'm not familiarized with yii framework.
Where can I found this values in database? Can you help me with the table name and field?
Thank you in advance!!

 

[Vpul Shah]

Hello Alberto,

To get quota counter is Database query to run in mysql.

You dont need to know yii framework to do this. You can do it in PHP code also.

 

[Vpul Shah]

Database query is like this

SELECT COUNT(*) FROM mw_delivery_server_usage_log WHERE customer_id=1 and DATE(date_added) BETWEEN '2020-07-01' AND '2020-07-30';

Hope this helps you.

 

[Alberto Sousa]

That's perfect! Thank you for your help! It's exacly what I needed, but sometimes the values of usage count resulted from database is diferent from dashboard info. Example: in my dashboard shows 5400 quota usage, but in sql result shows 5314. Do you know how can I get the exactly values?

Exist one way to change the value of quota usage had apears in customer dashboard directly in database or another place?

Thanks in advance.

 

[twisted1919]

but sometimes the values of usage count resulted from database is diferent from dashboard info

This is because in the application, the values are cached from time to time, the query gives you the real-time counter which is safe to use.