How to rebuild your Analysis database

At a Customer, there was an issue where the SSAS cubes suddenly stopped working and in the event log, on the DW Management server,  there were many ID 33522 events: Unhandled exception in data warehouse maintenance: Work item: 155150404 Maintenance action: ManageCubePartitions Exception details:  Exception message: File system error: The following file is corrupted: Physical…


Extract files from SCSM WI and upload to SharePoint Online

As part of authorizing access to a system, the initial request document had to be extracted from a SR and uploaded to SharePoint Online. By uploading to SharePoint, the customer kept track of all changes made to the request document and also had a long term storage of all requests. I ended up creating a…


Change the Data Warehouse retention period

A customer of mine wanted the Data Warehouse retention changed from the 3 to 5 years, for reporting purposes. To see the current retention settings of the DW databases, you can use the cmdlet that comes with SCSM. Get-SCDWRetentionPeriod NOTE: if not using the correct syntax, it returns the setting of the DWRepository DB and…


Watch demoes of Cased Dimensions suite of solutions

Cased Dimensions are one of the Companies in the market, that creates valuable add-ons for Service Manager. Recently they published a series of videos, that demonstrates their different solutions capabilities. I would recommend you to have a look at one or more of these videos, to learn what they have to offer: http://www.caseddimensions.com/scsm_self_service_portal/ http://www.caseddimensions.com/scsm_workflow_optimizer/ http://www.caseddimensions.com/scsm_assigned_to_me/ http://www.caseddimensions.com/scsm_sla_management/ http://www.caseddimensions.com/scsm_list_to_assignee/…

0

Support and roadmap for CSPP, IT GRC, and AAW

I've written a blog post about the future support and roadmap for the CSPP, GRC and AAW, as there a some confusion and questions around these. Read the blog post on Service Manager blog: http://blogs.technet.com/b/servicemanager/archive/2014/05/08/support-and-roadmap-for-cspp-it-grc-and-aaw.aspx


Send a mail and cancel remaining activities when a RA is rejected.

A common challenge with SCSM is that a rejected Review Activity leaves all remaining activities on pending state and out of the box its rather difficult to send a mail to the requesting user, with a comment on why the request was rejected. For that reason I have created a couple of runbooks to help…


Problem installing the SCSM Authoring console

When you want to install the SCSM Authoring console you might run into the same problem that I did, around the prerequisites checker, stating the Microsoft Visual Studio Shell is not installed:   Despite downloading the shell from the link and installing it, the error remained. I then tried to edit the Authoring_PrerequisiteInputFile.xml and took…


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…