Difference between revisions of "Virtual Infrastructure DB Project"
Jump to navigation
Jump to search
m (→Matrix: Typo fix) |
(→Matrix: Added "Version 1.2") |
||
| Line 12: | Line 12: | ||
|- style="background-color:#bbddff;" | |- style="background-color:#bbddff;" | ||
! Release | ! Release | ||
! | ! Database | ||
!colspan="2"| Data Collection | !colspan="2"| Data Collection | ||
!colspan="3"| Presentation (Main) | !colspan="3"| Presentation (Main) | ||
! | ! Presentation (Other) | ||
|- | |- | ||
! 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]] | | [[VI-DB_db-base-data-v1.0.ps1|db-base-data-v1.0.ps1]] | ||
|rowspan=" | |rowspan="3"| [[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=" | |rowspan="3"| [[VI-DB_status.php_v1|status.php v1]] | ||
|rowspan=" | |rowspan="3"| [[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 | ||
| [[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]] | ||
|- | |||
! Version 1.2 | |||
| [[VI-DB_vi-db-update-v1.2|update-v1.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]] | |||
| [[VI-DB_snaps.php_v1|snaps.php v1.2]] | |||
|} | |} | ||
| Line 35: | Line 41: | ||
** [[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) | ||
** [[PS_getsnapshotsize-1.ps1|getsnapshotsize-1.ps1]] - PowerCLI Get_Snapshot bug workaround | |||
=== Change Log === | === Change Log === | ||
Revision as of 16:11, 24 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
- 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)