VMware Inventory
Description
The script retrieves VMware inventory by querying vCenter servers and updates the SQL databases. It connects to vCenter servers, fetches VM and ESX host information, and enriches data with SQL queries.
Credentials
- sys_ansible_vmware
- DG_ServersUser1 (SQL account)
- sys_srvaapwin_batch (script user on srvaapwin)
- sys_ansible_windows
Input
| Variable | Description |
|---|---|
ServerInstance |
Hostname for the database |
Database |
SQL server database name |
VcServers |
Name of the Vsphere servers |
Output
updates database "Sql_db_dg_servers"