doExportQuotaHistory output
Results 1 to 2 of 2

Thread: doExportQuotaHistory output

  1. #1
    Senior Member
    Join Date
    Oct 2013
    Posts
    70

    doExportQuotaHistory output

    A new CLI command, "doExportQuotaHistory", is now available (ZeXtras 1.8.17). This command exports multiple monthly quota usage informations both in text and json format (very GNUPlot-friendly).
    I tried this new command and got this..

    Code:
    [zimbra@zm-mbox-01 ~]$ zxsuite admin doExportQuotaHistory users csv /tmp/quota.csv
    Quota usage data correctly exported to /tmp/quota.csv
    
    [zimbra@zm-mbox-01 ~]$ grep stsimb@ /tmp/quota.csv 
    stsimb@test.gr;ea6e1573-0116-4da8-b49b-53625f799612;27187436;3221225472;false;false;
    stsimb@test.gr;ea6e1573-0116-4da8-b49b-53625f799612;28134133;3221225472;false;false;
    stsimb@test.gr;ea6e1573-0116-4da8-b49b-53625f799612;24782920;3221225472;false;false;
    stsimb@test.gr;ea6e1573-0116-4da8-b49b-53625f799612;26615893;3221225472;false;false;
    stsimb@test.gr;ea6e1573-0116-4da8-b49b-53625f799612;25719144;3221225472;false;false;
    stsimb@test.gr;ea6e1573-0116-4da8-b49b-53625f799612;26715766;3221225472;false;false;
    stsimb@test.gr;ea6e1573-0116-4da8-b49b-53625f799612;25489156;3221225472;false;false;
    stsimb@test.gr;ea6e1573-0116-4da8-b49b-53625f799612;25890574;3221225472;false;false;
    stsimb@test.gr;ea6e1573-0116-4da8-b49b-53625f799612;26166285;3221225472;false;false;
    stsimb@test.gr;ea6e1573-0116-4da8-b49b-53625f799612;24709406;3221225472;false;false;
    stsimb@test.gr;ea6e1573-0116-4da8-b49b-53625f799612;24783967;3221225472;false;false;
    stsimb@test.gr;ea6e1573-0116-4da8-b49b-53625f799612;24836959;3221225472;false;false;
    stsimb@test.gr;ea6e1573-0116-4da8-b49b-53625f799612;24657135;3221225472;false;false;
    stsimb@test.gr;ea6e1573-0116-4da8-b49b-53625f799612;23763114;3221225472;false;false;
    stsimb@test.gr;ea6e1573-0116-4da8-b49b-53625f799612;25344403;3221225472;false;false;
    stsimb@test.gr;ea6e1573-0116-4da8-b49b-53625f799612;25826229;3221225472;false;false;
    stsimb@test.gr;ea6e1573-0116-4da8-b49b-53625f799612;26476916;3221225472;false;false;
    stsimb@test.gr;ea6e1573-0116-4da8-b49b-53625f799612;26080659;3221225472;false;false;
    stsimb@test.gr;ea6e1573-0116-4da8-b49b-53625f799612;26750121;3221225472;false;false;
    stsimb@test.gr;ea6e1573-0116-4da8-b49b-53625f799612;26420830;3221225472;false;false;
    stsimb@test.gr;ea6e1573-0116-4da8-b49b-53625f799612;26848609;3221225472;false;false;
    stsimb@test.gr;ea6e1573-0116-4da8-b49b-53625f799612;27590040;3221225472;false;false;
    stsimb@test.gr;ea6e1573-0116-4da8-b49b-53625f799612;28151703;3221225472;false;false;
    stsimb@test.gr;ea6e1573-0116-4da8-b49b-53625f799612;28940114;3221225472;false;false;
    stsimb@test.gr;ea6e1573-0116-4da8-b49b-53625f799612;29666743;3221225472;false;false;
    stsimb@test.gr;ea6e1573-0116-4da8-b49b-53625f799612;30391532;3221225472;false;false;
    stsimb@test.gr;ea6e1573-0116-4da8-b49b-53625f799612;31169401;3221225472;false;false;
    stsimb@test.gr;ea6e1573-0116-4da8-b49b-53625f799612;27127674;3221225472;false;false;
    stsimb@test.gr;ea6e1573-0116-4da8-b49b-53625f799612;27991222;3221225472;false;false;
    stsimb@test.gr;ea6e1573-0116-4da8-b49b-53625f799612;28437877;3221225472;false;false;
    stsimb@test.gr;ea6e1573-0116-4da8-b49b-53625f799612;785596579;3221225472;false;false;
    I would also expect a datetime column in the output... no ?
    What would gnuplot put on the time axis ?

  2. #2
    Jay
    Jay is offline
    Code Master ZeXtras Employee
    Join Date
    May 2011
    Posts
    26
    Hi stsimb,

    Yes the datetime column is actually missing, each row should be a day, that said we are trying to explain our devs what "easy to use" actually means in human terms in the next releases we will add a date column in way that is simply plottable from both gnuplot and libreoffice.

    In the meanwhile the simplest way to plot users information is:

    zxsuite admin doExportQuotaHistory users csv /tmp/users month 04/2014

    head -n1 /tmp/users > /tmp/myuser
    grep user@example.com; >> /tmp/myuser

    gnuplot
    set datafile separator ";"
    plot '/tmp/myuser' using 3 with lines title columnhead
    ZeXtras Website # ZeXtras Wiki # ZeXtras Store

    Head of ZeXtras Suite Developers

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •