none
DPM Custom Report RRS feed

  • Question

  • I'm probably not the first person that thinks that the DPM reports included with DPM2010 leave a lot to be desired.  I unfortunately do not know how to write a custom report.  Can someone help me write a simple DPM custom report... All I would like is a report sent to me daily that has each basically three columns... Server Name, Whether the backup was successful or failed, and Error code in case of failure.  Doesn't even have to be pretty.  I would really appreciate it.  Thanks.
    SMaximus7
    • Moved by T Franke Friday, May 20, 2011 6:21 PM (From:DPM Hyper-V and CSV Clusters)
    Friday, May 20, 2011 1:18 PM

Answers

  • Yeah I saw that, but when I tried to create the report following that, the results were not good.  I need a bit more help.
    SMaximus7


    Hi SMaximus7,

    Can you give some more info on what went wrong? Maybe I can help you get the report you are looking for. I can see that being a useful report.

    Also have you tried working with the Vw_DPM_RecoveryPointDisk view?:

     

    Vw_DPM_RecoveryPointDisk: Status of recent recovery point creation jobs on disk.

     

    Field

    Data type

    Description

    DataSourceName

    String

    The data source for which the backup was created

    ServerName

    String

    The server on which the data source exists

    CreationTime

    Date and time

    The time at which the recovery point creation job was run

    Status

    Integer

    0/1=Progress

    2=Succeeded

    3=Failure

    Status of the recovery point creation job

    ErrorCode

    Integer

    Zero if succeeded.

    Else, set to a DPM error code.

    http://technet.microsoft.com/en-us/library/ff399120.aspx


    My Blog | www.buchatech.com | www.systemcenterdataprotectionmanager.com

    Saturday, May 21, 2011 7:09 AM
    Moderator

All replies

  • Hi,

     

    Buchatech has a nice blog posting that walks you through creating a custom DPM report. See

    http://www.buchatech.com/2011/01/building-custom-reports-in-dpm/

     

    Thanks,

    Marc

    Friday, May 20, 2011 2:45 PM
    Moderator
  • Yeah I saw that, but when I tried to create the report following that, the results were not good.  I need a bit more help.
    SMaximus7
    Friday, May 20, 2011 2:49 PM
  • Yeah I saw that, but when I tried to create the report following that, the results were not good.  I need a bit more help.
    SMaximus7


    Hi SMaximus7,

    Can you give some more info on what went wrong? Maybe I can help you get the report you are looking for. I can see that being a useful report.

    Also have you tried working with the Vw_DPM_RecoveryPointDisk view?:

     

    Vw_DPM_RecoveryPointDisk: Status of recent recovery point creation jobs on disk.

     

    Field

    Data type

    Description

    DataSourceName

    String

    The data source for which the backup was created

    ServerName

    String

    The server on which the data source exists

    CreationTime

    Date and time

    The time at which the recovery point creation job was run

    Status

    Integer

    0/1=Progress

    2=Succeeded

    3=Failure

    Status of the recovery point creation job

    ErrorCode

    Integer

    Zero if succeeded.

    Else, set to a DPM error code.

    http://technet.microsoft.com/en-us/library/ff399120.aspx


    My Blog | www.buchatech.com | www.systemcenterdataprotectionmanager.com

    Saturday, May 21, 2011 7:09 AM
    Moderator
  • I am also wondering about this.

    I have managed to get to where you suggest myself, but im at aloss of how to filter the creation date.

    How can i filter the creation date to show only last 24 hours, or maybe last 7 days.

    What i would really like, is a view as simple as possible. Something that will just list out any datasources With a status that is NOT ok (status 2) at the time of the report.

    I do not need to know if something was wrong earlier, i want to know only of the active errors like the Active alerts page in monitoring on the console.

    When i list status 3 from recoverypoint disk, i will get a lot of errors even if all errors are allready fixed. Since it lists all errors that have occured, not the errors that are still a problem.

    Since DPM usually manages to fiks errorr by it self, i do not need to know what has been a problem, i would like to list only what is a problem right now.


    • Edited by Fredrik Weme Monday, July 29, 2013 12:10 PM reedit
    Monday, July 29, 2013 11:15 AM