Virtual Infrastructure DB Project - Revision history

Sstrutt: /* Matrix */ Minor correction

2011-12-19T10:37:10Z

Matrix: Minor correction

← Older revision		Revision as of 10:37, 19 December 2011
Line 89:		Line 89:
	\| [[VI-DB_db-base-data-v2.2.ps1\|db-base-data-v2.2.ps1]]		\| [[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_db-base-data-sub-v2.8.ps1\|db-base-data-sub-v2.8.ps1]]
	\| [[VI-DB_vc-detail.php_v2.1\|vc-detail.php v2.1]], [[VI-DB_run-errors.php_v2.2\|run-errors.php v2.2]]		\| [[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]]		! [[#Version 2.9\|Version 2.9]]

Sstrutt: /* Matrix */ Updated to v2.9

2011-12-19T08:40:59Z

Matrix: Updated to v2.9

← Older revision		Revision as of 08:40, 19 December 2011
Line 22:		Line 22:
	\|rowspan="4"\| [[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="11"\| [[VI-DB_status.php_v1\|status.php v1]]		\|rowspan="15"\| [[VI-DB_status.php_v1\|status.php v1]]
	\|rowspan="9"\| [[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]]
Line 64:		Line 64:
	\|-		\|-
	! [[#Version 2.4\|Version 2.4]]		! [[#Version 2.4\|Version 2.4]]
	\|rowspan="2"\| [[VI-DB_vi-db-update-v2.4\|update v2.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]]		\| [[VI-DB_db-base-data-sub-v2.4.ps1\|db-base-data-sub-v2.4.ps1]]
	\|rowspan="2"\| [[VI-DB_index.php_v2.4\|index.php v2.4]]		\|rowspan="6"\| [[VI-DB_index.php_v2.4\|index.php v2.4]]
	\|rowspan="2"\| [[VI-DB_alpha.css_v2\|alpha.css v2]]		\|rowspan="5"\| [[VI-DB_alpha.css_v2\|alpha.css v2]]
	\| [[VI-DB_vapps.php_v2\|vapps.php v2]]		\| [[VI-DB_vapps.php_v2\|vapps.php v2]]
	\|-		\|-
	! [[#Version 2.5\|Version 2.5]]		! [[#Version 2.5\|Version 2.5]]
	\| [[VI-DB_db-base-data-v2.1.ps1\|db-base-data-v2.1.ps1]]		\|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]]		\| [[VI-DB_db-base-data-sub-v2.5.ps1\|db-base-data-sub-v2.5.ps1]]
	\| [[VI-DB_db-esx-check-v6.ps1\|db-esx-check-v6.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]]		\| [[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.1\|vc-detail.php v2.1]], [[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]]
	\|}		\|}

Sstrutt: /* Version 2.5 */ Correction

2011-10-13T06:55:17Z

Version 2.5: Correction

← Older revision		Revision as of 06:55, 13 October 2011
Line 200:		Line 200:
	** Added conditional formatting to Powered, VM Tools, vmnic version		** Added conditional formatting to Powered, VM Tools, vmnic version
	** Added link to vApp		** Added link to vApp
			** Added VM Attributes
	* '''Presentation (run-errors)'''		* '''Presentation (run-errors)'''
	** Updated for 'note' severity category		** Updated for 'note' severity category

Sstrutt: /* Change Log */ Added up to "Version 2.5"

2011-10-12T08:22:15Z

Change Log: Added up to "Version 2.5"

@@ Line 185: / Line 185: @@
 * '''Presentation (css)'''
 ** Added additional table cell formats
 [[Category:VMware]]

Sstrutt: /* Matrix */ Updated to v2.5

2011-10-12T08:20:08Z

Matrix: Updated to v2.5

Sstrutt: /* Change Log */ Revised last edit

2011-08-25T10:04:23Z

Change Log: Revised last edit

← Older revision		Revision as of 10:04, 25 August 2011
Line 149:		Line 149:
	*** Caching of Get-VMHostNetworkAdapter during ESX info gather		*** Caching of Get-VMHostNetworkAdapter during ESX info gather
	** Added VMTools state and VM version		** 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 ====		==== Version 2.3 ====
	* '''Data Collection (db-base-data-sub)'''		* '''Data Collection (db-base-data-sub)'''
	** Added ESX NIC firmware version		** Added ESX NIC firmware version
			* '''Presentation (index)'''
			** Added links
	* '''Presentation (esxs)'''		* '''Presentation (esxs)'''
	** Initial		** Initial
Line 164:		Line 174:
	* '''Presentation (index)'''		* '''Presentation (index)'''
	** Added link to vApps		** Added link to vApps
			* '''Presentation (vapps)'''
			** Initial
			* '''Presentation (css)'''
			** Added additional table cell formats

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

Sstrutt: /* Matrix */ Updated to v2.4

2011-08-25T09:34:09Z

Matrix: Updated to v2.4

← Older revision		Revision as of 09:34, 25 August 2011
Line 20:		Line 20:
	\|rowspan="2"\| [[VI-DB_vi-db-initial\|initial]]		\|rowspan="2"\| [[VI-DB_vi-db-initial\|initial]]
	\|colspan="2"\| [[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="6"\| [[VI-DB_db-esx-check-v4.ps1\|db-esx-check-v4.ps1]]		\|rowspan="10"\| [[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="6"\| [[VI-DB_status.php_v1\|status.php v1]]		\|rowspan="10"\| [[VI-DB_status.php_v1\|status.php v1]]
	\|rowspan="6"\| [[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]]
	\|-		\|-
Line 30:		Line 30:
	\|-		\|-
	! [[#Version 1.2\|Version 1.2]]		! [[#Version 1.2\|Version 1.2]]
	\|rowspan="3"\| [[VI-DB_vi-db-update-v1.2\|update-v1.2]]		\|rowspan="3"\| [[VI-DB_vi-db-update-v1.2\|update v1.2]]
	\|colspan="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="3"\| [[VI-DB_index.php_v1.1\|index.php v1.1]]		\|rowspan="3"\| [[VI-DB_index.php_v1.1\|index.php v1.1]]
	\|rowspan="2"\| [[VI-DB_snaps.php_v1\|snaps.php v1]]		\|rowspan="3"\| [[VI-DB_snaps.php_v1\|snaps.php v1]]
	\|-		\|-
	! [[#Version 1.2.1\|Version 1.2.1]]		! [[#Version 1.2.1\|Version 1.2.1]]
Line 42:		Line 42:
	\|-		\|-
	! [[#Version 2.0\|Version 2.0]]		! [[#Version 2.0\|Version 2.0]]
	\| [[VI-DB_vi-db-update-v2.0\|update-v2.0]]		\|rowspan="2"\| [[VI-DB_vi-db-update-v2.0\|update v2.0]]
	\| [[VI-DB_db-base-data-v2.0.ps1\|db-base-data-v2.0.ps1]]		\|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]]		\| [[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]]		\|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]]
			\| [[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]]
			\| [[VI-DB_index.php_v2.4\|index.php v2.4]]
			\| [[VI-DB_alpha.css_v2\|alpha.css v2]]
			\| [[VI-DB_vapps.php_v2\|vapps.php v2]]
	\|}		\|}

Sstrutt: /* Change Log */ Added up to "Version 2.4"

2011-08-25T09:05:14Z

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
 ** Consolidated SQL query strings
 * '''Presentation (index)'''
 ** Bugfix: VM's exist and On options ignored in non-fuzzy hostname searches
@@ Line 97: / Line 94: @@
 * '''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
+*** 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)
@@ Line 116: / Line 113: @@
 * '''Presentation (snaps)'''
 ** Added basic sorting
 [[Category:VMware]]

Sstrutt: /* Version 2.0 */ Presentation side updated

2011-06-23T14:51:11Z

Version 2.0: Presentation side updated

← Older revision		Revision as of 14:51, 23 June 2011
Line 104:		Line 104:
	** Added sanity checks (make sure total no of clusters, ESXs, VMs in db matches VC)		** 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)		** 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		** 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 **		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

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

Sstrutt: /* Releases */ Added initial v2.0 updates (mostly data collection)

2011-06-21T10:22:48Z

Releases: Added initial v2.0 updates (mostly data collection)

← Older revision		Revision as of 10:22, 21 June 2011
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)
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="4"\| [[VI-DB_db-esx-check-v4.ps1\|db-esx-check-v4.ps1]]		\|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="4"\| [[VI-DB_status.php_v1\|status.php v1]]		\|rowspan="6"\| [[VI-DB_status.php_v1\|status.php v1]]
	\|rowspan="4"\| [[VI-DB_alpha.css_v1\|alpha.css v1]]		\|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="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]]
	\|rowspan="2"\| [[VI-DB_index.php_v1.1\|index.php v1.1]]		\|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]]

← Older revision		Revision as of 10:37, 19 December 2011
Line 89:		Line 89:
	\| [[VI-DB_db-base-data-v2.2.ps1\|db-base-data-v2.2.ps1]]		\| [[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_db-base-data-sub-v2.8.ps1\|db-base-data-sub-v2.8.ps1]]
	\| [[VI-DB_vc-detail.php_v2.1\|vc-detail.php v2.1]], [[VI-DB_run-errors.php_v2.2\|run-errors.php v2.2]]		\| [[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]]		! [[#Version 2.9\|Version 2.9]]

← Older revision		Revision as of 08:40, 19 December 2011
Line 22:		Line 22:
	\|rowspan="4"\| [[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="11"\| [[VI-DB_status.php_v1\|status.php v1]]		\|rowspan="15"\| [[VI-DB_status.php_v1\|status.php v1]]
	\|rowspan="9"\| [[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]]
Line 64:		Line 64:
	\|-		\|-
	! [[#Version 2.4\|Version 2.4]]		! [[#Version 2.4\|Version 2.4]]
	\|rowspan="2"\| [[VI-DB_vi-db-update-v2.4\|update v2.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]]		\| [[VI-DB_db-base-data-sub-v2.4.ps1\|db-base-data-sub-v2.4.ps1]]
	\|rowspan="2"\| [[VI-DB_index.php_v2.4\|index.php v2.4]]		\|rowspan="6"\| [[VI-DB_index.php_v2.4\|index.php v2.4]]
	\|rowspan="2"\| [[VI-DB_alpha.css_v2\|alpha.css v2]]		\|rowspan="5"\| [[VI-DB_alpha.css_v2\|alpha.css v2]]
	\| [[VI-DB_vapps.php_v2\|vapps.php v2]]		\| [[VI-DB_vapps.php_v2\|vapps.php v2]]
	\|-		\|-
	! [[#Version 2.5\|Version 2.5]]		! [[#Version 2.5\|Version 2.5]]
	\| [[VI-DB_db-base-data-v2.1.ps1\|db-base-data-v2.1.ps1]]		\|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]]		\| [[VI-DB_db-base-data-sub-v2.5.ps1\|db-base-data-sub-v2.5.ps1]]
	\| [[VI-DB_db-esx-check-v6.ps1\|db-esx-check-v6.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]]		\| [[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.1\|vc-detail.php v2.1]], [[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]]
	\|}		\|}

← Older revision		Revision as of 09:34, 25 August 2011
Line 20:		Line 20:
	\|rowspan="2"\| [[VI-DB_vi-db-initial\|initial]]		\|rowspan="2"\| [[VI-DB_vi-db-initial\|initial]]
	\|colspan="2"\| [[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="6"\| [[VI-DB_db-esx-check-v4.ps1\|db-esx-check-v4.ps1]]		\|rowspan="10"\| [[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="6"\| [[VI-DB_status.php_v1\|status.php v1]]		\|rowspan="10"\| [[VI-DB_status.php_v1\|status.php v1]]
	\|rowspan="6"\| [[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]]
	\|-		\|-
Line 30:		Line 30:
	\|-		\|-
	! [[#Version 1.2\|Version 1.2]]		! [[#Version 1.2\|Version 1.2]]
	\|rowspan="3"\| [[VI-DB_vi-db-update-v1.2\|update-v1.2]]		\|rowspan="3"\| [[VI-DB_vi-db-update-v1.2\|update v1.2]]
	\|colspan="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="3"\| [[VI-DB_index.php_v1.1\|index.php v1.1]]		\|rowspan="3"\| [[VI-DB_index.php_v1.1\|index.php v1.1]]
	\|rowspan="2"\| [[VI-DB_snaps.php_v1\|snaps.php v1]]		\|rowspan="3"\| [[VI-DB_snaps.php_v1\|snaps.php v1]]
	\|-		\|-
	! [[#Version 1.2.1\|Version 1.2.1]]		! [[#Version 1.2.1\|Version 1.2.1]]
Line 42:		Line 42:
	\|-		\|-
	! [[#Version 2.0\|Version 2.0]]		! [[#Version 2.0\|Version 2.0]]
	\| [[VI-DB_vi-db-update-v2.0\|update-v2.0]]		\|rowspan="2"\| [[VI-DB_vi-db-update-v2.0\|update v2.0]]
	\| [[VI-DB_db-base-data-v2.0.ps1\|db-base-data-v2.0.ps1]]		\|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]]		\| [[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]]		\|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]]
			\| [[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]]
			\| [[VI-DB_index.php_v2.4\|index.php v2.4]]
			\| [[VI-DB_alpha.css_v2\|alpha.css v2]]
			\| [[VI-DB_vapps.php_v2\|vapps.php v2]]
	\|}		\|}

← Older revision		Revision as of 10:22, 21 June 2011
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)
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="4"\| [[VI-DB_db-esx-check-v4.ps1\|db-esx-check-v4.ps1]]		\|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="4"\| [[VI-DB_status.php_v1\|status.php v1]]		\|rowspan="6"\| [[VI-DB_status.php_v1\|status.php v1]]
	\|rowspan="4"\| [[VI-DB_alpha.css_v1\|alpha.css v1]]		\|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="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]]
	\|rowspan="2"\| [[VI-DB_index.php_v1.1\|index.php v1.1]]		\|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]]

← Older revision		Revision as of 08:20, 12 October 2011
Line 20:		Line 20:
	\|rowspan="2"\| [[VI-DB_vi-db-initial\|initial]]		\|rowspan="2"\| [[VI-DB_vi-db-initial\|initial]]
	\|colspan="2"\| [[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="10"\| [[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="10"\| [[VI-DB_status.php_v1\|status.php v1]]		\|rowspan="11"\| [[VI-DB_status.php_v1\|status.php v1]]
	\|rowspan="9"\| [[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]]
Line 40:		Line 40:
	! [[#Version 1.2.2\|Version 1.2.2]]		! [[#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]]		\|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]]		! [[#Version 2.0\|Version 2.0]]
Line 63:		Line 64:
	\|-		\|-
	! [[#Version 2.4\|Version 2.4]]		! [[#Version 2.4\|Version 2.4]]
	\| [[VI-DB_vi-db-update-v2.4\|update v2.4]]		\|rowspan="2"\| [[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]]		\| [[VI-DB_db-base-data-sub-v2.4.ps1\|db-base-data-sub-v2.4.ps1]]
	\| [[VI-DB_index.php_v2.4\|index.php v2.4]]		\|rowspan="2"\| [[VI-DB_index.php_v2.4\|index.php v2.4]]
	\| [[VI-DB_alpha.css_v2\|alpha.css v2]]		\|rowspan="2"\| [[VI-DB_alpha.css_v2\|alpha.css v2]]
	\| [[VI-DB_vapps.php_v2\|vapps.php v2]]		\| [[VI-DB_vapps.php_v2\|vapps.php v2]]
			\|-
			! [[#Version 2.5\|Version 2.5]]
			\| [[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]]
			\| [[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]]
	\|}		\|}