satis egitimisatis


Discussion on the state of cloud computing and open source software that helps build, manage, and deliver everything-as-a-service.

  • Home
    Home This is where you can find all the blog posts throughout the site.
  • Categories
    Categories Displays a list of categories from this blog.
  • Tags
    Tags Displays a list of tags that has been used in the blog.
  • Bloggers
    Bloggers Search for your favorite blogger from this site.
  • Login
Posted by on in CloudStack Tips
  • Font size: Larger Smaller
  • Hits: 9872
  • Print
  • Report this post

Using Microsoft Excel to analyze CloudStack usage records

A few months back during Cloud Expo, I had a chance to talk with Alex Bederov from Nokia and he showed me a spreadsheet that Nokia was using to analyze the usage reports from CloudStack. I thought this was fascinating, particularly from a private cloud perspective. While there are products like Amysta or CloudPortal that handle taking the usage records and billing against them, private clouds typically don't need that same level of billing services. This is a wonderful middle ground. In the interim Alex has written up his way of interacting with CloudStack usage database - and we've now published it as a KB article

Alex was quite nice and even provided a sample spreadsheet to look at, and it's linked at the bottom of the KB article. 

Hopefully this will benefit a lot of folks just looking to do some basic reporting against the usage database. 

Rate this blog entry:
Trackback URL for this blog entry.
David Nalley is currently employed by Citrix as the Community Manager for the CloudStack project. In addition he's a long time contributor to the Fedora Project, where among other things he is currently serving on the Fedora Project Board. He's also contributed to in various forms to Cobbler, Zenoss,, OLPC Math4, and Sahana. He is a frequent speaker at Free Software conferences around the nation, and writes for a number of technical and open source media publications including Linux Pro Magazine and
  • No comments made yet. Be the first to submit a comment

Leave your comment

Guest Saturday, 19 July 2014


Citrix supports the open source community via developer support and evangeslism. We have a number of developers and evangelists that participate actively in the open source community in Apache Cloudstack, OpenDaylight, Xen Project and XenServer. We also conduct educational activities via the Build A Cloud events held all over the world.