You are browsing the archive for Opalis.

Orchestrator 2012 : Statistics not updated in Web Console

9:34 am in Uncategorized by Christopher Keyaert

Hello All,

You may be already experimented this issue with System Center Orchestrator 2012 RC, the statistics available in the web console are never updated and always stay at zero. The two print screens below represent the problem that I had in my lab environment :

clip_image002

clip_image002[5]

This problem is due to a SQL Store procedure that doesn’t start and doesn’t update the statistics in the web console.

To solve that, the very first step is to ensure that the SQL Broker in enable on your SQL Server. Go to you SQL Server and run the following Query :

select is_broker_enabled from sys.databases where name= ‘Orchestrator’

If it is not (you get a return value of 0) then you need to enable it by doing the following:

alter database Orchestrator set enable_broker WITH ROLLBACK IMMEDIATE

Now, we’ll check the last execution time of the procedure that is taking care of the statistic update. Execute the follow query :

SELECT
      [m].[Name],
      [m].[IsEnabled],
      [m].[IntervalInSeconds],
      [m].[LastExecutionTime]
FROM [Orchestrator].[Microsoft.SystemCenter.Orchestrator.Maintenance].[MaintenanceTasks] [m]

This will return the following table :
clip_image002[7]

We could see that the LastExcutionTime of the Statistics store procedure is MARCH 15, or this normally procedure has to run every 10 minutes (600 seconds). It’s clear that something is going wrong there.

To start manually this procedure, we have to run the follow query :

EXEC [Microsoft.SystemCenter.Orchestrator.Maintenance].[EnqueueRecurrentTask] @taskName = ‘Statistics’

After a few seconds, we must find some data in the following table :

SELECT *
FROM [Orchestrator].[Microsoft.SystemCenter.Orchestrator.Statistics.Internal].[Statistics]
 

Running manually the procedure must solve the issue in the majority of the case, but if you still have any statistic  data after running all the SQL queries above, it’s certainly due to your SQL Server that is not working properly.

In fact, it was my case, still no updated statistics. if like me, you are running  your lab SQL server in  a VM on your laptop, VM that you never shutdown /reboot, but always use the PAUSE feature. This could cause some problem with the SQL Store procedures.

How to solve that ? Simply reboot your SQL Server. After the reboot, my statistic updated automatically.

clip_image001

I hope this help you Winking smile

Thanks to Travis Wright and Chris Sanders for their help on this topic.

Christopher KEYAERT

clip_image001 clip_image002 clip_image004 clip_image005 clip_image007 clip_image008

Orchestrator 2012: how to build your first runbook – Session recording available

8:43 am in Uncategorized by Christopher Keyaert

Hello all,

The recording of my last week session about “Orchestrator 2012 – How to build your first runbook” is available on TechNet Edge :http://technet.microsoft.com/en-us/edge/hh916316

The slide deck is available on Slide Share :

You could also download the Runbooks that I created during the session : DOWNLOAD

Cheers
Christopher

clip_image001 clip_image002 clip_image004 clip_image005 clip_image007 clip_image008

BMC Products Integration Packs for Orchestrator 2012

8:34 am in Uncategorized by Christopher Keyaert

Dear All,

Kelverion company closely worked with Microsoft for releasing a new set of Orchestrator 2012 Integration packs for the following BMC Products:

  • BMC Bladelogic v8.1, 8.2
  • BMC Remedy ARS v7.5, 7.6
  • BMC Enterprise Event Manager (BEM) v7.4
  • BMC Atrium CMDB v7.6.04

The license is free of charge for the current BMC IPs on completion of an end user license form, detailing the number of Orchestrator databases and which BMC products are to be licensed.

The licensing of the Integration Packs is per Orchestrator database i.e. so normally a customer would have at least one license for production and one for development as a minimum.

These free IPs are supplied without warranty or support and you could download it here: http://www.kelverion.com/bmc-download

Downloads are supplied with a 14 day evaluation license but you simply have to send an email to info@kelverion.com to obtain permanent license keys.

More details about the activities available below :

Integration Pack for BMC Atrium CMDB

Supported Versions

  • BMC Atrium CMDB 7.6.04 is supported. Future compatibility is dependent on BMC Atrium Core Web Services.  Prior versions to 7.6.04 are not supported.

Activities

The Integration Pack supports the following activities for both CIs and relationships:

  • Create Instance
  • Delete Instance
  • Get Instance
  • Monitor Instance
  • Update Instance
  • Start Reconciliation Engine Job

Integration Pack for BMC Enterprise Event Manager (BEM)

Supported Versions

Starting with BMC Enterprise Event Manager 7.4 with Impact Integration Web Server 7.4 (developed with 7.4.01).  Future compatibility is dependent on changes to Impact Integration Web Server.

BEM Activities:

  • Create Event
  • Update Event
  • Set Event Status
  • Get Event
  • Monitor Events

Integration Pack for BMC Remedy AR System

Supported versions:

Starting with BMC Remdey AR System 7.5 and 7.6. (developed with Remedy 7.5). Future compatibility is dependent on Remedy Web Service. Version 7.1 or below is not supported.

Activities:

The Integration Pack supports the following activities:

  • Create Request
  • Update Request
  • Get Request
  • Monitor Request

Integration Pack for BMC BladeLogic

Supported versions:

Starting with BMC BladeLogic Server Automation 8.1

BladeLogic Activities:

  • Create BLPackage from Audit
  • Create Deploy Job (BLPackage Deploy Job or Software Deploy Job)
  • Run Job  (Audit Job, ACL Push Job, Batch Job, BLPackage Job, Compliance Job, Component Discover Job, File Deploy Job, Software Deploy Job, NSH Script Job, Snapshot Job, Virtual Infrastructure Discovery Job)
  • Export Audit Results
  • Set Server Property
  • Run BLCLI Command

More information on this website : http://www.kelverion.com/

Cheers
Christopher

clip_image001 clip_image002 clip_image004 clip_image005 clip_image007 clip_image008

Live Meeting : SC Orchestrator – How to build your first runbook

10:08 am in Uncategorized by Christopher Keyaert

Hello everyone,

You just installed System Center Orchestrator, Great, but what’s next?

On Tuesday, March 20, 2012 2:00 PM (GMT+01:00), I will do a live meeting to present the System Center Orchestrator basics for runbook creation. We will speak about bests practices, how to use out of the box activities, configuring Orchestrator Integration Packs, runbook creation and a lot more.

We will show you how to build your first System Center Orchestrator runbook from scratch.

This is a live meeting and it’s free, to register follow this link : https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032506833&Culture=en-US

Regards
Christopher Keyaert

clip_image001 clip_image002 clip_image004 clip_image005 clip_image007 clip_image008

System Center Orchestrator 2012 : notes from the field – Sessions Online

6:59 am in Uncategorized by Christopher Keyaert

Hi Guys,

Last week, with my friend Kurt Van Hoecke (SCSM Expert), we delivered two sessions at Microsoft Belgium on System Center Orchestrator 2012. These sessions have been recorded and are now available online on Technet.

System Center Orchestrator 2012: An Overview by Kurt Van Hoecke.
http://technet.microsoft.com/en-us/edge/video/system-center-orchestrator-2012-an-overview

System Center Orchestrator 2012: Migration Plan by Christopher Keyaert.
http://technet.microsoft.com/en-us/edge/video/system-center-orchestrator-2012-migration-plan

Microsoft System Center Orchestrator 2012 Resources :
Microsoft System Center Orchestrator 2012 beta is available as public beta at the Microsoft Download Center : http://www.microsoft.com/download/en/details.aspx?id=26503

Microsoft System Center Orchestrator 2012 Team Blog : http://blogs.technet.com/b/scorch/

TechNet Forums for System Center Cross Platform and Interoperability :http://social.technet.microsoft.com/Forums/en-US/category/scinterop

Cheers
Christopher KEYAERT
http://twitter.com/keyaertc

System Center Opalis Integration Server 6.3 Unleashed book – Available

7:08 pm in Uncategorized by Christopher Keyaert

Hi everyone,

Just a little post for telling you that the System Center Opalis Integration Server 6.3 Unleashed book is now in stock at Amazon.

http://www.amazon.com/System-Center-Opalis-Integration-Unleashed/dp/0672335611/ref=sr_1_1?ie=UTF8&qid=1315594827&sr=8-1

I already received my copy, do you have yours ?

photo

Cheers
Christopher KEYAERT
http://twitter.com/keyaertc

TechNet Virtual Labs: System Center Opalis

6:37 pm in Uncategorized by Christopher Keyaert

Step into the System Center Virtual Labs for Free

It’s simple: no complex setup or installation is required to try out System Center running in the full-featured TechNet Virtual Lab. You get a downloadable manual and a 90-minute block of time for each module. You can sign up for additional 90-minute blocks any time.

Cheers
Christopher KEYAERT
http://twitter.com/keyaertc

System Center Opalis : Monitor SNMP Trap activity

2:25 pm in Uncategorized by Christopher Keyaert

Hi all,

Today, another case that I had at one of my customer. The idea is simple, He wanted to generate an incident (Could be in SCSM, BMC Remedy) based on a SNMP Trap sent by a monitoring application. (SolarWinds, Tivoli, …)

In the default integration pack, System Center Opalis has a Monitoring SNMP Trap activity :
image

In the details of this activity, we could filter the host/server from which we accept to receive SNMP Trap, the Port, Enterprise identifier, ….image

For publishing the data received from the SNMP Trap, we have to go in the Advanced part :image

We have to add the object identifier of each data that we want to publish. we have to manually publish an data output for each OID that we want to use.image

Once done, the Monitoring SNMP Trap activity will publish the data as Output-x variable that we could use in other Opalis activities.image

Now that we have configured the data from the SNMP Trap, we will publish them to the Send Platform Event activity.
image

In the Send Platform Event activity, select published data from the Monitor SNMP Trap activity :
image

The variables that we are interested in are Output – x – Value and we could use them in any of our activities. Here we will just display them, but we could imagine to use them for an incident creation :
image

Configuration is now finished, run the Runbook and send an SNMP Trap to the System Center Opalis server. When the trap will be received, the Runbook will start automatically :image

And the content of the Trap will be available in the Events :image

The output result :
image

We could now use information from SNMP Trap in any of our activities. Smile

Christopher KEYAERT

System Center Opalis : Query an Oracle DB

8:04 am in Uncategorized by Christopher Keyaert

Hi,

For one of my customer, I had to retrieve some information from an Oracle DB with System Center Opalis. The DB Query object included in Opalis supports MS SQL, Oracle, Odbc connection ….

clip_image001

For querying an Oracle DB with Opalis, there is some requirements, that I will explain step by step below :

1. Install the Oracle client on your Opalis server. Opalis requires the x86 release of the Oracle Client even if the Opalis server is in x64.

2. Oracle client is available at the following page : http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win32soft-098987.html

3. Download this version : Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (32-bit).

win32_11gR2_client.zip (684,581,290 bytes)

4. When downloaded, and uncompressed, just execute the setup.exe file.

clip_image003

5. During the installation process, select Runtime as installation type, and continue the next /next setup.

clip_image005

6. Once the setup finished, we need new to edit the tnsnames.ora configuration file.

7. Go to InstallationFolder\product\11.2.0\client_1\network\admin\ and edit the tnsnames.ora file.

8. ARSDVL is the name of the Oracle DB on which we want to connect, this name is used at two places in the file. line 4  as service name and also in the Connect_Data field. Host contqins is the name of the Oracle DB server.

clip_image006

9. Once the file edited and saved, for testing the connection, open a CMD prompt and type : 
SQLPLUS LOGIN@TNSNAME

clip_image008

10. If the SQL> prompt appears, we now than everything is ok and we could go back to our Opalis policy.

11. Here, a simple Opalis policy which will query the Oracle DB and return the result in an event.
clip_image009

12. Query Database object – Connection configuration : Add the name used in the tnsnames.ora file in the Service Name field, set the connection credentials.

clip_image010

13. Query Database object – Query : Here a simple Select query (Tips : Don’t add the ‘;’ at the end of the query or you will get an error message).

clip_image011

14. Send Platform Event – Configuration :

image

15. Run the policy.

clip_image012

16. Check the result Smile

clip_image013

Christopher KEYAERT