raandree

<#
    .SYNOPSIS
    Gets event log entries from remote computers using RPC/DCOM (same as connecting to remote computer from event log viewer MMC)

    .DESCRIPTION
    Gets event log entries from remote computers using RPC/DCOM (same as connecting to remote computer from event log viewer MMC)

    .NOTES
    --------------------------------------------------------------------------------
     Script author:    Per Pedersen - [email protected]

raandree

$pullServer = Get-LabVM -Role DSCPullServer
$sqlServer = Get-LabVM -Role SQLServer2016

$before = Invoke-LabCommand -ActivityName 'Get Row Count' -ComputerName $sqlServer -ScriptBlock {
    Invoke-Sqlcmd -Database DSC -Query "SELECT COUNT(*) AS Count FROM StatusReport"
} -PassThru

Invoke-LabCommand -ActivityName 'Backup DSC Database' -ComputerName $sqlServer -ScriptBlock {
    mkdir C:\SQLBackups -Force
    $backupCmd = "BACKUP DATABASE [DSC] TO  DISK = N'C:\SQLBackups\DSC {0:yyMMdd-hhmmss}.bak' WITH NOFORMAT, NOINIT,  NAME = N'DSC-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10" -f (Get-Date)

raandree

using namespace System.Collections.Generic
function Show-Tree
{
# .SYNOPSIS

#     Print a tree given a key property and parent property
#
# .PARAMETER InputObject
#
#     The object to print.

raandree

throw "NotImplementedYet"