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/…


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…