Single Business View Report (Possible feature request)

[grayknighty]

Hi all,

I wondered if the following is possible—and if not, whether it could be raised as a feature request.
We have a Business View group (a custom attribute from VMware) that represents the Service of each VM. I would like a report that shows Service X and all the VMs included in that service, then Service Y, and so on, all within the same report.

The report technically exists, but currently you must:
1. Run the Infrastructure Overview report.
2. Choose Service as the Business View category.
3. Run the report and go to the Virtual Machines page.
4. Use the pie chart grouped by Service and click the details hyperlink to reach the view I actually need.

Is there any way to have that specific report at the top level, without needing to go through the Infrastructure Overview Report?

Another question: is it possible to have that same pie chart on an interactive dashboard, showing top-level services and their VMs?

Context, Our senior leaders would like a simple report that shows all the services hosted in our VMware instance. They are not interested in low-level details within VeeamOne or our infrastructure, just a clear, service-level summary.

If this was possible in VeeamOne it would certainly make our renewal order easy as they would have value from the product too.

Many thanks in advance.

[jorgedlcruz]

Hello Gray,
So in Veeam ONE v13, we have made a great leap forward in terms of Veeam reports, but this particular one for VMware is still on Microsoft SSRS and the flexibility is close to zero.

If you can share here the exact columns you are looking for, even in CSV format, we can perhaps craft some unsupported script that produces and HTML out of our API or DB, and you can automate that and send it, meanwhile something better comes.

As for your question, with Report Builder you should be able to take some parts of the report, but again, perhaps with some scripting we can do this.

Thank you, keep us posted.

[grayknighty]

Hi Jorgedlcruz, many thanks for your response.

https://bham-my.sharepoint.com/personal ... w&e=Zl97cy

Hopefully that link works and contains a zip file with the 4 screenshots in order of how I get to the report I require. Screenshot 4 is the report I required without having to go through Steps 1-3 if possible.

Thanks for your help.
Graham

[jorgedlcruz]

Hello Graham,
I have checked and without additional development, this could not be implemented. There are two options:

• Using Microsoft SSRS, in theory you could create a new report using the right SQL queries that those reports are based on
• I can craft a quick PowerShell that you run at any given time and will product an HTML output with what you are looking for (Unsupported), that of course uses Veeam ONE Database

Please let me know

[grayknighty]

Hi,

Either is fine, if the SSRS route, I've had a look at the table structure and I'm struggling to see what tables I should be querying against. busienssview.partition looked close but its got some custom attributes in there and not any new one's we've recently created..

If HTML is easier than I'm happy for you to create a quick PS that creates us a HTML. That works and would be greatly appreciated.

Thanks
Graham

[jorgedlcruz]

Hello Graham,
I managed to put some time together during this evening (not supported, etc)

• https://github.com/jorgedlcruz/veeam-ht ... sinessView

The ps1 is expecting from you to run it from a server where you are logged in that has privileges to the SQL, uses Windows Auth. Also is expecting your Business View VM category, and of course a valid Microsoft Application that can SEND email, some information about how to create that here.

The report looks solid, with lots of useful data, it gets send inline, with the CSV attached; you can also check the HTML on the output folder (it has more JS there so you can collapse/expand tables, etc.)


As it is not supported, be mindful and for questions or errors, please create some bugs in GitHub directly. As you will own the code, feel free to add your logo, remove some tables, etc.

I truly hope it helps to convince your team to keep VONE.