Has anyone found a way to get a report on a specific Servers uptime?
Are you looking for this to be scoped for a single VM at at time?
Yes single server maybe going back 1 year. We want to be able to prove our 99.9% uptime.
I don't know whether VMTurbo currently can create this kind of report, partially because "uptime" means different things to different people. Do you mean, simply, that your server is powered on? Or do you require that the applications on that server are processing transactions? Does "uptime" mean you have a Quality of Service guarantee (e.g. that if a Transaction takes longer than X seconds, does that count against the Uptime guarantee)?
Powered on only
Information about a a host ("physical machine") can be found in the pm_stats_by_*** tables in the database, where *** is hour, day, and month. Unfortunately for your purposes, there are at least two things that don't let you calculate what you want. First, there's nothing in those tables that tells you directly whether the machine was actually running. You can get an approximation by looking at the rows for the host with property_type "CPU" and property_subtype "utilization". These all then give you the average, minimum, and maximum utilization of the hour preceding the snapshot_time. If the minimum is non-zero, the machine was presumably up and running for the entire hour; but if it's zero, you can't really say anything with certainty.
The second limitation is that the by_hour table only goes back (by default) 72 hours. Then the statistics are rolled up into the by_day table. Now your resolution is only to the nearest day. Every 60 days, though, the daily statistics are rolled up into the by_month tables. The monthly tables are kept for two years - but now you're down to a resolution of a month.
You can change these retention periods, but a by_hour table for a year would be immense and access to it would be slow.
Perhaps someone will come up with some clever way to torture the data into an answer to your question; but I don't see a way to do better.
I'm not sure if this is still relevant, but I created a report for another customer and thought it might be relevant to your needs.
VM Uptime Report
This report looks at how many days in the past 30 the VM has reported CPU usage (powered on). You could always adjust the snapshot_time interval to go back longer.
Retrieving data ...