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 :

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 :

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.

I hope this help you

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

Christopher KEYAERT

opalis · SCOrchestrator

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

opalis · SCOrchestrator

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

opalis · SCOrchestrator

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

opalis · SCOrchestrator

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

opalis · SCOrchestrator