Script Repository

Data Source Monitoring Script for OpsMgr (Cookdown)

David — Fri, 13 Aug 2010 12:00:00 GMT

This script is for use in a Operations Manager monitor and requires the DPM Server Name to be passed to it. For full details on how to use this script, see the article "Monitoring DPM using OpsMgr, Cookdown & PowerShell" here, http://www.scdpmonline.org/monitoring-dpm-using-opsmgr-cookdown-powershell.aspx.

View the script below or click here to download it.

I don't confess to being a PowerShell guru and I'm sure this script could be made more efficient. If your PoSh skills are better than mine and you have suggestions for improving this, please let me know using the PowerShell Forum. Thank you.

----------

param([string] $DPMServerName)

$scomapi = new-object -comObject "MOM.ScriptAPI"$scombag = $scomapi.CreatePropertyBag()

$logerror = 1$logwarning = 2$loginfo = 4

$scriptname = "DTTCheckDataSourceState.ps1"

If(!$DPMServerName)

{

$scomapi.LogScriptEvent($scriptname, 5800, $loginfo, "No DPM server name supplied, exiting script")

Exit 0

}

$dsl = Get-Datasource -DPMServerName $DPMServerName | Where-Object {$_.Protected -eq "True"}

If(!$dsl)

{

$scomapi.LogScriptEvent($scriptname, 5800, $loginfo, "No protected data sources found")

}

Foreach($ds in $dsl)

{

If($ds.Type.Name -eq "Volume")

{

If($ds.state -eq "Valid")

{

$state = "OK"

}

Elseif($ds.state -eq "Invalid")

{

If($ds.activity -eq "Validating")

{

$state = "OK"

}

Else

{

$state = "ERROR"

}

}
ElseIf($ds.Type.Name -match "SQL*")

{

If($ds.state -eq "Valid")

{

$state = "OK"

}

ElseIf($ds.state -eq "Invalid")

{

If($ds.activity -eq "Validating")

{

$state = "OK"

}

Else

{

$state = "ERROR"

}

}
EelseIf($ds.Type.Name -eq "FileGroup")

{

If($ds.state -eq "Valid")

{

$state = "OK"

}

ElseIf($ds.state -eq "Invalid")

{

If($ds.activity -eq "Validating")

{

$state = "OK"

}

Else

{

$state = "ERROR"

}

}
ElseIf($ds.Type.Name -eq "Storage group")

{

If($ds.state -eq "Valid")

{

$state = "OK"

}

ElseIf($ds.state -eq "Invalid")

{

If($ds.activity -eq "Validating")

{

$state = "OK"

}

Else

{

$state = "ERROR"

}

}
elseif($ds.Type.Name -eq "Sharepoint farm")

{

if($ds.state -eq "Valid")

{

$state = "OK"

}

elseif($ds.state -eq "Invalid")

{

if($ds.activity -eq "Validating")

{

$state = "OK"

}

else

{

$state = "ERROR"

}

}
elseif($ds.Type.Name -eq "Windows Sharepoint Services Search")

{

if($ds.state -eq "Valid")

{

$state = "OK"

}

elseif($ds.state -eq "Invalid")

{

if($ds.activity -eq "Validating")

{

$state = "OK"

}

else

{

$state = "ERROR"

}

}
elseif($ds.Type.Name -eq "Exchange Mailbox Database")

{

if($ds.state -eq "Valid")

{

$state = "OK"

}

elseif($ds.state -eq "Invalid")

{

if($ds.activity -eq "Validating")

{

$state = "OK"

}

else

{

$state = "ERROR"

}

}
elseif($ds.Type.Name -eq "System Protection")

{

if($ds.state -eq "Valid")

{

$state = "OK"

}

elseif($ds.state -eq "Invalid")

{

if($ds.activity -eq "Validating")

{

$state = "OK"

}

else

{

$state = "ERROR"

}

}
else

{

$scomapi.LogScriptEvent($scriptname, 5802, $loginfo, "Datasource type $($ds.Type.Name) for $($ds.Name) is not recognised")

}

$bag = $scomapi.CreatePropertyBag()

$bag.AddValue('DatasourceName',$ds.name)

$bag.AddValue('ProductionServerName',$ds.ProductionServerName)

$bag.AddValue('Status',$state) $bag.AddValue('DSID',$ds.id.guid)

$bag

}

David ...

Recover Share using PowerShell Script

David — Wed, 13 Jan 2010 17:34:32 GMT

View the article DPM - Using PowerShell to Recover Shares for full details of this script.

---------

param([string] $DPMServerName, $ProtectionGroup, $Datasource, $ShareName, $DestinationServer, $DestinationLocation)

function Usage()
{
write-host
write-host "Usage::"
write-host "Recover-Share.ps1 -DPMServerName [DPMServerName] -ProtectionGroup [ProtectionGroupName] -Datasource [DatasourceName] -ShareName [ShareName] -DestinationServer [DestinationServer] -DestinationLocation [DestinationLocation]"
write-host
write-host "Run 'Recover-Share.ps1 -detailed' for detailed help"
write-host
write-host
}

if(("-?","-help") -contains $args[0])
{
Usage
exit 0
}

if(("-detailed") -contains $args[0])
{
write-host
write-host "Detailed Help : Use this script to recover a share"
write-host
write-host "Example: Recover-Share.ps1 -DPMServerName 'DPM01.lab.com' -ProtectionGroup 'Shares' -Datasource 'C:\' -ShareName 'NewShare' -DestinationServer 'FILE01.lab.com' -DestinationLocation 'C:\ShareRecovery'"
write-host
exit 0
}

if((Get-PSSnapIn -Name "Microsoft.DataProtectionManager.PowerShell" -ErrorAction SilentlyContinue) -eq $null)

{

Add-PSSnapIn "Microsoft.DataProtectionManager.PowerShell"

}

if(!$DPMServerName)
{
$DPMServerName = read-host "DPMServerName::"
}

$DpmServer = Connect-DPMServer $DPMServerName
if (!$DpmServer)
{
write-Error "Failed To Connect To DPM Server::$DPMServerName"
exit 1
}

if(!$ProtectionGroup)
{
$ProtectionGroup = read-host "ProtectionGroupName::"
}

$pg = Get-ProtectionGroup -DPMServerName $DPMServerName | where { $_.FriendlyName -eq $ProtectionGroup }
if (!$pg)
{
write-Error "Failed To Find A Protection Group Named::$ProtectionGroup"
exit 1
}

if(!$Datasource)
{
$Datasource = read-host "DataSourceName::"
}

$ds = Get-Datasource $pg | where { $_.Name -eq $Datasource }
if (!$pg)
{
write-Error "Datasource Not Found With Name::$Datasource"
exit 1
}

$rp = (Get-RecoveryPoint $ds | sort -Property RepresentedPointInTIme -Descending)[0]
if(!$rp)
{
Write-Error "No Recovery Points Found For Datasource::$Datasource"
exit 1
}

if(!$ShareName)
{
$ShareName = read-host "ShareName::"
}

$ri = Get-RecoverableItem -RecoveryPointForShares $rp | where { $_.UserFriendlyName -eq $ShareName }
if(!$ri)
{
Write-Error "No Recoverable Item Found For Share::$ShareName"
exit 1
}

if(!$DestinationServer)
{
$DestinationServer = read-host "DestinationServer::"
}

if(!$DestinationLocation)
{
$DestinationLocation = read-host "DestinationLocation::"
}

$ro = New-RecoveryOption -TargetServer $DestinationServer -RecoveryLocation copytofolder -FileSystem -AlternateLocation $DestinationLocation -OverwriteType overwrite -RestoreSecurity -RecoveryType Restore

$Recovery = Recover-RecoverableItem -RecoverableItem $ri -RecoveryOption $ro

if($Recovery)
{
Write-Host "Running recovery for $ShareName from $($rp.RepresentedPointInTime)"

While(!$Recovery.HasCompleted)
    {
      Write-Host "." -NoNewLine
      sleep 3
    }

Write-Host "`nJob status: $($Recovery.Status)"
}
else
{
Write-Error "`nCould not find a recovery item on disk for $ShareName"
}

Disconnect-DPMServer

David ...

SQL Recovery Point Script for DPM 2007

pzerger — Wed, 02 Sep 2009 16:31:22 GMT

#
#
# Microsoft PowerShell Source File -- Created with SAPIEN Technologies PrimalScript 2009
#
# NAME: Data Protection Manager 2007 - SQL Recovery Point Script
#
# COMMENT: This Script will Restore the latest recovery point for all SQL databases
# within specified protection group to a network folder
#
# Add-PSSnapin Microsoft.DataProtectionManager.PowerShell

# ==================
#Variables
# ==================
$pgName = "PG_SQL-Data_M2M_Daily"

#DPM server name, destination server and local restore path
$DPMServerName = "MYDPMSERVER"
$DestinationServerName = "RESTORESERVER"
$DestinationLocation = "D:\DAILY\MYBACKUP"

$objtype = "SQL Server 2005 database"

write-host "This Script will Restore the latest recovery point for all SQL databases within specified protection group to a network folder"

if (!(Connect-DPMServer $DPMServerName))
{
Write-Error "Failed to connect To DPM server $DPMServerName"
exit 1
}

#Get the protection group for variable $PgName

$pg = Get-ProtectionGroup $DPMServerName | where { $_.FriendlyName -like $pgName }

if(!$pg)
{
Write-Host "Protection group " $pgName " not found"
exit 1
}

#Get a list of all Datasources with a type of "$ObjType"

$ds = Get-Datasource $pg #|

if(!$ds)
{
Write-Host "error"
exit 1
}

# =========================================================
#BEGIN DEBUG CODE: Writes datasource and type to the screen
# =========================================================

#foreach ($datasource in $ds)
#{
#Write-Host $datasource.type.name " : " $datasource.name
#}
#if (!$Objtype)
#{
# $Objtype = Read-Host "Object type ie : SQL Server 2005 database : "

#if (!$DestinationLocation)
#{
# Write-Error "Object type not specified"
# exit 1
# }
#}

#Display a list of "SqlObjects"

# Restore the latest recovery point of each SQL datasource.
foreach ($datasource in $ds)
{
if ($datasource.type.name -eq $objtype)
{
Write-Host $datasource.name
Write-Host $datasource.type.name

# Restore the latest recovery point of each SQL datasource.

# Select the latest recovery point that exists on disk and trigger the restore job.
foreach ($rp in @(Get-RecoveryPoint -Datasource $datasource | sort -Property RepresentedPointInTime -Descending))
{
foreach ($rsl in $rp.RecoverySourceLocations)
{
if ($rsl -is [Microsoft.Internal.EnterpriseStorage.Dls.UI.ObjectModel.OMCommon.ReplicaDataset])
{
$recoveryOption = New-RecoveryOption -TargetServer $DestinationServerName -TargetLocation $DestinationLocation -RecoveryLocation CopyToFolder -SQL -RecoveryType Restore

$restoreJob = Recover-RecoverableItem -RecoverableItem $rp -RecoveryOption $recoveryOption -RecoveryPointLocation $rsl

break
}
}

if ($restoreJob)
{
break
}
}

if ($restoreJob)
{
Write-Host "`nRunning restore of $($datasource.LogicalPath) from
$($rp.RepresentedPointInTime) to $DestinationServerName\$DestinationLocation"
# Comment out the next 7 lines to not wait for one restore job to finish before triggering the next one.
while (!$restoreJob.HasCompleted)
{
Write-Host "." -NoNewLine
sleep 3
}

#Write-Host "`nJob status: $($restoreJob.Status)"
}
else
{
Write-Error "Could not find a recovery point on disk for
$($datasource.LogicalPath)"
}

}

pzerger ...

Export SCDPM 2007 Exchange Recovery Points on a Schedule

pzerger — Mon, 31 Aug 2009 13:19:40 GMT

# #
# Microsoft PowerShell Source File -- Created with SAPIEN Technologies PrimalScript 2009
#
# NAME: Export SCDPM 2007 Exchange Recovery Points on a Schedule
#
# VERSION: 1.0
#
# AUTHOR: Pete Zerger (www.systemcentercentral.com) and UNKNOWN (I based this on a SQL monitoring snippet I found in a newsgroup)
#
# DESCRIPTION: This Script will Restore the latest recovery point for all Exchange storage groups
#              within specified protection group to a network folder. This script is intended to
#              run as a scheduled task to dump these recovery points to disk. This allows another
#              backup systems can back the data up to tape.
#
#              This script exports recovery points to disks serially (one at a time), but can be
#              modified to dump all in parallel (see commented sectoin at the end of this script).
# #Load DPM cmdlets so we can run from a standard Powershell prompt

Add-PSSnapin Microsoft.DataProtectionManager.PowerShell

# ==================
#Variables
# ==================

#Protection group name or wildcard (allows for alternate restore of multiple protection groups at once)
$pgName = "My_Exchange_Protection_Group"

#DPM server name, destination server and local restore path
$DPMServerName = "MyDPMServer"
$DestinationServerName = "MyDESTServer"
$DestinationLocation = "D:\Daily\EXCHANGE\"

#Resource type being protected.
$objtype = "Storage group"

# ==========================
# End of variable definition
# ==========================

# write-host "This Script will Restore the latest recovery point for all Exchange storage groups within specified protection group to a network folder"

if (!(Connect-DPMServer $DPMServerName))
{
Write-Error "Failed to connect To DPM server $DPMServerName"
exit 1
}

#Get the protection group for variable $PgName

$pg = Get-ProtectionGroup $DPMServerName | where { $_.FriendlyName -like $pgName }

if(!$pg)
{
Write-Host "Protection group " $pgName " not found"
exit 1
}

#Get a list of all Datasources with a type of "$ObjType"

$ds = Get-Datasource $pg #|

if(!$ds)
{
Write-Host "error"
exit 1
}

# =========================================================
#BEGIN DEBUG CODE: Writes datasource and type to the screen
# =========================================================

#foreach ($datasource in $ds)
#{
#Write-Host $datasource.type.name " : " $datasource.name
#}
#if (!$Objtype)
#{
# $Objtype = Read-Host "Object type ie : SQL Server 2005 database : "

#if (!$DestinationLocation)
#{
# Write-Error "Object type not specified"
# exit 1
# }
#}

#Display a list of "SqlObjects"

# Restore the latest recovery point of each SQL datasource.
foreach ($datasource in $ds)
{
if ($datasource.type.name -eq $objtype)
{
Write-Host $datasource.name
Write-Host $datasource.type.name

# Restore the latest recovery point of each SQL datasource.

$restoreJob = Recover-RecoverableItem -RecoverableItem $rp -RecoveryOption $recoveryOption -RecoveryPointLocation $rsl

break
}
}

if ($restoreJob)
{
break
}
}

Write-Host "`nJob status: $($restoreJob.Status)"
}
else
{
Write-Error "Could not find a recovery point on disk for
$($datasource.LogicalPath)"
}

}

pzerger ...

Disable On the Wire Compression

David — Tue, 25 Aug 2009 10:35:57 GMT

This script will disable on the wire compression for a given protection group. This script will check if the DPM PowerShell SnapIn is loaded and load if not which means this script can be run in PowerShell as well as the DPM Command Shell.

To run the script: ./DisableCompression.ps1 -DPMServerName <DPMServerName> -ProtectionGroup <ProtectionGroup>

For usage instructions: ./DisableCompression.ps1 -help

Here is the PowerShell script for you to copy or you can download the full PS1 file at the bottom of this page.

----------Script Start----------

#'''''''''''''''''''''''''''''''''''''''''''''''''''''''''

#

# Author: David Allen

# Date: 24/08/09

#

# http://www.scdpmonline.org

#

# Comment: This script will disable on the wire

# compression for a given DPM protection group.

#

# Instructions for use: ./DisableCompression.ps1 -help

#

#'''''''''''''''''''''''''''''''''''''''''''''''''''''''''

param ([string] $DPMServerName, [string] $ProtectionGroup)

function Usage()

{

write-host

write-host "Usage::"

write-host "DisableCompression.ps1 -DPMServerName [DPMServername] -ProtectionGroup [ProtectionGroupName]"

write-host

write-host "Run 'DisableCompression.ps1 -detailed' for detailed help"

write-host

}

if(("-?","-help") -contains $args[0])

{

Usage

exit 0

}

if(("-detailed") -contains $args[0])

{

write-host

write-host "Detailed Help : Use this script to disable on-the-wire compression on a given protection group."

write-host

exit 0

}

#Check status of DPM SnapIn and load as necessary

$SnapIn = "Microsoft.DataProtectionManager.PowerShell"

if (get-PSSnapIn $SnapIn -ea "silentlycontinue")

{

write-host "PSSnapIn $snapin is loaded"

}

elseif (get-PSSnapIn $SnapIn -registered -ea "silentlycontinue")

{

write-host "PSSnapIn $SnapIn is registered but not loaded"

Write-host "Loading PSSnapIn $SnapIn"

Add-PSSnapIn $SnapIn

}

else

{

write-host "PSSnapIn $SnapIn not found" -foregroundcolor Red

}

#Prompt if the name of the DPM server has not been passed

if(!$DPMServerName)

{

$DPMServerName = read-host "DPMServerName:"

}

#Connect to DPM server

$DpmServer = Connect-DPMServer $DPMServerName

if (!$DpmServer)

{

write-Error "Unable to connect to DPM server::$DPMServerName"

exit 1

}

#Prompt if the name of the protection group has not been passed

if(!$ProtectionGroup)

{

$ProtectionGroup = read-host "ProtectionGroup:"

}

write-host "Disabling compression on protection group $ProtectionGroup"

#Returns a list of all the protection groups on the DPM server and confirms there is at least one

$pgl = @(Get-ProtectionGroup -DPMServerName $DPMServerName)

if($pgl.count -lt 1)

{

write-Error "No protection groups found on DPM server"

exit 1

}

#Get protection group

$pg = $pgl | where {$_.FriendlyName -eq $ProtectionGroup}

if(!$pg)

{

Write-Error "Failed to get protection group"

exit 1

}

#Get modifiable protection group

$mpg = Get-ModifiableProtectionGroup -ProtectionGroup $pg

if(!$mpg)

{

Write-Error "Failed to get modifiable protection group"

exit 1

}

#Enable Compression

set-performanceoptimization -protectiongroup $mpg -disablecompression

#Set the protection group to apply the change

Set-ProtectionGroup -ProtectionGroup $mpg

Write-Host "Compression disabled for portection group $ProtectionGroup"

#Disconnect from the DPM Server

Disconnect-Dpmserver

---------- Script End ----------

Attachment: DisableCompression.ps1

David ...

Enable On the Wire Compression

David — Tue, 25 Aug 2009 10:20:00 GMT

This script will enable on the wire compression for a given protection group. This script will check if the DPM PowerShell SnapIn is loaded and load if not which means this script can be run in PowerShell as well as the DPM Command Shell.

To run the script: ./EnableCompression.ps1 -DPMServerName <DPMServerName> -ProtectionGroup <ProtectionGroup>

For usage instructions: ./EnableCompression.ps1 -help

Here is the PowerShell script for you to copy or you can download the full PS1 file at the bottom of this page.

----------Script Start----------

#'''''''''''''''''''''''''''''''''''''''''''''''''''''''''

## Author: David Allen

# Date: 24/08/09

#

# http://www.scdpmonline.org

#

# Comment: This script will enable on the wire

# compression for a given DPM protection group.

#

# Instructions for use: ./EnableCompression.ps1 -help

#

#'''''''''''''''''''''''''''''''''''''''''''''''''''''''''

param ([string] $DPMServerName, [string] $ProtectionGroup)

function Usage()

{

write-host

write-host "Usage::"

write-host "EnableCompression.ps1 -DPMServerName [DPMServername] -ProtectionGroup [ProtectionGroupName]"

write-host

write-host "Run 'EnableCompression.ps1 -detailed' for detailed help"

write-host

}

if(("-?","-help") -contains $args[0])

{

Usage

exit 0

}

if(("-detailed") -contains $args[0])

{

write-host

write-host "Detailed Help : Use this script to enable on-the-wire compression on a given protection group."

write-host

exit 0

}

#Check status of DPM SnapIn and load as necessary

$SnapIn = "Microsoft.DataProtectionManager.PowerShell"

if (get-PSSnapIn $SnapIn -ea "silentlycontinue")

{

write-host "PSSnapIn $snapin is loaded"

}

elseif (get-PSSnapIn $SnapIn -registered -ea "silentlycontinue")

{

write-host "PSSnapIn $SnapIn is registered but not loaded"

Write-host "Loading PSSnapIn $SnapIn"

Add-PSSnapIn $SnapIn

}

else

{

write-host "PSSnapIn $SnapIn not found" -foregroundcolor Red

}

#Prompt if the name of the DPM server has not been passed

if(!$DPMServerName)

{

$DPMServerName = read-host "DPMServerName:"

}

#Connect to DPM server

$DpmServer = Connect-DPMServer $DPMServerName

if (!$DpmServer)

{

write-Error "Unable to connect to DPM server::$DPMServerName"

exit 1

}

#Prompt if the name of the protection group has not been passed

if(!$ProtectionGroup)

{

$ProtectionGroup = read-host "ProtectionGroup:"

}

write-host "Enabling compression on protection group $ProtectionGroup"

#Returns a list of all the protection groups on the DPM server and confirms there is at least one

$pgl = @(Get-ProtectionGroup -DPMServerName $DPMServerName)

if($pgl.count -lt 1)

{

write-Error "No protection groups found on DPM server"

exit 1

}

#Get protection group

$pg = $pgl | where {$_.FriendlyName -eq $ProtectionGroup}

if(!$pg)

{

Write-Error "Failed to get protection group"

exit 1

}

#Get modifiable protection group

$mpg = Get-ModifiableProtectionGroup -ProtectionGroup $pg

if(!$mpg)

{

Write-Error "Failed to get modifiable protection group"

exit 1

}

#Enable Compression

set-performanceoptimization -protectiongroup $mpg -enablecompression

#Set the protection group to apply the change

Set-ProtectionGroup -ProtectionGroup $mpg

Write-Host "Compression enabled for portection group $ProtectionGroup"

#Disconnect from the DPM Server

Disconnect-Dpmserver

---------- Script End ----------

Attachment: EnableCompression.ps1

David ...