2,187
edits
Difference between revisions of "Virtual Infrastructure DB Project"
Jump to navigation
Jump to search
Virtual Infrastructure DB Project (view source)
Revision as of 10:22, 21 June 2011
, 10:22, 21 June 2011→Releases: Added initial v2.0 updates (mostly data collection)
(→Change Log: Added "Version 1.2.1") |
(→Releases: Added initial v2.0 updates (mostly data collection)) |
||
| Line 13: | Line 13: | ||
! Release | ! Release | ||
! Database | ! Database | ||
!colspan=" | !colspan="3"| Data Collection | ||
!colspan="3"| Presentation (Main) | !colspan="3"| Presentation (Main) | ||
! Presentation (Other) | ! Presentation (Other) | ||
| Line 19: | Line 19: | ||
! [[#Version 1|Version 1]] | ! [[#Version 1|Version 1]] | ||
|rowspan="2"| [[VI-DB_vi-db-initial|initial]] | |rowspan="2"| [[VI-DB_vi-db-initial|initial]] | ||
| [[VI-DB_db-base-data-v1.0.ps1|db-base-data-v1.0.ps1]] | |colspan="2"| [[VI-DB_db-base-data-v1.0.ps1|db-base-data-v1.0.ps1]] | ||
|rowspan=" | |rowspan="6"| [[VI-DB_db-esx-check-v4.ps1|db-esx-check-v4.ps1]] | ||
|rowspan="2"| [[VI-DB_index.php_v1|index.php v1]] | |rowspan="2"| [[VI-DB_index.php_v1|index.php v1]] | ||
|rowspan=" | |rowspan="6"| [[VI-DB_status.php_v1|status.php v1]] | ||
|rowspan=" | |rowspan="6"| [[VI-DB_alpha.css_v1|alpha.css v1]] | ||
|rowspan="2"| [[VI-DB_vc-detail.php_v1|vc-detail.php v1]], [[VI-DB_cluster-detail.php_v1|cluster-detail.php v1]], [[VI-DB_vm-detail.php_v1|vm-detail.php v1]] | |rowspan="2"| [[VI-DB_vc-detail.php_v1|vc-detail.php v1]], [[VI-DB_cluster-detail.php_v1|cluster-detail.php v1]], [[VI-DB_vm-detail.php_v1|vm-detail.php v1]] | ||
|- | |- | ||
! [[#Version 1.1|Version 1.1]] | ! [[#Version 1.1|Version 1.1]] | ||
| [[VI-DB_db-base-data-v1.1.ps1|db-base-data-v1.1.ps1]] | |colspan="2"| [[VI-DB_db-base-data-v1.1.ps1|db-base-data-v1.1.ps1]] | ||
|- | |- | ||
! [[#Version 1.2|Version 1.2]] | ! [[#Version 1.2|Version 1.2]] | ||
|rowspan=" | |rowspan="3"| [[VI-DB_vi-db-update-v1.2|update-v1.2]] | ||
| [[VI-DB_db-base-data-v1.2.ps1|db-base-data-v1.2.ps1]] | |colspan="2"| [[VI-DB_db-base-data-v1.2.ps1|db-base-data-v1.2.ps1]] | ||
|rowspan=" | |rowspan="3"| [[VI-DB_index.php_v1.1|index.php v1.1]] | ||
|rowspan="2"| [[VI-DB_snaps.php_v1|snaps.php v1]] | |rowspan="2"| [[VI-DB_snaps.php_v1|snaps.php v1]] | ||
|- | |- | ||
! [[#Version 1.2.1|Version 1.2.1]] | ! [[#Version 1.2.1|Version 1.2.1]] | ||
| [[VI-DB_db-base-data-v1.2.1.ps1|db-base-data-v1.2.1.ps1]] | |colspan="2"| [[VI-DB_db-base-data-v1.2.1.ps1|db-base-data-v1.2.1.ps1]] | ||
|- | |||
! [[#Version 1.2.2|Version 1.2.2]] | |||
|colspan="2"| [[VI-DB_db-base-data-v1.2.2.ps1|db-base-data-v1.2.2.ps1]] | |||
|- | |||
! [[#Version 2.0|Version 2.0]] | |||
| [[VI-DB_vi-db-update-v2.0|update-v2.0]] | |||
| [[VI-DB_db-base-data-v2.0.ps1|db-base-data-v2.0.ps1]] | |||
| [[VI-DB_db-base-data-sub-v2.0.ps1|db-base-data-sub-v2.0.ps1]] | |||
| [[VI-DB_index.php_v2.0|index.php v2.0]] | |||
|} | |} | ||
| Line 80: | Line 89: | ||
** Bugfix: Standalone ESX's cause SQL INSERT error (as clid isn't defined) | ** Bugfix: Standalone ESX's cause SQL INSERT error (as clid isn't defined) | ||
** Bugfix: Script crash when unable to get ESX NIC/HBA info (happens when ESX not connected) | ** Bugfix: Script crash when unable to get ESX NIC/HBA info (happens when ESX not connected) | ||
==== Version 1.2.2 ==== | |||
* '''Data Collection (db-base-data)''' | |||
** Workaround: DV switch doesn't have VLAN ID in same place as Port Group causing SQL INSERT fail, caught and set to NULL | |||
==== Version 2.0 ==== | |||
* '''Data Collection (db-base-data)''' | |||
** Changed to Async/PS Jobs in order to run against multiple vCentre's simultaneously | |||
*** vCentre data mining moved to sub-script | |||
*** Moved MySQL functions out to library file (shared between main and sub-script) | |||
*** Enforce run in 32 bit environment (PowerCLI bug workaround, vSphere scripts crash Powershell when launched as background jobs in 64bit) | |||
** Added basic support for vApp VM's (name add to vm_ext, vm folder now supported) | |||
** Added logging of errors to database | |||
** Added sanity checks (make sure total no of clusters, ESXs, VMs in db matches VC) | |||
** Added basic support for distributed switches, and added special network types (mgmt, vmk, ft) | |||
** Change logging timestamp from xxx secs to hh:mm:ss.msec | |||
** Bugfix: Old VMDK's / vNIC's don't get removed from VM's - additional now deleted NOT WORKING YET, NIC's get added and deleted on some VM's **** TO FIX **** | |||
[[Category:VMware]] | [[Category:VMware]] | ||