elwood wrote:There's also something odd, I'm getting a lot of duplication - VMs listed two three or four times. I added the UUID to see if they're ghost records, but every field appears identical - so I can't see where those duplications are coming from.
I don't suppose there are any sample Customer Infrastructure reports anywhere to help me?
elwood wrote:I've tried variations of filtering by business group/category, sorting by, grouping by. I can get it to list "customers", but when expanded it just shows every VM in the caegory, I can't work out how to kill all of the unwanted categories such as Sample Business View and VMs without backups. I thought that filtering it with a filter like 'where business view group = customers' would help but then I get an empty report with no data available.
elwood wrote:You're right about the disk data. I removed everything disk related and the duplicates disappeared. I havn't tracked down exactly which field it was as i found slightly more appropriate fields to use which arn't causing the problem now.
elwood wrote: I'm sure I can export to Excel and sort some auto-calculation out in Excel but before I do that is there not just a simple way of auto-totalling the figures on a per customer basis? How do I get total number of VMs owned by one customer for example?
Users browsing this forum: No registered users and 2 guests