Need help create custom report for protection group using sql qwery or a power shell RRS feed

  • Question

  • Hello! Need help creating a  report for  protection group using a SQL query or powershell
    of the following type

    Protection Group | Computer name (server) | Type backup (BMR, file sare ,SQL-DB ) | DPM server

    i created script but he do not show me childdatasource like this:
    for File share:

    for SQL-DB:

    $hostname = (&hostname)
    $outfile = "D:\temp\" + $hostname + " _DPMDataSources.csv "
    foreach ( $MEMBER in $GROUPLIST ) {
         GET-DATASOURCE -ProtectionGroup $Member | select computer, objecttype
    • Edited by Aleks__ Wednesday, February 7, 2018 2:03 PM
    Wednesday, February 7, 2018 2:02 PM


  • Housekeeping - closing old post.

    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.

    Tuesday, January 7, 2020 12:40 AM