Difference between revisions of "Virtual Infrastructure DB Project"

Jump to navigation Jump to search
→‎Change Log: Added up to "Version 2.4"
(→‎Version 2.0: Presentation side updated)
(→‎Change Log: Added up to "Version 2.4")
Line 70: Line 70:
** Added ESX extended data (inc IP - needs further work), ntp, hba and nic info
** Added ESX extended data (inc IP - needs further work), ntp, hba and nic info
** Consolidated SQL query strings
** Consolidated SQL query strings
* '''Data Collection (db-base-data)''' - v1.2.1 intra-release bugfix
** 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)
* '''Presentation (index)'''
* '''Presentation (index)'''
** Bugfix: VM's exist and On options ignored in non-fuzzy hostname searches
** Bugfix: VM's exist and On options ignored in non-fuzzy hostname searches
Line 97: Line 94:
* '''Data Collection (db-base-data)'''
* '''Data Collection (db-base-data)'''
** Changed to Async/PS Jobs in order to run against multiple vCentre's simultaneously
** Changed to Async/PS Jobs in order to run against multiple vCentre's simultaneously
*** vCentre data mining moved to sub-script
*** vCentre data mining moved to sub-script (db-base-data-sub)
*** Moved MySQL functions out to library file (shared between main and 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)
*** Enforce run in 32 bit environment (PowerCLI bug workaround, vSphere scripts crash Powershell when launched as background jobs in 64bit)
Line 116: Line 113:
* '''Presentation (snaps)'''
* '''Presentation (snaps)'''
** Added basic sorting
** Added basic sorting
==== Version 2.1 ====
* '''Data Collection (db-base-data-sub)'''
** Performance improvements (reduce's runtime by about 60%)
*** Improved VM Cluster get to use lookup table
*** Changed VM Guest OS get to use existing VM object
** Bugfix: Lab Manager VM's not being removed after deletion (include checking of Persistent ID)
==== Version 2.2 ====
* '''Data Collection (db-base-data-sub)'''
** Minor improvements to error messages
** Performance improvements
*** Caching of Get-VMHostNetworkAdapter during ESX info gather
** Added VMTools state and VM version
==== Version 2.3 ====
* '''Data Collection (db-base-data-sub)'''
** Added ESX NIC firmware version
* '''Presentation (esxs)'''
** Initial
==== Version 2.4 ====
* '''Data Collection (db-base-data-sub)'''
** Bugfix: VM's not in cluster don't get added to db (introduced in v2.1)
** Bugfix: "Couldn't find ESX ID for VM" error catch not working
** Added VM custom attributes
** Added vApps
* '''Presentation (index)'''
** Added link to vApps


[[Category:VMware]]
[[Category:VMware]]

Navigation menu