I created a service under Service builder dashboard, but when a VM report ( VM logical disks with X% or Less Free Storage) is generated with the built service, it's just empty/not a meaningful report with just 0 values.
The report is a VM report so it's searching for VM's in the cluster for which the service was created for, but since it couldn't find the VM's in the built service, it returns just an empty report.
1) Go to the Service Builder dashboard and expand the services.
2) Click the 'Edit' icon for: apps_sql_clusters (FSMDynamicManagedComponent).
3) When the dialog appears make sure the VMware tree of objects is expanded.
4) Select the radio button for Virtual Machines.
5) Change the query so that it looks for ESX Hosts in the desired clusters. Using the example the query would look like this:
esxServer.parent.name = 'apps' OR esxServer.parent.name = 'sql'
6) When the query is tested it should include the Virtual Machines that are found in the specified clusters.
If that is successful then the service would be suitable for using with the "VM logical disks with X% or Less Free Storage" report.
Replacing 'apps' & 'sql' with the clusters of their choosing in the query in step 5. The cluster names should be enclosed in single-quotes.
Is it possible for the report to display the Logical Disks with X% Or Less Free Storage table entries for 'apps' cluster first and then 'sql' cluster under single report while generating report under reports dashboard.