jump to navigation

Would you like to be able to schedule reports in SCE? August 13, 2008

Posted by Björn Axéll in How-To, SCE.
1 comment so far

Have you ever wanted to get a report sent by mail or saved to a file share on a schedule basis? In System Center Operations Manager, you have this function directly in the System Center Operations Manager Console but for System Center Essentials, this feature was not included (because the limitation in SQL Express that is included in Essentials 2007).

 

So – how can we fix this? Since Essentials use SQL 2005 Reporting engine, we can configure this from the Report Manager (Note that this will not work if you use SQL 2005 Express or SQL 2005 Workgroup since they don’t have this feature). The example below we will configure so you get the Update Deployment report in your inbox every morning. Note that this is just an example, you can schedule every report available in Essentials.

 

  1. First we need to verify that the Reporting server is configured to send report via mail.
  2. Start the Reporting Services Configuration from the start menu
    image
  3. At the Instance selection dialog box, click to connect to your local server
  4. Select the E-mail node and enter a e-mail address (this is the from address) and the name of your mail server, click apply and exit
    image 
  5. Open Internet Explorer and enter http://localhost/reports as address
  6. Reporting Manager will now start and you can see all available reports that are installed (number of reports will vary depending on what Management packs you have installed)
    image
  7. Click Microsoft.SystemCenter.Essentials.Report.Library and select the Microsoft.SystemCenter.Essentials.Report.UpdateDeployment report (the one without the rpdl extension)
    image
  8. When the report is shown, click on the subscription link and then New subscription
    image 
  9. In the Report Delivery option and Subscription Processing option add:
    Delivered by = E-mail (if e-mail is not available to select, you have missed the first 4 steps). Note! If you add a “external” e-mail address you need to make sure the reporting server are permitted to “relay” mail traffic.
    Render format = in this example we use Web Archive
    Select scheduling = Select the time and how often you want the report
    In the Report Parameter Values = Unselect default and select only the type of status you want to see (in my example I only select Not installed, Downloaded and failed).  You also need to specify a group of computers you want to run this report again’s (in my example I select All Servers)
    image 
  10. When you done your selections, click ok to save. You will receive the report in your inbox
  11. Below is an example of a report
    image

Updated Management Packs from Dell – Version 3.1, A01 August 8, 2008

Posted by Björn Axéll in MP, SCE, SCOM.
comments closed

Dell just released an updated version of there Management Pack for System Center Operations Manager 2007 and System Center Essentials 2007.

New feature in this release is:

Separate MP’s for:

  1. Dell Server and Printer
  2. Dell Clients (Optiplex, Precision and Latitude)
  3. Dell Storage Array

Update – Kevin Holman has written some important information about the Dell MP that you should read before installing it.

Keep up the good work Dell, I hope other hardware/software vendors do the same

 

Download the Dell Management Pack v3.1, A01 from Dell

Opsmgr and SCE is now fully supported on Windows Server 2008 August 8, 2008

Posted by Björn Axéll in KB, SCE, SCOM.
comments closed

Last week Microsoft released the update 954049 that adds support to run/install System Center Operations Manager 2007 and System Center Essentials 2007 components on a Windows Server 2008 system.

More information about this update

Download the 954049 update from Microsoft