Report Email in SCCM 2007

Author Message
csharma180

  • Total Posts : 366
  • Scores: -6
  • Reward points : 23820
  • Joined: 12/29/2008
  • Status: offline
Report Email in SCCM 2007 Friday, February 17, 2012 1:38 PM (permalink)
0
Hello All,
One of the user requested SCCM techs, to create a report in SCCM and same should be delivered to one specific team at regular interval.
Kindly confirm whether Report emailing feature is available in SCCM 2007 or not
 
#1
    npherson

    • Total Posts : 272
    • Scores: 48
    • Reward points : 44720
    • Joined: 8/19/2009
    • Location: Saint Paul, Minnesota
    • Status: offline
    Re:Report Email in SCCM 2007 Friday, February 17, 2012 1:44 PM (permalink)
    0
    This can quickly be accomplished if you use SQL Server Reporting Services (SSRS).  Open the desired report and click the "New Subscription" button.   This will let you set a schedule for emailing the report.
     
    If you aren't using SSRS, you would have to script something to export the report and send the email.  I'd suggest spending that energy on getting SSRS installed instead.
     
    I hope that helps,
     
     
    Nash
     
    <message edited by npherson on Friday, February 17, 2012 1:45 PM>
     
    #2
      csharma180

      • Total Posts : 366
      • Scores: -6
      • Reward points : 23820
      • Joined: 12/29/2008
      • Status: offline
      Re:Report Email in SCCM 2007 Friday, February 17, 2012 1:50 PM (permalink)
      1
      Hello,
      Thanks a lot for such a quick response.
      I haven't worked on SQL SRS. Is there a step by step article which describes how to configure query in SRS for email configuration
       
       
       
      #3
        npherson

        • Total Posts : 272
        • Scores: 48
        • Reward points : 44720
        • Joined: 8/19/2009
        • Location: Saint Paul, Minnesota
        • Status: offline
        Re:Report Email in SCCM 2007 Friday, February 17, 2012 2:08 PM (permalink)
        0
        If you are asking about how to install SSRS and get it set up with SCCM R2/R3, these articles should help:
        http://technet.microsoft.com/en-us/library/cc431393.aspx
        http://technet.microsoft.com/en-us/magazine/ee914611.aspx
         
        Once that is done, there isn't anything special you need to do "to configure query in SRS for email configuration".  Just open the report and click the "New Subscription" button.
         
        Cheers,
         

        Nash
         
        #4
          csharma180

          • Total Posts : 366
          • Scores: -6
          • Reward points : 23820
          • Joined: 12/29/2008
          • Status: offline
          Re:Report Email in SCCM 2007 Friday, February 17, 2012 2:09 PM (permalink)
          0
          i think following will suffice the purpose
           

           
          #5
            CAP

            • Total Posts : 91
            • Scores: -2
            • Reward points : 13780
            • Joined: 12/9/2011
            • Status: offline
            Re:Report Email in SCCM 2007 Friday, February 17, 2012 3:02 PM (permalink)
            0
            You could then easily export existing reports to the sccm srs
            Carl Polk
             
            #6
              csharma180

              • Total Posts : 366
              • Scores: -6
              • Reward points : 23820
              • Joined: 12/29/2008
              • Status: offline
              Re:Report Email in SCCM 2007 Monday, February 20, 2012 6:04 AM (permalink)
              0
              I got the following error message while trying to copy report to SRSS
               
              "A Network Related or Instance Specific Error occured while establishing a connection to the SQL Server. The Server was not Found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. "
               
              Please advise
               
               
              #7
                skissinger

                • Total Posts : 4645
                • Scores: 448
                • Reward points : 75260
                • Joined: 9/13/2001
                • Location: Sherry Kissinger
                • Status: offline
                Re:Report Email in SCCM 2007 Monday, February 20, 2012 8:40 AM (permalink)
                0
                Have you already completed the links provided by Nash on how to setup and configuration SSRS?  You are sure you've verified everything?
                mofmaster@myitforum.com
                My Blog
                Microsoft MVP - ConfigMgr
                 
                #8
                  Online Bookmarks Sharing: Share/Bookmark

                  Jump to:

                  Current active users

                  There are 0 members and 1 guests.

                  Icon Legend and Permission

                  • New Messages
                  • No New Messages
                  • Hot Topic w/ New Messages
                  • Hot Topic w/o New Messages
                  • Locked w/ New Messages
                  • Locked w/o New Messages
                  • Read Message
                  • Post New Thread
                  • Reply to message
                  • Post New Poll
                  • Submit Vote
                  • Post reward post
                  • Delete my own posts
                  • Delete my own threads
                  • Rate post

                  2000-2012 ASPPlayground.NET Forum Version 3.9