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
Is there perhaps a command to determine from root e.g C:\Program Files what exactly is backed up
Thanks for sharing, but small question.
Where is it actually using this part “where {$_.Protected -eq “True”}”?
Seems this part of code isn’t actually used or am I wrong?
At least not on DPM 2016