Difference between revisions of "Virtual Infrastructure DB Project"
Jump to navigation
Jump to search
(→Matrix: Added include files) |
m (→Matrix: Typo fix) |
||
| Line 29: | Line 29: | ||
| [[VI-DB_db-base-data-v1.1.ps1|db-base-data-v1.1.ps1]] | | [[VI-DB_db-base-data-v1.1.ps1|db-base-data-v1.1.ps1]] | ||
|} | |} | ||
* Standard include files... | * Standard include files... | ||
* [[PS_Standard.ps1|Standard.ps1]] - Basic PowerShell helper (logging etc) | ** [[PS_Standard.ps1|Standard.ps1]] - Basic PowerShell helper (logging etc) | ||
* [[PS_PowerCLI-helper-v1.1.ps1|PowerCLI-helper-v1.1.ps1]] - PowerCLI helper (provides API bug workarounds) | ** [[PS_PowerCLI-helper-v1.1.ps1|PowerCLI-helper-v1.1.ps1]] - PowerCLI helper (provides API bug workarounds) | ||
* [[PS_DS-LUN-v4.ps1|DS-LUN-v4.ps1]] - PowerCLI Datastore helper (LUN's etc) | ** [[PS_DS-LUN-v4.ps1|DS-LUN-v4.ps1]] - PowerCLI Datastore helper (LUN's etc) | ||
=== Change Log === | === Change Log === | ||
Revision as of 18:13, 21 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 | D'base | 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 | ||||||||
- 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)
Change Log
Version 1.1
- 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)