Need a powershell script to send email of proetction group status of each datasource. I am trying to build report though reporting services report bulider, but bad luck. #DPM 2012 SP1

Hi,

The "recovery point status" report should provide insight into the health of the protection group members.  It can be mailed to you daily for you to review.

I have 25 Protection Groups, with 445 datasources and 36TB Storage Pool. Its not possible to view one by one each member and datasource. I was trying to fetch info by script like "Get-DataSource $PG | Select -property Name, State, bla...blaa" The Script is giving output but not perfect. This is showing Invalid datasources, but skipping "Recovery Point creation failed" ones. Its Showing them "valid"

Is it not possible to fetch PG's State at particular time by powershell..!! and then e-mail? 

I am using below Script

$PGS = Get-DPMProtectionGroup -DPMServername abc.com

Get-DataSource -ProtectionGroup $PGS | select ProtectionGroupName, DataSourceName, State

This is displaying Good output, but skipping datasources which are with status "recovery point creation failed" it even showing them VALID.

• Edited by Vijay MC 19 hours 44 minutes ago

Hi,

Perhaps listing last successful recovery point time would prove useful.

Get-DataSource -ProtectionGroup $PGS | select ProtectionGroupName, DataSourceName, LatestRecoveryPointLabel

I have 25 Protection Groups, with 445 datasources and 36TB Storage Pool. Its not possible to view one by one each member and datasource. I was trying to fetch info by script like "Get-DataSource $PG | Select -property Name, State, bla...blaa" The Script is giving output but not perfect. This is showing Invalid datasources, but skipping "Recovery Point creation failed" ones. Its Showing them "valid"

Is it not possible to fetch PG's State at particular time by powershell..!! and then e-mail? 

I am using below Script

$PGS = Get-DPMProtectionGroup -DPMServername abc.com

Get-DataSource -ProtectionGroup $PGS | select ProtectionGroupName, DataSourceName, State

This is displaying Good output, but skipping datasources which are with status "recovery point creation failed" it even showing them VALID.

• Edited by Vijay MC Tuesday, January 14, 2014 4:31 PM