Answered AD Group changes into a report

  • Wednesday, February 06, 2013 6:51 AM
     
     

    Hi all

    I'm using SCOM 2012 and are getting email alerts for all the group changes in AD. I wanted to know if it is possible for SCOM to rather create a report and I just look at the pdf, csv or whatever reports it can create. It is quite time consuming to scan through couple of hundreds of emails. is this possible? If so, how do I do that?

    Thanks in advance

All Replies

  • Wednesday, February 06, 2013 8:42 AM
     
     

    Hello,

    Yes you can do that. First you need to create a group and add all the AD servers to this group.

    Then go to Reporting-->Microsoft generic Report Library--> Alerts---> Add A Group (add the group you just created). This will show you all the alerts coming from that group. Now click on the alert for the group changes for which you want to see all the details. This will open up an alert detail report showing the Group changes alert only.

    Hope this helps!

    Regards, 


    Abdul Karim. (http://sites.google.com/site/scomblogs Twitter:@Abdul_SCOM)

  • Wednesday, February 06, 2013 10:19 AM
     
     

    Helo Abdul

    Sorry I forgot to say I did create a Rule in SCOM checking the Event ID's and that is how I get the email notifications. Does your answer still apply?

  • Wednesday, February 06, 2013 10:22 AM
     
     

    Yes, it does (however i create monitors instead) and I have done this pretty much for all the clients where I have implemented SCOM.

    Give it a go, hopefully it should work for you.

    let me know if you have any problems!

    Regards,


    Abdul Karim. (http://sites.google.com/site/scomblogs Twitter:@Abdul_SCOM)

  • Wednesday, February 06, 2013 10:22 AM
     
     
    and where do i see the Report Tab you are reffering to?
  • Wednesday, February 06, 2013 10:24 AM
     
     
    Havent you installed the Reporting Component ? It is under the Authoring Tab.

    Abdul Karim. (http://sites.google.com/site/scomblogs Twitter:@Abdul_SCOM)

  • Wednesday, February 06, 2013 10:36 AM
     
     
    Do not see anything. Will go and check my setup
  • Wednesday, February 06, 2013 10:48 AM
     
     

    Make sure you have reporting installed.

    Let me know if you have any problems.

    Regards,


    Abdul Karim. (http://sites.google.com/site/scomblogs Twitter:@Abdul_SCOM)

  • Wednesday, February 06, 2013 11:24 AM
     
     
    I'm runing the SCOM setup on the SCOM Server but when i get to the screen where i need to select the SQL Server instance nothing is shown in the drop down list. I have a seperate SQL Server where the DB for SCOM is stored on. Any idea why nothing is shown in the SQL Server instance?
  • Wednesday, February 06, 2013 11:28 AM
     
     Answered

    Hello,

    Yes, that is because you have not installed the SQL Server Reporting Services (SSRS) on the SCOM server. If you have installed the SSRS Role on the SQL server, then try installing the SCOM Reporting Component there. I'd suggest you to install SSRS on the SCOM server and then run the SCOM Reporting Role.

    So first install the SSRS role from SQL. Once this is done, you need to configure the SQL Reporting Services Configuration Tool. After you have configured this you can then be able to install SCOM Reporting Server Role.

    Regards,


    Abdul Karim. (http://sites.google.com/site/scomblogs Twitter:@Abdul_SCOM)

  • Thursday, February 07, 2013 6:58 PM
     
     
    Would a default SQL installation also installed SSRS on the SQL Server? Can't I not just go ahead and install SSRS on the Scom server?
  • Thursday, February 07, 2013 8:29 PM
     
     

    Hello,

    Yes you can install SSRS on the SCOM server. You dont need to install SQL DB Engine. Just the reporting services. If you have installed SSRS on the SCOM DB Server, then try running the SCOM set up there and install the SCOM reporting component.

    Regards,


    Abdul Karim. (http://sites.google.com/site/scomblogs Twitter:@Abdul_SCOM)

  • Friday, February 08, 2013 5:12 AM
     
     
    How would i know if SSRS installed on the SQL Server as i just run the normal setup to have SQL installed
  • Friday, February 08, 2013 7:52 AM
     
     Answered

    One of the easy way for checking whether SSRS is installed and function

    1) log in SQL server and checking whether SQL Server Reporting service is up and running from the services MMC

    2) check whether you can open the following URL in the SQL server which SSRS is installed

    http://localhost/Reportserver

    Roger