Como revisar rapidamente los puntos de recuperacion usando un Script the powershell (4037589)

Se require revisar los puntos de recuperacion protegidos por el Core

Un indicativo de si el punto de recuperacion esta en buen estado es el hecho de si un punto de recuperacion puede ser montado y los archivos listados  e incluso si se puede correr un chkdsk seria una gran idea sin embargo el hacer esto extenderia la duracion de la prueba del punto de montaje de tal manera que no se puede esparar por ello

Este script the AppAssure le probee a usted esa capacidad de revisar los puntos de recuperacion y guarda el resultado en un archivo CSV

NOTA: Sobre los Scripts de powershell

https://support.quest.com/appassure/kb/119405

Este Script de powershel ha sido preparado para resolver esa situacion especificada anteriormente, la ayuda de como utilizar este Scrip puede ser obtenidad ejecutando 

# get-help .\mountcheck.ps1 -full

Requerimientos Powershell 3.0 

Este script debe ser ejecutado en un CORE con el servicio corriendo, si se ejecuta sin parametros los ultimos 3 recovery points son los que se revisan excluyendo los folders Windows","System Volume Information","Program Files (x86)","Program Files" folders and the "*.exe","*.dll" 

El resultado del script es almacenado en c:\temp\RPs.csv (el directorio necesita ser creado manualmente antes de ejecutar el script)

-----------------------------------------------------------------------------

<#

.Synopsis 

Checks AppAssure Recovery Points

.Description

Checks AppAssure Recovery Points taking into account the protected server, clusters and replicated servers on the core, the desired number of mount points for the operation, the folders to be excluded (i.e. windows) and the files to be excluded (i.e. *.dll).

.PARAMETER mountpath

the path where the mounting process is executed (default c:\M)

.PARAMETER folderexclusions 

(default: "Windows","System Volume Information","Program Files (x86)","Program Files")

.PARAMETER fileexclusions 

(default: "*.exe","*.dll")

.PARAMETER lastrp 

(the number of recovery points to be considered, beginning with the newest ones, default: 3)

.PARAMETER file

(default: c:\temp\RPS.csv; please note that if the log file is already present an extension which includes the date and time of creation is added to the file name)

.Example 

.\MountCheck.ps1 -folderexclusions "*" 

.Example 

.\Catalog.ps1 -lastrp all

.Example

.\Catalog.ps1 -folderexclusions "Windows","System Volume Information","Program Files (x86)","Program Files" -file c:\temp\log.csv -lastrp 1

#>

#Parameters

param(

$mountpath = "C:\M",

$file = "c:\temp\RPs.csv",

[array]$folderexclusions =("Windows","System Volume Information","Program Files (x86)","Program Files"),

[array]$fileexclusions=("*.exe","*.dll"),

$lastrp=3

)

#prepare log if multiples are present

$suffix=(get-date).tostring("yyyy-MM-dd-hh-mm-ss-tt")

if(!(test-path $file)){$file= $file.replace(".","$($suffix).") }

$startlocation = get-location

cls

Write-Host "Recovery Points Check`r`n---------------------`r`n"

$core=$env:computername

#Attention user about exclusions

Write-host "`r`nExcluded Folders" -f Yellow

$folderexclusions

Write-host "`r`nExcluded Files" -f Yellow

$fileexclusions

#get machines to check

$servers = (get-protectedservers).displayname

$replicatedServers=(get-replicatedservers).displayname

$nodes = (Get-Clusters).displayname

$clusters= ((Get-Clusters).parentclusterdisplayname | group ($_.parentclusterdisplayname)).name

$protectedservers = $servers+ $replicatedservers + $nodes + $clusters | sort-object

#Loop through protected machines

foreach ($protectedserver in $protectedservers){

#local settings to avoid undue errors

$lastcatalog=@()

if(!(test-path $mountpath)){new-item -Path $mountpath -ItemType directory}

set-location $mountpath

#make sure that nothing is already mounted in the folder

Remove-Mount -path $mountpath -ErrorAction SilentlyContinue

#get rps

$allrps = Get-RecoveryPoints -ProtectedServer $protectedserver -Number $lastrp

#get volumes

foreach ($rp in $allrps){

$vols = ((($rp.VolumeImageSummaries).volumename).displayname).replace("\","")

#More messages

write-host "`r`nChecking Server $protectedserver, last $lastrp Recovery Points" -f Yellow

write-host "`r`nFound Volumes $vols" -f Yellow

write-host "`r`nAttempting to dismount previous recovery points" -f Yellow

Remove-Mount -path $mountpath -ErrorAction SilentlyContinue

#Mounting

write-host "`r`nMounting Recovery point number $($rp.number) with the Date-Time Stamp: $(($rp.datetimestamp).ToLocalTime()) EST" -f Yellow

try{

New-Mount -protectedserver $protectedserver -rpn $rp.number -Path $mountpath -ErrorAction Stop

}

catch {Write-host "Cannot mount Recovery Point on $protectedserver RPN: $($rp.number)" -f Red; break}

#check when mount is complete

$command = "cmd.exe /C dir $mountpath"

do {

$checklines = @()

$junctioncheck0 =@(Invoke-Expression -Command:$command)

$junctioncheck = $junctioncheck0[7..($junctioncheck0.count-3)]

foreach ($line in $junctioncheck){

[array]$checkline = $line -split "\s+"

$obj = [pscustomobject]@{Date=($checkline[0]+" "+$checkline[1]+" "+$checkline[2]);Type=$checkline[3];Folder=$checkline[4];ID=$checkline[5]}

$checklines +=$obj

}

$checklines | ft

$totalx = 51*($checklines.count)

$total = 0

foreach ($id in $checklines)

{

$total += ($id.id).length

}

if ($total -lt $totalx){write-host "waiting..." -f yellow}else{write-host "Done!" -f yellow}

start-sleep 5

}while ($total -ne $totalx)

$location = Get-Location

#deal with each drive separately

$folderlist = @()

foreach($v in $checklines){

set-location "$mountpath\$($v.Folder)"

#get folder list on selected drive

try{

$yyy = Get-ChildItem -Exclude $folderexclusions -path "$mountpath\$($v.Folder)" -force -ErrorAction Stop| Where { $_.PSIsContainer } | Select-Object FullName 

$folderlist +=$yyy

}catch {Write-host "ERROR: ($mountpath\$($v.Folder)) is not accessible" -f Red; break}

}    

#get the list of files

$catalogfiles = @()

    foreach ($folder in $folderlist){

    $folder

    $zzz = Get-ChildItem -Path ($folder.FullName) -Force -Erroraction silentlycontinue -exclude $fileexclusions| Where { $_.Mode[0] -ne "d" }  |Select-Object -property FullName,LastWriteTime,CreationTime,LastAccesstime

    $catalogfiles += $zzz

    }

#get process files

$finalcatalog = @()

foreach ($catalogline in $catalogfiles){

$filepath = (split-path $catalogline.fullname -Parent).replace("$mountpath\","").Replace("__",":")

$filename = split-path $catalogline.fullname -Leaf

$entryline = [pscustomobject]@{Core=$core;Protectedserver=$rp.agenthostname;Volumes=([string]::Join(", ",$vols));RP_Number=$rp.number;RP_Date=$rp.DateTimestamp;Path=$filepath;Filename=$filename;LastWriteTime=$catalogline.LastWriteTime;CreationTime=$catalogline.CreationTime;LastAccesstime=$catalogline.LastAccessTime}

$finalcatalog +=$entryline

}

$lastcatalog +=$finalcatalog

}

set-location $location

#process results (screen and file)

$lastcatalog | ft

$lastcatalog | select-object -property Core,Protectedserver,volumes,RP_Number,RP_Date,Path,Filename,LastWriteTime,CreationTime,LastAccesstime | export-csv -Path $file -Force -NoTypeInformation -Append

}

set-location $startlocation

#process results

#Invoke-Item $file

$postprocess = import-csv -path $file

$postprocess | group-object -property protectedserver,volumes | Out-GridView -PassThru

$postprocess | Out-GridView -PassThru

-----------------------------------------------------------------------------