I don't know about a complete billing system but this might get your started:

CloudPlatform's API has some calls that could help you track people's usage. Have a look at :

http://download.cloud.com/releases/3.0.6/api_3.0.6/TOC_Root_Admin.html

There's a section called Usage. More specifically, I think this is the API call which would help you:

http://download.cloud.com/releases/3.0.6/api_3.0.6/root_admin/listUsageRecords.html

It isn't a billing system but it does provide information which would help you build one by returning needed values in an XML format.

Hello,

All i need is the records so i can have something to base my invoices on.
like: http://cloud.dzone.com/articles/analyzing-cloudstack-usage

Kind regards
Gert

I could be wrong but based on the fact that OP referred to an "excel spreadsheet solution", I think he's looking for a free, perhaps FOSS solution.

It does not have to be free, but i just do not have the a lot of requerements.
And the system does not have to send the invoices for me as we have another system for that.

But does have to be able to get the numbers my invoices should be based on.

Kind regards
Gert

The API call will definitely get you usage data and it's free.

Erik

If you're looking to extract the information from a DB like the link you provided, the information you're looking for is in a DB called cloud_usage:

mysql> use cloud_usage;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
----------------------------
| Tables_in_cloud_usage |
----------------------------
| account |
| cloud_usage |
| usage_event |
| usage_ip_address |
| usage_job |
| usage_load_balancer_policy |
| usage_network |
| usage_network_offering |
| usage_port_forwarding |
| usage_security_group |
| usage_storage |
| usage_vm_instance |
| usage_volume |
| usage_vpn_user |
| user_statistics |
----------------------------
15 rows in set (0.00 sec)

mysql>

Great,

Do you have a link for the tables in the cloud_usage and cloud db ?

Thank you Again..

Kind regards
Get

I'm not sure I understand your question. The information is found in cloud_usage and that database resides on your management server.

If you have a careful read of the URL you provided, you'll see that the poster provides an almost completed solution. the info he provides is enough to pull VM names and disk sizes and I'm assuming once that's done it's pretty easy to graph. You could look at what he did and and modify it for the other items such as CPU memory and network usage.

Erik

Hello tiqbal636,

that was exacty waht i meant, an explanation og the different tables..

thank you very much..

Kind regards
Gert

Correction, it pulls all needed info except for network.

Thanks for sharing Tariq.

Regards,
Erik G