Category: SCSM

Traditionally getting the most out of reporting in Service Manager (SCSM) can be challenging. Gaining the visibility and information out of the reports, can be time consuming and difficult, using SQL reports or excel pivot tables to get the information required. At PowerON we’ve been working hard to make reporting more accessible and take the […]

Had a customer raise an interesting issue with the DWStagingAndConfig Service Manager Data Warehouse DB munching its disk space for breakfast. Problem The disk that held the DWStagingAndConfig DB logs was full. Cause The database was being backed up by DPM but it didn’t seem to be truncating the backup when complete. Because of the […]

This script is for running a re-synchronisation of the Orchestrator runbooks in System Center Service Manager (SCSM). The SCORCH connector in SCSM syncs all the runbooks through from SCORCH. Sometimes even after running a sync, a new runbook will not appear. Using the Truncate AuthorizationCache in SQL can resolve this but not always. The script […]

With System Center Service Manager (SCSM), you can produce custom reports via SQL Server Reporting Services (SSRS) server through data warehouse cubes. The collected data is made available via the cubes for use in Excel pivot tables. The standard reports are also available through the console. With Microsoft’s preview release of Power Bi, I wanted to […]

It’s been a long time since I lasted posted anything on my blog and a lots changed since my first posts. There has been so much I’ve worked on but not had the chance to blog, this however was a must… I’ve recently been working with my colleague Robert Ryan on implementing Service Manager 2012 […]