Gertvdijk: markup

2010-06-24T13:35:34Z

markup

← Older revision		Revision as of 13:35, 24 June 2010
Line 1:		Line 1:
-	This script shows the ~~foldersizes~~ per folder of a users' ~~mailstore~~.	+	This script shows the folder sizes per folder of a users' mail store.
-		+

	Set the execute bit to the script, and then run the script as followed:		Set the execute bit to the script, and then run the script as followed:
Line 6:		Line 5:
	./foldersize.php [zarafa_username]		./foldersize.php [zarafa_username]
	</pre>		</pre>
-

	Prerequisites for the script:		Prerequisites for the script:
-	* Run the script on the ~~zarafa~~ server as this script connects to zarafa's ~~unix~~ socket.	+	* Run the script on the Zarafa server as this script connects to zarafa's UNIX socket.
-	* The ~~zarafa~~ server needs the ~~php mapi~~ extention installed.	+	* The Zarafa server needs the PHP MAPI extention installed.
-	* You need to have the php-cli package installed.	+	* You need to have the <tt>php-cli</tt> package installed.
-		+

	The script:		The script:
Line 151:		Line 148:
	</pre>		</pre>

-	Foldername "FINDER_ROOT" and the ones which start with "IPM_" are ~~mapi~~ folders and need to be there.	+	Foldername "<tt>FINDER_ROOT</tt>" and the ones which start with "<tt>IPM_</tt>" are MAPI folders and need to be there.

Msartor: New page: This script shows the foldersizes per folder of a users' mailstore. Set the execute bit to the script, and then run the script as followed:

 ./foldersize.php [zarafa_username] 
2010-06-24T13:30:38Z
New page: This script shows the foldersizes per folder of a users' mailstore.   Set the execute bit to the script, and then run the script as followed: <pre> ./foldersize.php [zarafa_username] </pre...
New page
This script shows the foldersizes per folder of a users' mailstore.





Set the execute bit to the script, and then run the script as followed:

<pre>

./foldersize.php [zarafa_username]

</pre>





Prerequisites for the script:

* Run the script on the zarafa server as this script connects to zarafa's unix socket.

* The zarafa server needs the php mapi extention installed.

* You need to have the php-cli package installed.





The script:

<pre>



#!/usr/bin/php



<?



function t() {

  return gettimeofday(true);

}



function prettyprint($size) {

    return floor($size/(1024)) . "KB";

}



$times = array();

$stime = t();



include('/usr/share/php/mapi/mapi.util.php');

include('/usr/share/php/mapi/mapidefs.php');

include('/usr/share/php/mapi/mapicode.php');

include('/usr/share/php/mapi/mapitags.php');

include('/usr/share/php/mapi/mapiguid.php');



include('/usr/share/php/mapi/class.recurrence.php');



function foldersize($store, $entryid)

{

    $size = 0;

    $folder = mapi_msgstore_openentry($store, $entryid);

    if(!$folder) { print "Unable to open folder."; return false; }

    

    $table = mapi_folder_getcontentstable($folder);

    if(!$table) { print "Unable to open table."; return false; }

    

    while(1) {

        $rows = mapi_table_queryrows($table, array(PR_MESSAGE_SIZE), 0, 100);

     

        if(count($rows) == 0) break;   

        foreach($rows as $row) {

            if(isset($row[PR_MESSAGE_SIZE])) { $size += $row[PR_MESSAGE_SIZE]; }

        }

    }

    

    return $size;

}



$times["load"] = t();



$session = mapi_logon_zarafa($argv[1], "", "file:///var/run/zarafa");



$times["logon"] = t();



$msgstorestable = mapi_getmsgstorestable($session);



$msgstores = mapi_table_queryallrows($msgstorestable, array(PR_DEFAULT_STORE, PR_ENTRYID));



$times["stores"] = t();



foreach ($msgstores as $row) {

    if($row[PR_DEFAULT_STORE]) {

        $storeentryid = $row[PR_ENTRYID];

    }

}



if(!$storeentryid) {

    print "Can't find default store\n";

    exit(1);

}



$store = mapi_openmsgstore($session, $storeentryid);



if(!$store) {

    print "Unable to open store\n";

    exit(1);

}



$root = mapi_msgstore_openentry($store);



if(!$root) {

    print "Unable to open root folder\n";

    exit(1);

}



$folders = mapi_folder_gethierarchytable($root, CONVENIENT_DEPTH);



$total = 0;

while(1) {

    $rows = mapi_table_queryrows($folders, array(PR_DISPLAY_NAME, PR_FOLDER_TYPE, PR_ENTRYID), 0, 100);

    

    if(count($rows) == 0)

        break;

        

    foreach($rows as $row) {

        // Skip searchfolders

        if(isset($row[PR_FOLDER_TYPE]) && $row[PR_FOLDER_TYPE] == FOLDER_SEARCH) continue;

         

        print isset($row[PR_DISPLAY_NAME]) ? $row[PR_DISPLAY_NAME] : "<Unknown>";

        print ": ";

        $size = foldersize($store, $row[PR_ENTRYID]);

        print prettyprint($size) . "\n";

        $total += $size;

    }

}    



print "Total: " . prettyprint($total) . "\n";



?>

</pre>







The script will output something like this:

<pre>

RSS Feeds: 0KB

Freebusy Data: 0KB

Junk E-mail: 0KB

Tasks: 0KB

Notes: 0KB

Journal: 0KB

Drafts: 0KB

Calendar: 0KB

Contacts: 0KB

Sent Items: 31KB

Deleted Items: 12KB

Outbox: 0KB

Inbox: 2446KB

Schedule: 0KB

Shortcut: 0KB

FINDER_ROOT: 0KB

IPM_VIEWS: 0KB

IPM_COMMON_VIEWS: 0KB

IPM_SUBTREE: 0KB

<Unknown>: 0KB

Total: 2491KB

</pre>



Foldername "FINDER_ROOT"  and the ones which start with "IPM_"  are mapi folders and need to be there.

View Foldersizes of a mailstore per folder - Revision history

Gertvdijk: markup