ESX server by region on VMware publisher tab is not showing any data

[shivani42]

Hi All,

I am reviewing the data for VMware publisher on publisher overview portal. The ESX Servers by Region section is giving nothing, it has indicator but the there is no data showing. Even the data is available in esx server table. I was playing around with the same and found there is 

Pivot elements filter which has the following filters applied. 

My confusion is if it is on the basis of region then why we are using the location sys id. I go to the breakdown source as well to see whether we can use the region filed for the same. But no luck, region field was not available on the list. Can anyone help with the same.

Breakdown Source- 

Pivot elements filter

 Publisher overview view -

Thanks in Advance,

Shivani

[danmjunqueira]

you will have a couple of ideas and solutions to fix it, my suggestions on this is:

Adjust the Breakdown Source
If your ESX Server records contain a field like location.region or another derived region logic:

Create a new breakdown source with:

Table: cmn_location

Filter: Only include records that match the location values used by ESX servers

Or create a custom field like "Region" on cmn_location and populate it accordingly

Update your indicator or pivot to use this revised breakdown source instead of the current top-level location list.

or you can Use a Scripted Breakdown
If the Region concept is not stored directly in the ESX server but derived (e.g., inferred by location or site naming), consider a scripted breakdown:

Create a Scripted Breakdown Source that derives the Region from a logic like:

var region = '';
if (server.location && server.location.name.startsWith('NA')) {
region = 'North America';
}

To test which Locations are linked to your ESX Servers:

Go to the ESX Server table (fact table)

Run a query: locationISNOTEMPTY

Check which location.sys_id values are being referenced

Cross-check if these exist in your current breakdown

If they don’t, that’s exactly why the pivot shows no data.

Let me know if this solutions works or if I can help you with anything.

Best Regards,

[shivani42]

Hi Dan,

Thanks for your response. I have modified the breakdown and now it is getting the correct data basis on region. I have one more doubt. I notice, the list contains the retired servers as well on the Wiget. Is oob, these retire servers should include or only the servers are installing state should be present on list.

Regards,

Shivani