Project Description
The goal of the library is to automate common infrastructure tasks.

The Global Excel Automation PowerShell library is a series of scripts and module to facilitate certain infrastructure tasks such as:

- Deploy IIS web sites/applications to multiple servers
- Create single application package that can be deployed in multiple environments based on a central configuration store
- Validate the configuration of applications through a series of automated tests
- Configure Application Request Routing servers to load balance http web sites
- Efficiently provision SQL Server databases multiple times through usage of Hyper-V parent and differencing disks
- Database upgrade process when going from one version to another
- Create SQL Server database snapshot (i.e. before doing a database upgrade)
- Configuration of a database when restored in a specific environment
- Restore databases from Microsoft Data Protection Manager
- Create Hyper-V VMs based on a Sysprep parent VHDX
- Create Active Directory users and apply configurable security templates for group memberships

News

2013-12-13

Version 2.4.0.0 released!

2013-12-04

Version 2.3.0.0 released!

Changes included in this release:

New library to integrate with ScrumDo.com
- Get-Project
- Get-ProjectIteration
- Get-ProjectNewsFeed
- Get-BoardCard
- Convert-ToPointScale
- New-BoardCard
- Update-BoardCard


Changes to libServiceBus.psm1
- Documented functions
- Added method to receive messages. It allows for both PeekLock and ReceiveAndDelete methods.

2013-11-28
Documented usage for:
-Add-Clone.ps1
-Create-SQLDataParent.ps1
-Detach-Master.ps1

2013-11-26
Version 2.2.0.0 has been released which contains the SharePoint list templates for the lists that are used in the different automations.

2013-11-15
Version 2.1.0.0 has been released which contains several changes, including a new library to interact with Service Bus for Windows Server. See download page for list of all the changes in the release.

2013-11-13

Version 2.0.2.0 has been released which contains the following changes:

Added functions documentation for libConfigurationDatabase.psm1
Added Get-ClusterVMResourceMeteringStatistics in libHyperVCluster.psm1

2013-11-12
Published Getting Started procedure in the Documentation section.

2013-11-08
Version 2.0.1.0 released! Here's a list of notable changes:

Here's what changed in this release since version 2.0.0.0:

Added LoadBalancersClusterNodes table to store NLB/ARR cluster configuration.
Added migration logic to load existing configuration in SQL Compact database.
Added Type filed to ConfigurationSettings table. This is used in the Assert-EnvironmentConfiguration.ps1 script.

Modified existing scripts/libraries to use SQL Compact database to fetch configuration data:
Assert-EnvironmentConfiguration.ps1
Backup-EnvironmentConfiguration.ps1
Create-ApplicationPackage.ps1
Deploy-Build.ps1
Get-EnvironmentPackageInventory.ps1
Get-PackageInventory.ps1
libApplicationRequestRouting.psm1
libAssertion.psm1
Set-ApplicationConfiguration.ps1

Added new functions to delete various configuration data.

Set encryption method while creating the database.

2013-11-06
Initial release available for version 2.0.0.0. Here's an overview of the changes included in the build:

-Configuration data migrated to SQL Compact database
-Password protected, encrypted using AES256 using a password hashed with SHA512
- Modified Deploy-Build.ps1 and Set-ApplicationConfiguration.ps1 to get the configuration data from the database
- Modified function libApplicationRequestRouting.psm1 that sets web front end nodes Offline/Online for an application in the load balancers
- Several new functions to modify and query the configuration data:
Run-SQLCompactQuery
Remove-ApplicationConfiguration
New-WebSiteVirtualDirectoryConfiguration
New-WebSiteConfiguration
New-WebSiteBindingConfiguration
New-WebSiteApplicationPoolConfiguration
New-Environment
New-ConfigurationSetting
New-ConfigurationDatabase
New-ApplicationDeploymentTarget
New-ApplicationCredentialComponent
New-ApplicationCredential
New-ApplicationConfigurationFile
New-ApplicationConfiguration
Get-WebSiteVirtualDirectoryConfiguration
Get-WebSiteConfiguration
Get-WebSiteBindingConfiguration
Get-WebSiteApplicationPoolConfiguration
Get-NullIfEmpty
Get-Environment
Get-ConfigurationSetting
Get-ConfigurationDatabaseConnection
Get-ApplicationDeploymentTarget
Get-ApplicationCredentialComponents
Get-ApplicationCredential
Get-ApplicationConfigurationFile
Get-ApplicationConfiguration

2013-11-05
Version 2.0.0.0 has started today which includes a change from the XML configuration file to a SQL Compact database. This will allow the configuration database to be encrypted and facilitate basic CRUD operations in the configuration data.

The scripts can do the following:

- Deploy application code to IIS web front ends
- Configure IIS sites
- Configure Application Request Routing farms for web apps
- Create Hyper-V parent disks from databases restores from Data Protection Manager
- Create Hyper-V differencing disks from the parent disks with SQL data
- … And more!

Last edited Dec 13, 2013 at 9:06 PM by misabel, version 15