There is no way to pull this data directly from the DB Repository. The Schema is not open.
You can pull this data out using groovy if you have to have it in excel.
If you are working with vFoglight the capacity planning reports should help instead of going down the excel path. vFoglight has a pretty strong reporting interface and could give you an hourly view or you could have the utilization over a month which might be more valuable to the Business.
I wanted to re-visit this with you. The Professional Services team built a solution for sale which will export any of the metrics/data collected by Fogligght/vFoglight to a medium which then could be stored into a Database of any type then allowing you to extract the data with excel or any other Database related tools.
DELL-Brian W
59 Posts
0
July 8th, 2011 03:00
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 http://en.community.dell.com/techcenter/performance-monitoring/foglight-administrators/w/admins-wiki/5654.foglight-reporting-using-metric-queries-or-groovy
Hopefully that will give you some ideas.
Regards,
Brian Wheeldon
rrowcliffe
4 Posts
0
July 8th, 2011 03:00
Morgan,
There is no way to pull this data directly from the DB Repository. The Schema is not open.
You can pull this data out using groovy if you have to have it in excel.
If you are working with vFoglight the capacity planning reports should help instead of going down the excel path. vFoglight has a pretty strong reporting interface and could give you an hourly view or you could have the utilization over a month which might be more valuable to the Business.
rrowcliffe
4 Posts
0
September 9th, 2011 20:00
Morgan,
I wanted to re-visit this with you. The Professional Services team built a solution for sale which will export any of the metrics/data collected by Fogligght/vFoglight to a medium which then could be stored into a Database of any type then allowing you to extract the data with excel or any other Database related tools.
http://www.quest.com/professional-services/foglight_services_packs.aspx