{"id":401,"date":"2024-07-10T14:10:22","date_gmt":"2024-07-10T07:10:22","guid":{"rendered":"https:\/\/ilmusekawan.web.id\/?p=401"},"modified":"2024-07-10T14:13:21","modified_gmt":"2024-07-10T07:13:21","slug":"mendapatkan-persentase-pemakaian-mailbox-user-zimbra-via-cli","status":"publish","type":"post","link":"https:\/\/ilmusekawan.web.id\/index.php\/2024\/07\/10\/mendapatkan-persentase-pemakaian-mailbox-user-zimbra-via-cli\/","title":{"rendered":"Mendapatkan Persentase Pemakaian Mailbox User Zimbra Via CLI"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Sebenarnya kalian dapat melihat persentase pemakaian quota mailbox tiap-tiap user pada menu monitor admin console Zimbra, tetapi hanya sebatas melihat dan tidak dapat diunduh atau diexport.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Bagaimana jika kalian ingin mendapatkan user yang persentase penggunaannya hampir atau sudah memenuhi batasan quota yang ditetapkan? Apakah kalian ingin meng-copy usernya satu persatu? Tentu tidak bukan.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Solusi<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code><strong>$<\/strong> zmprov gqu mail.lab.me | awk '$2 != 0 {printf \"%.0f%% %s\\n\", (($3\/$2)*100), $1}'\n\n22% admin@lab.me\n0% adm_acc@lab.me\n0% galsync.rsrusqy5@lab.me\n0% person@lab.me<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Breakdown<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Pertama-tama untuk mendapatkan data pemakaian quota mailbox tiap-tiap user, kita dapat menggunakan perintah <code><strong>zmprov gqu &lt;server-mailbox&gt;<\/strong><\/code><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><strong>$<\/strong> zmprov gqu mail.lab.me\n\nadmin@lab.me 2048000 443671\nadm_acc@lab.me 2048000 0\ngalsync.rsrusqy5@lab.me 2048000 0\nham.vbyoutmjqz@lab.me 0 0\nperson@lab.me 2048000 0<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Kurang lebih output dari perintah tersebut adalah seperti di atas.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Kolom pertama berisi email user, kolom kedua berisi kuota yang ditetapkan dalam satuan bytes, kolom ketiga berisi jumlah pemakaian juga dalam satuan bytes.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Kita gunakan program <code>awk<\/code> untuk memproses data di atas.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$2 != 0<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Field di atas kita gunakan untuk memfilter user tanpa batasan quota mailbox. Karena kita akan mencari persentase pemakaian, maka kita tidak tertarik dengan user tanpa batasan quota mailbox.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>(($3\/$2)*100)<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Field di atas kita gunakan untuk mendapatkan persentase pemakaian user dengan cara membagi kolom 3 dengan kolom 2 dan dikali 100 lalu dibulatkan kedepan.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Tambahan<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Kalian dapat menggunakan perintah <code>sort -n<\/code> untuk sorting hasil dari pemakaian terendah ke tertinggi.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sebenarnya kalian dapat melihat persentase pemakaian quota mailbox tiap-tiap user pada menu monitor admin console Zimbra, tetapi hanya sebatas melihat dan tidak dapat diunduh atau diexport. Bagaimana jika kalian ingin mendapatkan user yang persentase penggunaannya hampir atau sudah memenuhi batasan quota yang ditetapkan? Apakah kalian ingin meng-copy usernya satu persatu?&#8230;<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"telegram_tosend":false,"telegram_tosend_message":"","telegram_tosend_target":0,"footnotes":""},"categories":[12,34,35,4,1,13],"tags":[],"class_list":["post-401","post","type-post","status-publish","format-standard","hentry","category-linux","category-red-hat","category-rocky","category-tips-trick","category-ubuntu","category-zimbra"],"_links":{"self":[{"href":"https:\/\/ilmusekawan.web.id\/index.php\/wp-json\/wp\/v2\/posts\/401","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ilmusekawan.web.id\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ilmusekawan.web.id\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ilmusekawan.web.id\/index.php\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/ilmusekawan.web.id\/index.php\/wp-json\/wp\/v2\/comments?post=401"}],"version-history":[{"count":14,"href":"https:\/\/ilmusekawan.web.id\/index.php\/wp-json\/wp\/v2\/posts\/401\/revisions"}],"predecessor-version":[{"id":420,"href":"https:\/\/ilmusekawan.web.id\/index.php\/wp-json\/wp\/v2\/posts\/401\/revisions\/420"}],"wp:attachment":[{"href":"https:\/\/ilmusekawan.web.id\/index.php\/wp-json\/wp\/v2\/media?parent=401"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ilmusekawan.web.id\/index.php\/wp-json\/wp\/v2\/categories?post=401"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ilmusekawan.web.id\/index.php\/wp-json\/wp\/v2\/tags?post=401"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}