I'm having trouble pulling a report/view for management... they are looking for a list of Per VM how much virtual hardware assignment CPU or RAM has increased or decreased over the last year (or since VM creation). For instance something like this:
VM Name | CPU Delta | Initial CPU | Current CPU | Memory Delta (GB) | Initial Memory (GB) | Current Memory (GB) |
---|---|---|---|---|---|---|
VM1 | +1 | 2 | 3 | +4 | 4 | 8 |
VM2 | +4 | 2 | 6 | 0 | 4 | 4 |
VM3 | -2 | 12 | 10 | -6 | 18 | 12 |
VM(n) | ... | ... | ... | ... | ... | ... |
I know the delta math can easily be done in excel, but I can't figure a way to get the Initial and Current numbers that I need, out of vROps... Anyone know if this is possible, and how to do so? if not, are we using the wrong product for this type of thing? any suggestions welcome!
Thanks!!
This will show you the min cpu and the latest the VM has had over the last year. The problem is it wont reflect if a VM has change multiple times up and down.
if it started with 8 and dropped to 4 then went to 8 again you will see a min value of 4 and a latest of 8
If you started with 16 and went to 8 and it is still 8 the it will show you the min of 8 and latest of 8
The only way i know of to see changes like that is with a metric chart but does mot translate very well into a report
This will show you the min cpu and the latest the VM has had over the last year. The problem is it wont reflect if a VM has change multiple times up and down.
if it started with 8 and dropped to 4 then went to 8 again you will see a min value of 4 and a latest of 8
If you started with 16 and went to 8 and it is still 8 the it will show you the min of 8 and latest of 8
The only way i know of to see changes like that is with a metric chart but does mot translate very well into a report
Wow - that's the type of simple solution I knew I was missing somehow. Thank you - this will save me a lot of time!!!