Difference between revisions of "Virtual Infrastructure DB Project"

Jump to navigation Jump to search

Virtual Infrastructure DB Project (view source)

Revision as of 10:37, 19 December 2011

7,334 bytes added ,  10:37, 19 December 2011
m
→‎Matrix: Minor correction
m (→‎Version 1.2: Minor format update)
m (→‎Matrix: Minor correction)
 
(12 intermediate revisions by the same user not shown)
Line 13: Line 13:
! Release   
! Release   
! Database
! Database
!colspan="2"| Data Collection
!colspan="3"| Data Collection
!colspan="3"| Presentation (Main)
!colspan="3"| Presentation (Main)
! Presentation (Other)
! Presentation (Other)
|-
|-
! 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="3"| [[VI-DB_db-esx-check-v4.ps1|db-esx-check-v4.ps1]]
|rowspan="4"| [[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="3"| [[VI-DB_status.php_v1|status.php v1]]
|rowspan="15"| [[VI-DB_status.php_v1|status.php v1]]
|rowspan="3"| [[VI-DB_alpha.css_v1|alpha.css v1]]
|rowspan="9"| [[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]]
| [[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]]
| [[VI-DB_vi-db-update-v1.2|update-v1.2]]
|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]]
| [[VI-DB_index.php_v1.2|index.php v1.2]]
|rowspan="3"| [[VI-DB_index.php_v1.1|index.php v1.1]]
| [[VI-DB_snaps.php_v1|snaps.php v1.2]]
|rowspan="3"| [[VI-DB_snaps.php_v1|snaps.php v1]]
|-
! [[#Version 1.2.1|Version 1.2.1]]
|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]]
|rowspan="6"| [[VI-DB_db-esx-check-v5.ps1|db-esx-check-v5.ps1]]
|-
! [[#Version 2.0|Version 2.0]]
|rowspan="2"| [[VI-DB_vi-db-update-v2.0|update v2.0]]
|rowspan="5"| [[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]]
|rowspan="2"| [[VI-DB_index.php_v2.0|index.php v2.0]]
|rowspan="2"| [[VI-DB_run-errors.php_v2|run-errors.php v2]], [[VI-DB_vm-detail.php_v2|vm-detail.php v2]], [[VI-DB_snaps.php_v2|snaps.php v2]]
|-
! [[#Version 2.1|Version 2.1]]
| [[VI-DB_db-base-data-sub-v2.1.ps1|db-base-data-sub-v2.1.ps1]]
|-
! [[#Version 2.2|Version 2.2]]
|rowspan="2"| [[VI-DB_vi-db-update-v2.2|update v2.2]]
| [[VI-DB_db-base-data-sub-v2.2.ps1|db-base-data-sub-v2.2.ps1]]
| [[VI-DB_index.php_v2.2|index.php v2.2]]
| [[VI-DB_vmtools.php_v2|vmtools.php v2]], [[VI-DB_vnics.php_v2|vnics.php v2]]
|-
! [[#Version 2.3|Version 2.3]]
| [[VI-DB_db-base-data-sub-v2.3.ps1|db-base-data-sub-v2.3.ps1]]
| [[VI-DB_index.php_v2.3|index.php v2.3]]
| [[VI-DB_esxs.php_v2|esxs.php v2]]
|-
! [[#Version 2.4|Version 2.4]]
|rowspan="3"| [[VI-DB_vi-db-update-v2.4|update v2.4]]
| [[VI-DB_db-base-data-sub-v2.4.ps1|db-base-data-sub-v2.4.ps1]]
|rowspan="6"| [[VI-DB_index.php_v2.4|index.php v2.4]]
|rowspan="5"| [[VI-DB_alpha.css_v2|alpha.css v2]]
| [[VI-DB_vapps.php_v2|vapps.php v2]]
|-
! [[#Version 2.5|Version 2.5]]
|rowspan="3"| [[VI-DB_db-base-data-v2.1.ps1|db-base-data-v2.1.ps1]]
| [[VI-DB_db-base-data-sub-v2.5.ps1|db-base-data-sub-v2.5.ps1]]
|rowspan="5"| [[VI-DB_db-esx-check-v6.ps1|db-esx-check-v6.ps1]]
| [[VI-DB_run-errors.php_v2.1|run-errors.php v2.1]], [[VI-DB_vm-detail.php_v2.2|vm-detail.php v2.2]], [[VI-DB_vmtools.php_v2.1|vmtools.php v2.1]]
|-
! [[#Version 2.6|Version 2.6]]
| [[VI-DB_db-base-data-sub-v2.6.ps1|db-base-data-sub-v2.6.ps1]]
| [[VI-DB_capman.php_v2.0|capman.php v2.0]]
|-
! [[#Version 2.7|Version 2.7]]
| [[VI-DB_vi-db-update-v2.7|update v2.7]]
| [[VI-DB_db-base-data-sub-v2.7.ps1|db-base-data-sub-v2.7.ps1]]
| [[VI-DB_capman.php_v2.1|capman.php v2.1]]
|-
! [[#Version 2.8|Version 2.8]]
| [[VI-DB_vi-db-update-v2.8|update v2.8]]
| [[VI-DB_db-base-data-v2.2.ps1|db-base-data-v2.2.ps1]]
| [[VI-DB_db-base-data-sub-v2.8.ps1|db-base-data-sub-v2.8.ps1]]
| [[VI-DB_vc-detail.php_v2.2|vc-detail.php v2.2]], [[VI-DB_run-errors.php_v2.2|run-errors.php v2.2]]
|-
! [[#Version 2.9|Version 2.9]]
| [[VI-DB_vi-db-update-v2.9|update v2.9]]
| [[VI-DB_db-base-data-v2.3.ps1|db-base-data-v2.3.ps1]]
| [[VI-DB_db-base-data-sub-v2.9.ps1|db-base-data-sub-v2.9.ps1]]
| [[VI-DB_alpha.css_v3|alpha.css v3]]
| [[VI-DB_vm-detail.php_v2.3|vm-detail.php v2.3]], [[VI-DB_ds-info.php_v2.1|ds-info.php v2.1]]
|}
|}


Line 53: Line 116:


==== Version 1.2 ====
==== Version 1.2 ====
* Data Collection (db-base-data)
* '''Data Collection (db-base-data)'''
** Bugfix: Snapshot sizes not right (known PowerCLI bug in Get-Snapshot that I'd wrongly assumed to be fixed)
** Bugfix: Snapshot sizes not right (known PowerCLI bug in Get-Snapshot that I'd wrongly assumed to be fixed)
** Added population of snap.vrange (is snapshot a vRanger snapshot)
** Added population of snap.vrange (is snapshot a vRanger snapshot)
** 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
* '''Presentation (index)'''
** Bugfix: VM's exist and On options ignored in non-fuzzy hostname searches
** Added "VMs On" to vCentre summary
* '''Presentation (status''')
** Bugfix: Expired clusters showing (cluster.exist being ignored)
** Bugfix: Standalone ESX's ignored, now shown as member of sudo-cluster "Standalone"
** Improved footer links
* '''Presentation (snaps)'''
** Initial - list of VM snapshots
* '''Presentation (vm-detail)'''
** Added datastore usage summary
==== Version 1.2.1 ====
* '''Data Collection (db-base-data)'''
** 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)
==== 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 (db-base-data-sub)
*** 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)
** Improved deleted VM handling
** 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 ****
* '''Presentation (index)'''
** Added links to run-errors and ds-waste
* '''Presentation (run-errors)'''
** Initial creation
* '''Presentation (vm-detail)'''
** Added vApp and UUID
** Added datastore usage summary
* '''Presentation (snaps)'''
** 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
* '''Presentation (index)'''
** Added links
* '''Presentation (vm-detail)'''
** Added VMTools state
* '''Presentation (vmtools)'''
** Initial
* '''Presentation (vnics)'''
** Initial
==== Version 2.3 ====
* '''Data Collection (db-base-data-sub)'''
** Added ESX NIC firmware version
* '''Presentation (index)'''
** Added links
* '''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
* '''Presentation (vapps)'''
** Initial
* '''Presentation (css)'''
** Added additional table cell formats
==== Version 2.5 ====
* '''Data Collection (db-base-data)'''
** Added check for sub-script fail
* '''Data Collection (db-base-data-sub)'''
** Bugfix: Remove old VMDK's for VMs didn't work (SQL query incorrect)
** Bugfix: VM NICs with multiple IPs not handled correctly
** Improved error logging (DS inaccessible, VMs not in cluster)
** Added sev0 error log at completion to signal parent script that script exited cleanly
* '''Data Collection (db-esx-check)'''
** Bugfix: Log rollover didn't work
** Performance optimisation - changed data gather to use single Get-View
* '''Presentation (vm-detail)'''
** Added conditional formatting to Powered, VM Tools, vmnic version
** Added link to vApp
** Added VM Attributes
* '''Presentation (run-errors)'''
** Updated for 'note' severity category
* '''Presentation (vmtools)'''
** Updated Tools Status handling


[[Category:VMware]]
[[Category:VMware]]
Retrieved from ‘https://vwiki.co.uk/index.php?title=Special:MobileDiff/1253...1591’

Navigation menu