Virtual Infrastructure DB Project: Difference between revisions

From vwiki
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   
! D'base
! Database
!colspan="2"| Data Collection
!colspan="2"| Data Collection
!colspan="3"| Presentation (Main)
!colspan="3"| Presentation (Main)
!colspan="3"| Presentation (Other)
! 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="2"| [[VI-DB_db-esx-check-v4.ps1|db-esx-check-v4.ps1]]
|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="2"| [[VI-DB_status.php_v1|status.php v1]]
|rowspan="3"| [[VI-DB_status.php_v1|status.php v1]]
|rowspan="2"| [[VI-DB_alpha.css_v1|alpha.css v1]]
|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...

  1. 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)
  2. MySQL database (run on an Ubuntu VM)
  3. 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


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)
Retrieved from ‘http://vwiki.co.uk/index.php?title=Virtual_Infrastructure_DB_Project&oldid=1245’