Hello,
Could you help me with a creation date of VM?
I need to add to the report date when VM was created. I have found that VM in vROPS has a metric called Configuration|Creation Date but probably it is not human readable.
How can I convert it to a readable date? My license allows me to use a super metric if it can help.
Yes, in upcoming vROps 8.1 "views/reports" are already support " VM Configuration|Creation Date" value in human friendly format
It is epoch time. Normally you can use transformation to convert but you can't use it today to convert it to human readable time.
Will probably be fixed in the next version.
Yes, in upcoming vROps 8.1 "views/reports" are already support " VM Configuration|Creation Date" value in human friendly format
RobertMesropyan
i'm on 8.1 and although the creation date is human readable...it is not accurate. I have VMs showing creation date of 2,862 weeks ago and my environment is only 4 years old. Can you show me a working view or report or provide help on why I am still not seeing correct info? Will you only see correct date for VMs created after 8.1 installed?
Hi albogadocmeg, please try attached _VM_CreationDate view
Thanks RobertMesropyan appreciate your help, I believe the transformation was the key element I missed. This will do nicely...glad to see this finally get in the product!
One more thing RobertMesropyan . Any idea how I can filter the view to show only vms created last 24 hours? The filter options seem to be limited to epoch time?
albogadocmeg Unfortunately, filtering by different transformations is not supported yet. Existing filtering based on raw last values.
Does anyone know if you can create a super metric or something and convert the creation date value into number of days etc?
Once you have a metric of its age you can make reports and or filter views etc...
Thanks Robert,
Yes i have been able to do that but i dont see a way to filter those results for example all VM's that were created in the last week etc given the view filters dont seem recognise the transformed value..?
Yes this has been my experience with the view filtering also.
Do you know of a way to use a super metric to do the same transformation on the creation date value to a running count of number of days old or something?
I have been able to transform the creation date in a relative date format and get days old but to filter the results to just show the last week it i needs to use an absolute number and while this works for the day i run the report i think it will be wrong when i run it the week after...?
I don't see easy workaround with super metrics since time functions are not supported by super metrics.
Yes, you are correct - week after results will changed.
So, probably the best solution is enable sorting for Creation Date column and then manupulate with resulting CSV data.
RobertMesropyan Yes this was my conclusion too. What a shame such a simple filter is not possible in custom reports, hopefully this is available in 8.2 but i wont hold my breath.
Thanks for the metric, but i am not getting the output, vmconfiguration|creation date showing blank(-). is there any possibility yo get the correct date.
OMG not possible, why? I just looking last 7 days created VMs, It's not rocket science.
Current unix time - (60*60*24*7) 7 days = foo(7 days ago time)
filter : VM create time > foo