VMware vSphere deployments details

[RavikumarBagale]

Hi Team,

Currently I am working on VMware Effective licensing position but I am unable to get vmware vSphere deployments details in the report.

Could you please confirm which table I need to select to get the the vmware vSphere deployments details.

Currently I am exploring "cmdb_ci_esx_server" table but not able to find any particular column which can help me to get which vSphere license is assigned to esx server.

Thank you in advance 🙂

[Engelica Adalia · Accepted solution]

Hi @RavikumarBagale, cmdb_ci_esx_server table will provide you the list of ESX servers existing in your cmdb (as pulled by discovery or can be created manually). I suggest looking at the cmdb_sam_sw_install table and filter it to show just the "VMware vSphere". This will give you a list of VMware vSphere installations (with specific version/edition) and where it was installed (note that it will match the OS version of the server CI from the cmdb_ci_esx_server table).

[RavikumarBagale]

Thank you Engelica Adalia for the help. I really appreciate your response.

we are still in implementing phase of ServiceNow.

Could you please confirm Can Servicenow detect vSphere and vCenter license keys in discovery?

[Engelica Adalia]

Hi @RavikumarBagale Specific license key is not displayed in the software installation table (cmdb_sam_sw_install). Typically, you create the software model and entitlements (with license key detail) first and track the devices/servers assigned to it (you can get this detail when you login to the VMware portal). Once it is completely setup and you run reconciliation within ServiceNow, it reconciles it against the installation table which will show you if you are compliant or not (comparing what you own vs what was deployed/installed).