Tuesday 19 March 2013

ConfigMgr 2012 / SCCM 2012 SP1 Step by Step Guide Part 14: SQL Reporting

Back to main menu

Part 14 describes the configuration of SQL reporting in Config Mgr 2012. I will also show a sample report and how to export the report to PDF and xls files.


Navigate to Administration/Site Configuration/Servers and Site System Roles
Right click server and choose Add Site System Roles




Add Site System Roles wizard starts



Verify server name


Enter Proxy details if required - not required in this deployment. 


Select Reporting Service Point


Verify database details


Click next to add the Reporting Service Point






Reports are now available in Monitoring/Reporting



See sample report



Click on the drop down arrow to choose file format 



Sample PDF


Sample Excel file

19 comments:

  1. Wow that was unusual. I jusst wrote an incredibly long comment but aafter I clicked submit mmy comment didn't appear.

    Grrrr... well I'm not writing alll thatt over again.
    Anyhow,just wanted to say wonderful blog!

    Also visit my web-site; master resale rights selling your scribd Free work At

    ReplyDelete
  2. Appreciate this post. Will try it out.

    Also visit my weblog jailbreak ipod 4 6.1.3 evasion

    ReplyDelete
  3. You ought to take part in a contest for one of the most useful ssites
    online. I am going too highly recommend this website!


    Feel free to surf to mmy blog ... thrombosed hemorrhoid treatment during pregnancy

    ReplyDelete
  4. Hmm iѕ anyone elѕ&X65; having problemѕ wit&X68; thе
    images on this blog lo&X61;ding? I'm trying tο determine i&X66; its a problem on &X6d;y end or if it's
    the blo&X67;. Any response&X73; would be gгeatlу appreciateԁ.


    Feel free to visi&X74; mу web-site; Hostgator Helmet Cam Review Wordpress

    ReplyDelete
  5. Gerry,

    I really appreciate your help. May the fruits of your labor and help come back to you bountifully. The Reporting Services server instance: is not showing my MSSQLServer. Do you know why this is the case; actually it's not giving me any option.

    Thanks
    Charles

    ReplyDelete
    Replies
    1. Thanks Charles.

      Remember you have to add the Reporting Point role to the SQL site system (not the Primary Site Server).

      Delete
  6. Have you heard or installed 2012 R2 with the Primary and CAS in a SQL Cluster getting reporting point working?

    ReplyDelete
    Replies
    1. I ALWAYS insist of local SQL to avoid this kind of problem.

      Delete
  7. software metering reports can't seem in sccm 2012 r2

    ReplyDelete
  8. Hi Gerry,
    Whn i enable the reporting point, the instance is blank. i installed SRS, configured it and still the same prbm. any help is appreciated.

    ReplyDelete
    Replies
    1. You haven't given enough information Surya. Is this local or remote SQL? Is your installation account local administrator of the SQL server and sysadmin role in SQL?

      Delete
  9. Hi Gerry,
    Thanks for the response. Its a remote SQL. Yes, the install account is a sys admin in SQL and is a local admin of the SQL.

    ReplyDelete
  10. I am unable to enable the reporting point in my primary site server, however the same is possible when i try to create reporting point in sql server. Does this make sense?

    ReplyDelete
  11. Hi Gerry, Yes it is a remote SQL on a CLSUTER and the account is provided sysadmin role in SQL

    ReplyDelete
    Replies
    1. SSRS is not cluster aware. It must be configured as a scale-out solution. Have you done this? You can find good information about this here:

      https://social.technet.microsoft.com/Forums/en-US/4479e73e-8a19-4c7e-9418-b36770656b9b/sccm-2012-reporting-point-server-instance-blank

      Delete
    2. Also your problem could be that your virtual directories have not been created in IIS. Have a look

      http://myitforum.com/myitforumwp/2012/10/10/reporting-services-site-role-setup-instance-blankempty/

      Delete
  12. Hi Gerry,

    The issue is resolved. Missed the simplest of things. my SMS_executive service was in stopped state. Do not how or why it was stopped. However once that is started, all the reports are now in my console.
    Thanks for all your help.

    ReplyDelete