Hey folks,
I come here from the trixbox forums to post a little dashlet I've just whipped up.
trixbox is an asterisk/freepbx based distribution, and so this would work on any other freepbx setup. The idea is to pull reports on daily outbound calls made by our reps (prospecting), which is the most valuable information to us, along with the number of booked appointments each day (which I also have a dashlet for).
The premise here is to either have FreePBX use the same mysql DB as sugarCRM (or vice-versa), or to (like me) replicate the asteriskcdrdb.cdr table to your sugarCRM DB. Once that's done, the dashlet code is pretty simple. I have one for daily call volume and another for weekly call volume, also another for daily booked appointments, but that is based off another table I use for a custom asterisk script I've created.
I use a cdrmatchup table to match sugarCRM GUID's with their asterisk extension, so the dashlet shows sugarCRM usernames instead of extensions.

Here are a few screenshots:




There's a thread on the trixbox forums as well since a lot of users also use sugarCRM:
http://fonality.com/trixbox/forums/t...volume-dashlet

Once again these are actual outbound calls made by the users on their IP phones, reported from the PBX. Not Calls scheduled through sugarCRM.

If there is interest from the community I could post the dashlet files, they are not module loadable at the moment though. Really just putting this out there to give others ideas, to us having a dashboard with these 3 reports is just great for management.