Start a Conversation

This post is more than 5 years old

Solved!

Go to Solution

4458

March 1st, 2017 11:00

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.

Thanks

LS

SG_capacity_delta.PNG.png

68 Posts

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

Capturenew.JPG.jpg

The resulting number should show the correct difference as I get below.

CaptureNew2.JPG.jpg

I have updated the definition file in the link below.

VMAX Storage Groups Used Capacity Trend Definition

Thanks

Vaishak

68 Posts

March 2nd, 2017 07:00

Hello LCS

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.

SRM Time Mgmt.JPG.jpg

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.

VMAX Storage Groups Used Capacity Trend Definition

Please let me know if this helps.

Thanks

Vaishak

20 Posts

March 3rd, 2017 03:00

Hi Vaishak,

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.

timemagment.PNG.png

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.

68 Posts

March 3rd, 2017 07:00

Hello LCS

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.

VMAX Storage Groups Used Capacity Trend Definition

To upload a file you will have to use the create option at the top, and then insert a hyperlink to that document.

Capture.JPG.jpg

Thanks

Vaishak

20 Posts

March 3rd, 2017 09:00

Vaishak,

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.

delta_number.PNG.png

Thanks

20 Posts

March 5th, 2017 10:00

This is great Vaishak thanks.  It will give a the foundation to track other short term capacity usage changes.

What is the significance of adding the "L" in the formula?

68 Posts

March 6th, 2017 11:00

Hello LCS,

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.

Regards

Vaishak

1 Message

March 31st, 2020 20:00

Hi - bumping an old thread, but i need this report and the link to download the xml is dead.

Is there any chance you could provide a new link?

Thanks!

No Events found!

Top