RESONEWorkspace

2.5.0

Examples/RESONEWorkspaceLabExample.ps1

$config = @{
    AllNodes = @(
        @{
            NodeName = 'localhost';
            PSDSCAllowPlainTextPassword = $true;

            ROWDatabaseServer  = 'controller.lab.local';
            ROWDatabaseName    = 'RESONEWorkspace';
            ROWBinariesFolder  = 'C:\SharedData\Software\RES\ONE Worksapce 2015\SR1';
            ROWBinariesVersion = '9.10.1';
            ROWRelayServerPort = 1943;
        }
    )
}

configuration RESONEWorkspaceLabExample {
    param (
        ## RES ONE Workspace SQL database/user credential
        [Parameter(Mandatory)]
        [System.Management.Automation.PSCredential]
        [System.Management.Automation.CredentialAttribute()] $Credential,

        ## Microsoft SQL Server credentials used to create the RES ONE Workspace database/user
        [Parameter(Mandatory)]
        [System.Management.Automation.PSCredential]
        [System.Management.Automation.CredentialAttribute()] $SQLCredential
    )

    Import-DscResource -ModuleName RESONEWorkspace;

    node 'localhost' {

        ROWLab 'ROWLab' {

            DatabaseServer  = $node.ROWDatabaseServer;
            DatabaseName    = $node.ROWDatabaseName;
            Path            = $node.ROWBinariesFolder;
            Version         = $node.ROWBinariesVersion;
            SQLCredential   = $SQLCredential;
            Credential      = $Credential;
            RelayServerPort = $node.ROWRelayServerPort;
        }

    }

} #end configuration RESONEWorkspaceLabExample

if (-not $cred) { $cred = Get-Credential -UserName 'RESONEWorkspace' -Message 'RES ONE Workspace SQL account credential'; }
if (-not $sqlCred) { $sqlCred = Get-Credential -UserName 'sa' -Message 'Existing SQL account for database creation'; }
RESONEWorkspaceLabExample -OutputPath ~\Documents -ConfigurationData $config -Credential $cred -SQLCredential $sqlCred;