Hi Morgan, There are some examples of extracting formatted metric data from Foglight using command line scripts in the blog article Foglight Reporting using Metric Queries or Groovy at [URL]  Hopefully that will give you some ideas. Regards, Brian Wheeldon
Our CIO is asking for hourly data so that he can create a historical record of our Virtual Environment using the data collected from vFoglight to present to the BODs so they can see ho we are utulizing the new environement they allowed us to purchase. I created a report for him but he doesn't want to have to copy and paste the data into an excel file every hour that is runs.   It looks like this:    So is there a way to allow Excel to connect to the SQL Server and pull this data so he can organize it himself? Or can we write a report that shows data by the hour like the following?  I.E.  1:00 AM - 42% 2:00 AM - 39% 3:00 AM - 41%
Pull Data from vFoglight SQL Database for Pivot Table/CUBE?