Hi. This is simple question, basicly for someone who knows where in database are proper information.
I need to get list of queues with summarized sizes of them.
postmaster 5GB
some other one 10GB,
etc.
Simple sql query will be enough, but do someone know what to get from DB ?
How to get size of queues
Moderator: crythias
-
- Administrator
- Posts: 3934
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: How to get size of queues
Hi,
Size could be everything. DO you talkt about numbers of tickets, numbers of articles, sizes of attachments, ...?
- Roy
Size could be everything. DO you talkt about numbers of tickets, numbers of articles, sizes of attachments, ...?
- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
-
- Znuny newbie
- Posts: 30
- Joined: 25 Jan 2017, 13:59
- Znuny Version: 6.0.6
- Real Name: Karol
- Company: Core Networks
Re: How to get size of queues
Size of attachments /Space on Disk
basicly I think it's content_size from article_data_mime_attachment table.
But calculated for every queue.
basicly I think it's content_size from article_data_mime_attachment table.
But calculated for every queue.
-
- Administrator
- Posts: 3934
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: How to get size of queues
Hi,
Do you have the attachments in the database or in the filesystem?
- Roy
Do you have the attachments in the database or in the filesystem?
- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
-
- Administrator
- Posts: 3934
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: How to get size of queues
Hi,
to get a rought idea of the size try this:
- Roy
to get a rought idea of the size try this:
Code: Select all
SELECT
table_name,
round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB`
FROM information_schema.TABLES
WHERE table_schema = "otrs"
AND table_name = "article_data_mime_attachment"
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?