ViPR SRM Report showing Storage Group Used Capacity Delta between two days.
I have tried to create a report that would show the Delta in used capacity between two days using one of the reports available in the VMAX library. I want to show two columns of Used Capacity for each Storage group on the VMAX arrays and provide a column with the Delta Capacity between day 1 and day 2, Since we are thin provisioning this should be a positive number.
I added a formula to the report to calculate using Delta, over 2 periods witch would be i assume 2 days. When I select the value in the Delta Column i see the graphic over time, but it is not consistent with the value or the two used capacity columns. Also the two days for % Used seem to be the same number even though I am aware of a Used Capacity increase between the two days.
Am i approaching this correctly?
The report is to help us track Used Capacity at a SG level over a short period of time. It would help us monitor the growth in our SRPs.
Iam not sure if this answers your question, but if you modify the Time Management on the the Used Capacity Column , you can get multiple columns generated that can show Used Capacity for each day . For Eg the settings in the Image below will generate Used Capacity each day of the week.
Also if you have used math.Delta formula to calculate the the Delta values and if you are on a version prior to SRM 4.1 then a small change needs to be made on the formula code.
Go into administration mode (click the gear icon) -> Modules -> Formula Editor
Choose File -> Open Source -> Math -> Delta,java
Look for “ (getElapsedTime(context) * 1000), “
Add a “ L” behind the 1000 as shown below:
(getElapsedTime(context) * 1000L),
Once you have added the “ L “, Choose File -> Save -> Save source and reload formula -> ok
I did modify one of my reports to show the Delta Values, below is the attached defenition.
Thank you for your response. I had already used the Time Management in my report to provide two columns for Used Capacity (GB) , one column for each of the last two days. I believe you can see it in the jpeg I included in my original question.
The time management I used was as indicated below.
We are on SRM v4.0.1 - does this formula modification still apply?
I am trying to attach my report xml but cannot, nor can I download your report. xml. Not sure what the issue is there.
I did realize later that you had used time management on your report, I did not take a closer look at the image initially.
If you are on v 4.0.1 then the formula modification will apply. From what I heard this fix is implemented in the next release (v 4.1) .
My report definition file would not have been approved my moderators by the time you checked, please try again, there should be a download option if you click on the link below.
I was able to download and import the report you provided. I am wondering why the Delta for the last day does not equal the difference between the Wednesday and Thursday. That is really the value I am looking for.
The goal is to identify the SG that is growing the fasted from a capacity used perspective.
Glad that it works for you, the significance of adding an L to the 1000 is to tell the function that it is a Long value and not an Int value so that it can take larger numbers.
nerdnair
1 Rookie
•
68 Posts
3763
0
Posted March 3rd, 2017 14:00
Hello LCS
Could you please make the below change on Time Management for SG Used Delta and SG Used% Delta Columns
The resulting number should show the correct difference as I get below.
I have updated the definition file in the link below.
VMAX Storage Groups Used Capacity Trend Definition
Thanks
Vaishak