Book on Optimizing Service Manager

Today my first book has been released The book is titled Optimizing Service Manager and is written by Kathleen Wilson, John Clark, Karsten Nielsen and my self. There are several ways to the get the book: Download the book as PDF from Microsoft Download – here Get the Kindle Edition – here Buy the paperback…


Service Manager 2012 R2– Fixes included

With the release of Service Manager 2012 R2, the list below contains the known bugs that are fixed. Also note that some of the fixes addressed in the R2 release are also fixed in the SCSM2012 SP1 UR4 release.(http://blogs.technet.com/b/servicemanager/archive/2013/09/24/service-manager-sp1-ur4-fixes.aspx) Description SM setup does not allow change from evaluation to licensed SMDW: "Invalid object name <table>"…


How to force the SCSM console to download a new configuration

One of my customers had run into a strange problem. They had created some new Incident templates and allowed a specific User Role to see the new templates. It then turned out that only a few people in the User Role could see the new templates. But if a user logged onto another PC it worked…


Error when accesing the Analysis folder in the SCSM Console

After making changes to the user roles, some of the users started to complain about an error when accessing the Analysis Library folder in the Reporting wunderbar.   The first part of the error is  cryptic as: Application: Service Manager Console Application Version: 7.5.1561.0 Severity: Error Message: Failed to retrieve the default task for the…


Date dimensions for Incidents, Service Requests, Change Requests and Activities.

I’ve had this blog on my todo list for quite a while and finally I found some time to actually write it. My colleague Atchut Barli created an MP last year that extended the Data Warehouse Work Item cube with a date dimension for when incidents were created. This made some reports a lot more useable. http://blogs.technet.com/b/servicemanager/archive/2013/02/20/3539405.aspx Together…


How to get the Service Manager 2012 Self-service portal running on Sharepoint 2013

This blog post is written by my collegaue Nicklas Halme from Microsoft Consulting Services in Finland. Great Work Nicklas    NOTE! The following steps are not a supported method and should ONLY be used for lab / testing purposes!!! ************** I ran into a situation that my customer wanted to use only Windows Server 2012…


Service Request Activities, added without prefix

When using the Exchange Connector and users reply to the mail, including the [SRxxxxx], if not configured correctly, the connector will create new activities, even despite the SR being completed. If the Exchange connector is set to use the Default Service Request when updating Service Requests, these two new activities will be added every time…


Cancel pending activities in a failed Service Request

Travis Wright has a couple of years ago, written a blog on how to cancel pending activities in a failed Change Request: http://blogs.technet.com/b/servicemanager/archive/2011/05/03/cancelling-pending-activities-when-a-change-request-fails.aspx I often get the request to make a similar solution for Service Requests and thought it was about time to document it.  Open the Authoring console and create a new Management Pack….


Data Warehouse problems after upgrading to SP1

Recently I discovered that an otherwise working SCSM installation had begun to fail the MP synchronization after upgrading to SP1.   The following error was logged in the event log: Event ID: 33333 Description: Data Access Layer rejected retry on SqlError:Request: Ral_ExecuteSql — (statement=exec(‘IF OBJECT_ID(”[dbo].[WorkItemAffectedUserFact_2013_Jan]”) IS NULL BEGIN   CREATE TABLE [dbo].[WorkItemAffectedUserFact_2…), (RETURN_VALUE=0)  Class: 16…


Failed to Apply UR2 to SCSM 2012 SP1 – Performance Counters not found

I’ve been updating a couple of SCSM2012 SP1 installations to UR2 and everytime time I run into the same problem – the installation fails. The installations fails with:  error occured while executing custom action: “_Installhealthserviceperfcountersforpatching” Looking at the SCSM2012_CU_KB2802159_AMD64_7.5.2905.125.msp.0.log I can see the following errors: InstallCounters: LoadPerfCounterTextStrings() failed . Error Code: 0x80070002. momv3 “D:\Microsoft System Center…