Create DPM Backup List using Powershell

Our auditors were curious about what exactly our Microsoft Data Protection Manager server was backing up. So I did a bit of digging around in the DPM powershell commandlet and came up with this little command.

Command

get-dpmdatasource | where {$_.Protected -eq "True"} | select productionservername, name, objecttype, protectiongroupname | Sort-Object productionservername, name | export-csv dpmserver-backup-list.csv

The CSV is rather basic but provides a nice easy list with enough detail to know what exactly is being backed up on each of the servers. Good luck keeping the auditors happy.

CSV output

ProductionServerName			Name				ObjectType					ProtectionGroupName
alpha-sqlserver.waynezim.com	master				SQL Server 2008 database	SQL Data
alpha-sqlserver.waynezim.com	model				SQL Server 2008 database	SQL Data
alpha-sqlserver.waynezim.com	msdb				SQL Server 2008 database	SQL Data
alpha-sqlserver.waynezim.com	PaperData			SQL Server 2008 database	SQL Data
child-dc1.waynezim.com			C:\					Volume						Domain Controllers
child-dc1.waynezim.com			System Protection	System Protection			Domain Controllers
child-dc2.waynezim.com			C:\					Volume						Domain Controllers
child-dc2.waynezim.com			System Protection	System Protection			Domain Controllers
exchange.cluster.waynezim.com	Administration		Storage group				Exchange Databases 
exchange.cluster.waynezim.com	Developers			Storage group				Exchange Databases 
exchange.cluster.waynezim.com	Helpdesk			Storage group				Exchange Databases 
exchange.cluster.waynezim.com	Other				Storage group				Exchange Databases 
exchange.cluster.waynezim.com	Test				Storage group				Exchange Databases 
sql.cluster.waynezim.com		HAData				SQL Server 2012 database	SQL Cluster Data
sql.cluster.waynezim.com		Test				SQL Server 2012 database	SQL Cluster Data