System Center Service Manager–SQL Query to get a full List of your Incidents

In the most cases, the Reporting has to be done through the Data warehouse DB for SCSM, but in some cases you have to get all the Data from the ServiceManager DB. For Example if you don’t have a Data warehouse DB for SCSM or you need some more Details.

In this Case you have to query the Service Manager DB, and unfortunately, this DB is not as simple as the Data warehouse DB. So to get a complete list of your Incidents, including all your Status, Classifications, Affected Users, Assigned Users and everything else, it will cost some time to build this Query.

Also to get the correct Values for Status, Classification and so on, you have to make some joins, but see yourself.

Take this Query as a basis and changed it to fit your needs. Below is a Link to Download

(Read more…)

System Center 2019 is here

System Center

System Center

Yesterday Microsoft announced System Center 2019 is generally available.

System Center 2019 is a long term servicing channel (LTSC) release which will be supported for 10 years.

System Center 2019 supports Windows Server 2019 across the board and enables deployment, management and monitoring of Windows Server 2019 at data center scale. The key capabilities of this release include:

(Read more…)

Fix SCSM Console Issues

Some time it can happen, that your System Center Service Manager Console is not working like expected.
For example

  • Changes are not visualized in the Console
  • If you open an Element, the new Window is very small
  • Console won’t open
  • some other Problems

So, there are several ways to fix this Problems, please take a note, after some steps, it might be necessary to enter your SCSM Server Information once again, like on the fist startup.

Make sure, you close your Console before trying the next steps.

Clear Console Cache

that’s the easiest one, start your SCSM console with the /cache command, for example
„C:\Program Files\Microsoft System Center 2012 R2\Service Manager\Microsoft.EnterpriseManagement.ServiceManager.UI.Console.exe“ /cache

(Read more…)

System Center 2016 is here

 

We have been waiting a long time, Microsoft released the new System Center 2016 suite nearly a month ago.

A few days after, also Update Rollup 1 has been released.

As I am mainly related to SCDPM, SCSM and SCO, I will show you all the news around these three Products

So lets take a look, what’s new with System Center 2016.

Service Manager 2016

  • Time to create and update Work Item is reduced
  • Workflows are faster
  • Group and queue calculations improved
  • Faster SCCM and Active Directory Connector
  • Grooming improvements

    (Read more…)

SCSM 2012 R2 and SCCM 1511 supported?

Hi, a lot of people out there, including some of our customers, did an upgrade of SCCM to Version 1511 with an SCSM Connector in use. Than some errors has been reported in the community and MS told us that SCCM 1511 and SCSM 2012 R2 is not supported at this time.

No good News. The Event Log showing Errors with EventID 33333 and 34115 with Messages like “Data Access Layer rejected retry on SqlError:” and “Error writing relationship of type System.MobileDeviceHasOperatingSystem”

Microsoft told us first, they will support SCCM 1511 with SCSM 2016, no good new too.

But MS was surprising us today and announced they will support SCCM 1511 with SCSM 2012 R2 Update Rollup 10.

Additionally, MS told us that each new SCCM Version will be followed by a supported SCSM Version within 4 weeks.

Thanks MS for helping us with our customers.

Michael Seidl aka Techguy

Update Rollup 9 for System Center 2012 R2 released

Microsoft released the Update Rollup 9 for System Center 2012 R2.

Update Rollup 9 contains Fixes and Updates for SCDPM, SCOM, SCSM, SPF, SCVMM and Windows Azure Pack..

As we know, there is the possibility that the actual Update Rollup can contain some Bugs, so maybe wait a few days to install, or try it on a Test Environment.

Get all Information’s about Update Rollup 9 for System Center 2012 R2: https://support.microsoft.com/en-us/kb/3129757

Here are some Details

(Read more…)

SCSM Dashboard from Expit in Version 3.0 available

ExpitLogoI have written about the Expit Ensight last Year, now there is a new Version and new Features. Expit is providing Ensight 3.0 as a Dashboard for SCSM.

Dashboard and KPI are very important for Analysts, so Expit is providing a solution for that.

There is a free Community Edition which limits the functionality to Incidents and Problems. The paid Professional Edition has no limitation on Reporting and Dashboard functionality.

Whats New?

Expit done a lot about Performance, so the Console is much faster than the old one. Also in a Environemnt with a lot of Data, the Console is still fast.

(Read more…)

Installation and first look at the new SCSM HTML5 Portal

Hi, today the Update Rollup 8 and the new System Center Service Manager Portal has been released.

Microsoft released a new and fresh HTML5 Version, without the need of Silverlight or SharePoint.

In this Article I want to take a look at the Setup and the look and feel of the new SCSM Portal.

The Portal will show up in a modern UI, Announcements, Caching and some customizations.

Setup

Download the Setup and Management Pack from here: http://www.microsoft.com/en-us/download/details.aspx?id=49556

First, enable the IIS Role, if you are installing the Portal on a new Server.

The following Features need to be selected

  • ASP.Net 4.5
  • Basic Authentication
  • Windows Authentication
  • .Net Extensibility 4.5
  • HTTP Activation (.NET Framework 4.5 Feature)

(Read more…)

How to add a Category to SCSM Business Service Components

I recently faced the challenge to add custom Category Classes to System Center Service Manager Business Service Components.

I will skip the introduction on how to build custom classes with Visual Studio, cause Marcel did an awesome Job already here: http://marcelzehner.ch/2015/04/13/scsm-quickvids-for-scsm-20122012r2-authoring-video-4-create-a-custom-form-step-1/

I want to show how to create this classes, cause I think someone can also need this.

Preparation

As Marcel showed us in his Videos, we need the related Management Pack as a reference in our Visual Studio Solution.

But what Management Pack?

(Read more…)

Update Rollup 7 für System Center 2012 R2

Seit heute steht das Update Rollup 7 für die aktuelle System Center Familie bereit.

Update Rollup 7 für System Center 2012 R2 bringt viele Fixes für die Produkte SCDPM, SCOM, SCO, SCSM, SCVMM und Windows Azure Pack.

Bitte das Update zuvor in einer Testumgebung installieren, da wir aus der Vergangenheit ja wissen, das solche Update Rollups auch mal Probleme verursachen können.

Am besten auch mal ein paar Tage mit der Installation warten, sollte es Probleme geben, werden diese in den ersten Tagen nach Veröffentlichung ja bekannt gegeben.

Hier die Lister de betroffenen Produkte und der Download zum Update:

(Read more…)