Difference between revisions of "Virtual Infrastructure DB Project"
Jump to navigation
Jump to search
m (→Version 1.2: Minor format update) |
(→Version 1.2: Updated release changes) |
||
| Line 53: | Line 53: | ||
==== 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 | ||
* '''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)''' | |||
** 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 | |||
[[Category:VMware]] | [[Category:VMware]] | ||
Revision as of 11:00, 30 March 2011
This started life as small script to collect VM info from 5 or 6 vCentre's (that were a mix of v2.5 and v4, and weren't linked together), so that VM's could be easily found without having to search through each one. There are essentially 3 components to it...
- Data collection scripts (run from a Windows desktop)
- A daily PowerCLI script that collects data from all vCenters (and updates the database)
- An intra-day PowerCLI script (say every 15mins) that collects basic cluster status data (and updates the database)
- MySQL database (run on an Ubuntu VM)
- PHP front end (delivered by Apache running on same Ubuntu VM)
Releases
Matrix
| Release | Database | Data Collection | Presentation (Main) | Presentation (Other) | |||
|---|---|---|---|---|---|---|---|
| Version 1 | initial | db-base-data-v1.0.ps1 | db-esx-check-v4.ps1 | index.php v1 | status.php v1 | alpha.css v1 | vc-detail.php v1, cluster-detail.php v1, vm-detail.php v1 |
| Version 1.1 | db-base-data-v1.1.ps1 | ||||||
| Version 1.2 | update-v1.2 | db-base-data-v1.2.ps1 | index.php v1.2 | snaps.php v1.2 | |||
- Standard include files...
- Standard.ps1 - Basic PowerShell helper (logging etc)
- PowerCLI-helper-v1.1.ps1 - PowerCLI helper (provides API bug workarounds)
- DS-LUN-v4.ps1 - PowerCLI Datastore helper (LUN's etc)
- getsnapshotsize-1.ps1 - PowerCLI Get_Snapshot bug workaround
Change Log
Version 1.1
- Data Collection (db-base-data)
- Bugfix: Where VC provides no VM FolderID, VM is assigned incorrect VC folder path - now catch as error
- Bugfix: VM's having no IPAddress in vCentre not handled properly, causing errors - now handled silently
- Bugfix: Added vmvcid to better handle Lab Manager v4 VM's with duplicate UUIDs
- Bugfix: ESX's moving clusters causes duplicate ESX entries - old ESX/cluster entry now gets expired
- Added snapshot info (data collection only, db table already existed)
Version 1.2
- Data Collection (db-base-data)
- 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 ESX extended data (inc IP - needs further work), ntp, hba and nic info
- 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)
- 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