Tag: OpsMgr

Version 2.1 of My Script to Download All SCOM Management Packs with PowerShell

Little improvements were made to this script. All of them were contributed by Anthony Bailey:

  • The script now checks if the folder for the version already exists and if only there is not such folder than downloads the MP;
  • When MP is downloaded successfully it is written in a log file;

With these improvements you can run the script with schedule task and configure SCOM to monitor the log that way you can get alerted when new MP is available. All thanks to Anthony Bailey.

Latest version you can find on TechNet Gallery or systemcentercentral.com.

New MP: System Center Management Pack for Windows Server 2012 DHCP

Microsoft released another new MP as they promised. You can grab the new Windows Server DHCP 2012 MP from here. This MP introduces the following new features:

  • All workflows are implemented using PowerShell to improve overall functionality for this Management Pack.
  • Failover Relationships are now a supported configuration that is being discovered and monitored by the new 2012 Management Pack.
  • Discovery and Monitoring of a DHCP Cluster installation.
  • Scopes, super scopes utilization is being monitored based on events that provide 80% and 100% usage.
  • Utilization of scopes based on policies, client packet drop and residual IP addresses range monitoring.

The MP has very good documentation so read it before importing.

Installing and Importing Microsoft Exchange Server 2013 Management Pack 15.00.0620.030

After yesterday’s release of Exchange Server 2013 Management Pack I’ve managed to install it in a development environment. Here are the steps I’ve went trough:

1. Start installation and Accept License Agreement:

image

2. Choose installation location:

image

3. Import the installed MP into SCOM:

image

image

image

4. After the successful import you will start see you exchange servers appear in the default views:

image

image

5. After 5-10 minutes you will see all services appear as monitored:

image

image

image

So these are the steps. Pretty easy and simple. There are no special requirements or configurations. The MP uses the default action account for the monitoring and discovery.

Here are some of the bad news about this MP:

  • I’ve received an error a couple of hours after the deployment. The error wasn’t very descriptive. It had only the error description and a link (to Technet Library) that you can visit to find more information. I couldn’t opened the link  as the page still does not exists. I guess Microsoft still hasn’t uploaded all information about the MP in TechNet.
  • The MP does not collect performance data for Exchange 2013.
  • The MP does not contain any reports.

Here is what I’ve used in the environment:

  • SCOM 2012 SP1 UR2;
  • Microsoft Exchange Server 2013 Management Pack 15.00.0620.030;
  • Windows Server 2012 with latest updates;
  • Exchange 2013 CU1 in multitenant mode;

SQL Databases Properties are not Discovered by SQL Server Management Pack

I had this issue recently in two separate environments where properties for some SQL databases were not discovered by SQL Server Management Pack as you can see below:

image

Also collecting performance data for free space of the databases was returning zero (0):

image

Meanwhile in the Operations Manager log on the SQL servers I was only seeing this error:

image

Management Group: <MGMTGROUPNAME>.Script: DiscoverSQL2012FileGroups.js : Script ‘DiscoverSQL2012FileGroups.js’ failed.
Inner exception:
Error Number      :
Error Code        : 0
Win32 Facility    : 0
Error Description :
Call stack:Exception.constructor(Script ‘DiscoverSQL2012FileGroups.js’ failed.,Can’t close connection.
Inner exception:
Error Number      : -2146824584
Error Code        : 3704
Win32 Facility    : 10
Error Description : Operation is not allowed when the object is closed.
Call stack:Exception.constructor(Can’t close connection.,Operation is not allowed when the object is closed.
Error Number      : -2146824584
Error Code        : 3704
Win32 Facility    : 10
Error Description : Operation is not allowed when the object is closed.
), ADODB.Close),
Main({D6B26EFE-E183-24E9-DD23-F165CB716A28},{ADFFD930-BDE9-66A1-20F3-CB6FBA80CBC9},<SERVER FQDN>,<SERVER NETBIOS NAME>,MSSQLSERVER),
),
Main({D6B26EFE-E183-24E9-DD23-F165CB716A28},{ADFFD930-BDE9-66A1-20F3-CB6FBA80CBC9},<SERVER FQDN>,<SERVER NETBIOS NAME>,MSSQLSERVER),

So this was my issue but I couldn’t find where exactly was the problem. Some of the properties were discovered and there was even databases that all properties were discovered but performance data for free space was not working on all databases. This lead me think it was some kind of permissions issue but I’ve made the SCOM Action Account “SA” on all SQL servers.

How I fixed it:

1. I’ve created Run As account in SCOM.

2. Named it SQL with type Windows.

3. For credentials I’ve entered the SCOM Action Account.

4. Secured the account only to the SQL servers in my environment.

5. Added this account to these three profiles: SQL Server Default Action Account, SQL Server Discovery Account and SQL Server Monitoring Account.

After these steps all was working as it should be:

image

image

So it seems you really need to create Run As account and add it to the SQL Profiles even though the SQL Server Management Pack guide says otherwise:

By default, all discoveries, monitors, and tasks defined in the SQL Server management packs default to using the accounts defined in the “Default Action Account” Run As profile. If the default action account for a given system does not have the necessary permissions to discover or monitor the instance of SQL Server, then those systems can be bound to more specific credentials in the SQL Server Run As profiles, which do have access.

 

Keep in mind that I haven’t changed any permissions to my SCOM Action Account. This account had all SQL permissions all the time.

My Configuration was:

  • Windows Server 2012 with latest updates;
  • SCOM 2012 SP1 UR2
  • SQL Server Management Pack 6.3.173.1
  • SQL Server 2012 SP1 CU3

New MP: Microsoft Exchange Server 2013 Management Pack

Exchange 2012 Management Pack was just released by Microsoft. It seems that this is completely new management pack so goodbye to the correlation engine Smile. I’ve never liked that this management pack was some kind of different from all other Microsoft Management Packs. I hope I can test it really soon. You can test it by yourself by downloading it from here. You will not be able to download the guide for this MP as it is located in TechNet Library so here are the links: