none
How to setup Custom Reporting RRS feed

Answers

All replies

  • Hey,

    Yes you can indeed.  The link from technet points you to the different views in the SQL database of DPM that you can use to rebrand or rearrange your reports.

    DPM 2010 works on SQL, and uses SQL reporting for the reports.  So basically using the Report Builder is an option, but then you need to create a model yourself first.  My advice would be to use visual studio and start working on reports. 

    Just my 2 cents,

    Cheers,

    Mike Resseler


    Visit System Center User Group Belgium @ http://scug.be and http://scug.be/blogs/scdpm
    Monday, January 24, 2011 8:40 AM
    Moderator
  • Mike, i am also in need of some help with custom reports.

    My supervisor was able to make a splendid report that tells us how much data being used by each entity,  (replica size allocated and replica size used; recovery point allocated and recovery point size used.)  it is wonderful. 

    the issue i have is that i want to run this report from withing the Reporting tab within the DPM console.  there is an icon in the reporting tab that shows the name and an icon for the report that we created, but when i click on it, i immediatly receive an error.  the report can be ran from http://dpm/Reports_MSDPM2010 with no errors. 

     

    I am lead to believe that we are missing something that links the actual report with to the icon in the dpm console.  please tell me you know something regarding this,

     

    thanks

    Ian


    Ian
    Tuesday, January 25, 2011 4:48 PM
  • Hey Guys,

    I'm afraid I have to dissappoint you here...

    Yes you can do custom reporting, no you cannot link it in the DPM console... If you have OpsMgr, then you can do more ofcourse...

    But in this version, it is not possible... I know it is been asked for the DPM vNext a lot so let's hope it is inside there...

    Cheers,

    Mike


    Visit System Center User Group Belgium @ http://scug.be and http://scug.be/blogs/scdpm
    Tuesday, January 25, 2011 4:53 PM
    Moderator
  • thanks for the responce. that is a shame because it would just be nice.  what is it that dpm would need to make it work. the only thing i could find that i though might be an issue, was that the current reports that are created by default with an installation of DPM, have a report definition file at c:\program files\microsoft dpm\dpm\bin\dpmreports.  my report does not have such a file.

    thanks

    Ian


    Ian
    Tuesday, January 25, 2011 5:12 PM
  • Hello Mike,

    Are there any resources you would recommend that could help me get started with Visual Studio and SQL reporting?

    So then, the scheduling and emailing of these reports would then be handled by SSRS instead of by DPM, is that correct? Are there historical views of these reports available in DPM?

    Finally, with the SQL views that DPM has available, where do you actually utilize these "views" at? Is that done from within Visual Studio as well?

    Thanks again --RS

     

    Tuesday, January 25, 2011 9:46 PM
  • Ian,

    Do you know how your supervisor was able to do this? I would love to make a report very similar to what you described, but I am having no luck getting anywhere wtih this. Did he use Visual Studio or the Report Builder from SQL Reporting?

    Thanks much -RS

    Tuesday, January 25, 2011 9:47 PM
  • Hey,

    There are not many resources out there, and my reporting skills are... well terrible :-)

    But you can always try to start with the great OpsMgr guidance on custom reporting such as here: http://blogs.technet.com/b/jonathanalmquist/archive/2011/01/03/custom-report-authoring-for-beginners.aspx

    Cheers,

    Mike


    Visit System Center User Group Belgium @ http://scug.be and http://scug.be/blogs/scdpm
    Wednesday, January 26, 2011 8:38 AM
    Moderator
  • Rich, my supervisor used a function within the SQL server that was installed when installing DPM with the defailt setting (tell it to install its own copy of SQL)

    The app used was the SQL Server Buisness Intelligence Developer Studio. He has a pretty extensive knowledge of SQL so it was somewhat easy for him to make.  (maybe took 2 hours or 3)  i sat down with him to make a few revision changes.  we had to look into the DPMDB and look how fields matched to datasets matched to ....  you get the point.  if you are unfamiliar with SQL, i think it will be challenging to say the least.

     


    Ian
    Friday, January 28, 2011 1:54 PM
  • Hi Rich,

    Yes you need Report Builder or another tool like Visual Studio or (Business Intelligence Development Studio) BIDS. These can be challenging if you are not familiar with SQL. It is recommended to use the DPM SQL views with Report Builder to get the reports you want. Here is a link to a post that may help you get going: http://www.buchatech.com/2011/01/building-custom-reports-in-dpm/ .


    Monday, January 31, 2011 6:29 AM
    Moderator
  • Yes!! Perfect! That was exactly what I was looking for. Thanks so much for the very valuable post, and for your step by step. Extremely valuable to have that!

    -Rich

    Monday, January 31, 2011 4:10 PM
  • what a pity I do not speak English very well, but you solved your problem? I have report builder in my DPM 2010 server and the client wants some reportsat their discretion but would like to know if there is a block diagram or chart to get these reports can help me?
    Tuesday, May 15, 2012 2:57 PM
  • what a pity I do not speak English very well, but you solved your problem? I have report builder in my DPM 2010 server and the client wants some reportsat their discretion but would like to know if there is a block diagram or chart to get these reports can help me?
    Tuesday, May 15, 2012 3:00 PM