VM Growth Over Past N Days Derived Metric

Of course now that I think about it,being late and all, I should finish it off...

ds = server.get("DataService") // Data Service

qs = server.get("QueryService")  // Query Service

String query = "virtualMachinesPoweredOnCount from VMWCluster : name like '$scope.name' for 1 day 180 days ago" // Get all values from 1 day from 180 days ago

then = max(qs.queryObservations(query)) // Retrieves the max value over the time range above

now = ds.retrieveLatestValue(scope, "virtualMachinesPoweredOnCount").getValue().avg // Retrieves the current value

growthRate = ( (now - then) / 180 ) // Calculate current growth rate

return growthRate // Returns the growth rate

Here is an example for one at the cluster level that would look for the max value over a day from 6 months ago.  You could change it to look at say a 4 hour chunk, you need at least that for the default retention period, so you get data returned, or change to avg or min vs. I have max in there right now.

qs = server.get("QueryService")  // Query Service

String query = "virtualMachinesPoweredOnCount from VMWCluster : name like '$scope.name' for 1 day 6 months ago"

max(qs.queryObservations(query))

Nice script Thomas, I am able to quickly find a 30 day growth rate and manipulate the data where needed. The only issue that I am running into is if for some reason that particular day does not have any data for the cluster. Such as adding a new cluster into the environment with it being only days old versus a cluster that is months/years old and would have data.

I thought about doing a while loop a counting down the number of days but it appears I am not able to use a variable in the query where it say "for 1 day 180 days ago"

Sample while loop I was trying to get working:

numdays = 180
then = null

while (then == null) {
String query = "virtualMachinesPoweredOnCount from VMWCluster : name like '$scope.name' for 1 day numdays days ago" // Get all values from 1 day from 180 days ago

then = max(qs.queryObservations(query)) // Retrieves the max value over the time range above
numdays--

}

Thoughts on how to get around this?

Thanks,

Joshua

That would be a tremendous benefit to the community to not have to recreate the same scripts or even to drive customers to utilize the product in ways they may not have envinsioned out of the box.

Not one that I know of on the community site.  I keep a copy of all of the ones I can find on the forums for ths most part, so I have things to reference in the future.  We could make a little code house of sorts for these things.

This is great, thank you for following up and the script. I did have to add if (then >= 0){break}  numdays-- to prevent the number of days from reporting as 1 day less than what it really was.  Is there a script repository that patrons of the community can share and review?

I wouldl ike to use this script for some custom reporting. Where/How do I put this script into Vfoglight 6.7?

Thanks.

Chris,

The way I did it was add it as a Derived Metric.  You would take the entire script and paste it into the derived metric calculation with the Scope being a VMWCluster.  Once successfully added you can start producing reports with the newly created derived metric.