- Veeam Vanguard
- Posts: 549
- Liked: 219 times
- Joined: Sep 27, 2011 12:17 pm
- Full Name: Craig Dalrymple
- Location: Scotland
Looking for information around what metrics are collected/used to create the figures etc, as I'm interested in extracting the raw data for visualising elsewhere.
Thanks in advance
- Posts: 455
- Liked: 76 times
- Joined: May 02, 2012 1:49 pm
- Full Name: Sergey Goncharenko
With respect to counters - it's pretty much what you see in the UI, with respect to how it works - everything you need can be captured with SQL Profiler. However, I would recommend using Capacity Planning report instead of a widget. Widget SQL SP returns data in a special XML schema and it is going to be difficult to parse this data. On the other hand report SQL SP return numbers. Here is what I have in my lab in the profiler:
Code: Select all
exec dbo.Veeam_VE_VMware_PerformanceForecastGet @StartDate='2016-06-11 15:26:00',@EndDate='2016-08-10 15:26:00',@ReportSystemName=N'Veeam.Virt.Extensions.VMware.CapacityPlanning.Reports.ForecastVMCCR.LR',@ObjectList=N'<Data><Objects><Object Use="Containment">1265</Object></Objects></Data>',@RawThresholds=N'<Thresholds><Threshold Id="1" Value="90" /><Threshold Id="2" Value="90" /><Threshold Id="3" Value="0" /><Threshold Id="4" Value="0" /><Threshold Id="5" Value="0" /><Threshold Id="6" Value="0" /></Thresholds>',@SelectedAspects=N'<SelectedAspects><SelectedAspect TargetId="VMCCR" AspectId="CPU" /><SelectedAspect TargetId="VMCCR" AspectId="RAM" /></SelectedAspects>'
EndDate - how far in the future you want to check your resources
ObjectList - it's a root level All vSphere Clusters group, in my lab it's 1265, use the following to get rowid in yours:
Code: Select all
SELECT [ManagedEntityRowId] FROM [OperationsManagerDW].[dbo].[ManagedEntity] where [Fullname] like 'Veeam.Virt.Extensions.VMware.VMCCR.Group'
Let me know if you have any other questions.
Users browsing this forum: No registered users and 2 guests