none
Is there any way to find out all custom reports in sccm 2012 RRS feed

  • Question

  • Is there any way to find out all custom reports that we created in sccm 2012 like using SQL query

    Karthick Jokirathinam | My blogs:http://www.karthickjokirathinam.com | Twitter: @KarthickJoki

    Tuesday, February 9, 2016 4:24 PM

Answers

  • Nope.... A Report, is a Report. Now you can make some guesses based on the name of the report and the date/time the report was created but there is no 100% guarantee that you will get a full list of reports, using a SQL query.

    Garth Jones

    Blog: http://www.enhansoft.com/blog

    Old Blog: http://smsug.ca/blogs/garth_jones/default.aspx

    Twitter: @GarthMJ

    Book: System Center Configuration Manager Reporting Unleased

    Tuesday, February 9, 2016 5:08 PM
    Moderator
  • You could use the console in Monitoring / Reports. Add the Created By column.

    The build in reports should be Created By NT AUTORITY\SYSTEM, the custom one should be based on the user who has imported them.


    Benoit Lecours | Blog: System Center Dudes

    Tuesday, February 9, 2016 6:12 PM
  • The build in reports should be Created By NT AUTORITY\SYSTEM, the custom one should be based on the user who has imported them.

    Actually that would be a good way to do it.  BTW you can do this from the SSRS website too and therefore from a SQL query.

    Garth Jones

    Blog: http://www.enhansoft.com/blog

    Old Blog: http://smsug.ca/blogs/garth_jones/default.aspx

    Twitter: @GarthMJ

    Book: System Center Configuration Manager Reporting Unleased

    Tuesday, February 9, 2016 7:11 PM
    Moderator
  • Yes, nice thought  :)

    Narahari(Hurry) 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. ”

    Tuesday, February 9, 2016 8:37 PM
  • try this SQL query to list all SSRS Reports created by ,modifiedby,datasource etc. Please make sure you run this report against  your reportserver instead of Configmgr DB. From this ,you can sort it out who created what.

    SELECT c.Name,CreatedBy = UC.UserName,

           CreationDate = C.CreationDate,

           ModifiedBy = UM.UserName,ModifiedDate,

           DS.Name AS DatasourceName,

           C.Description   

      FROM Reportserver.dbo.Catalog C

      JOIN Reportserver.dbo.Users UC ON C.CreatedByID = UC.UserID

      JOIN Reportserver.dbo.Users UM ON c.ModifiedByID = UM.UserID

      LEFT OUTER JOIN ReportServer.dbo.SecData AS SD ON C.PolicyID = SD.PolicyID

                                                        AND SD.AuthType = 1

      INNER JOIN ReportServer.dbo.DataSource AS DS ON C.ItemID = DS.ItemID

      order by 1


    Eswar Koneti | Configmgr Blog: www.eskonr.com | Linkedin: Eswar Koneti | Twitter: eskonr



    Tuesday, February 9, 2016 11:26 PM

All replies

  • Nope.... A Report, is a Report. Now you can make some guesses based on the name of the report and the date/time the report was created but there is no 100% guarantee that you will get a full list of reports, using a SQL query.

    Garth Jones

    Blog: http://www.enhansoft.com/blog

    Old Blog: http://smsug.ca/blogs/garth_jones/default.aspx

    Twitter: @GarthMJ

    Book: System Center Configuration Manager Reporting Unleased

    Tuesday, February 9, 2016 5:08 PM
    Moderator
  • You could use the console in Monitoring / Reports. Add the Created By column.

    The build in reports should be Created By NT AUTORITY\SYSTEM, the custom one should be based on the user who has imported them.


    Benoit Lecours | Blog: System Center Dudes

    Tuesday, February 9, 2016 6:12 PM
  • The build in reports should be Created By NT AUTORITY\SYSTEM, the custom one should be based on the user who has imported them.

    Actually that would be a good way to do it.  BTW you can do this from the SSRS website too and therefore from a SQL query.

    Garth Jones

    Blog: http://www.enhansoft.com/blog

    Old Blog: http://smsug.ca/blogs/garth_jones/default.aspx

    Twitter: @GarthMJ

    Book: System Center Configuration Manager Reporting Unleased

    Tuesday, February 9, 2016 7:11 PM
    Moderator
  • Yes, nice thought  :)

    Narahari(Hurry) 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. ”

    Tuesday, February 9, 2016 8:37 PM
  • try this SQL query to list all SSRS Reports created by ,modifiedby,datasource etc. Please make sure you run this report against  your reportserver instead of Configmgr DB. From this ,you can sort it out who created what.

    SELECT c.Name,CreatedBy = UC.UserName,

           CreationDate = C.CreationDate,

           ModifiedBy = UM.UserName,ModifiedDate,

           DS.Name AS DatasourceName,

           C.Description   

      FROM Reportserver.dbo.Catalog C

      JOIN Reportserver.dbo.Users UC ON C.CreatedByID = UC.UserID

      JOIN Reportserver.dbo.Users UM ON c.ModifiedByID = UM.UserID

      LEFT OUTER JOIN ReportServer.dbo.SecData AS SD ON C.PolicyID = SD.PolicyID

                                                        AND SD.AuthType = 1

      INNER JOIN ReportServer.dbo.DataSource AS DS ON C.ItemID = DS.ItemID

      order by 1


    Eswar Koneti | Configmgr Blog: www.eskonr.com | Linkedin: Eswar Koneti | Twitter: eskonr



    Tuesday, February 9, 2016 11:26 PM
  • Thank you for all your suggestion.

    Karthick Jokirathinam | My blogs:http://www.karthickjokirathinam.com | Twitter: @KarthickJoki

    Wednesday, February 10, 2016 1:21 PM