Our management packs for Microsoft SCOM use numerus rules based on SNMP traps. For instance, in the management pack for APC UPS monitoring has more than 100 rules.

One our potential customer has asked us about a report with SLA details including durations for Manual Activities in SCSM 2012 like the ones we built for Incidents and Service Requests. The customer employed SLO for Manual Activities and wanted to get a clear picture for each SLO instance.

One of our popular free tool is SCUtils DWMPcreator that lets you generate sealed management packs for the Service Manager 2012 Data Warehouse within seconds. It can be used for classes and relationships and supports adding custom outriggers. However, you cannot create a management pack just for outriggers using DWMPcreator.

Usually, an outrigger management pack could be easily created manually but if you do it infrequently, it might be a time-consuming task. Yesterday I decided to build a simple PowerShell script that would automate this process. Surprisingly, the script happened to be quite long and not as short as expected.

Last year I published a blog post about using SCUtils FileAttachment to send notifications to reviewers with links to the documents attached to the Review Activities in Microsoft System Center 2012 Service Manager. The solution lets reviewers download the attached files from the SCSM self-service portal based on SharePoint platform.

A bit while ago, Microsoft released a new HTML5 self-service portal and I decided to revise all previously published solutions to support seamlessly both types of the portal. I created a small add-on that keeps the portal URL and it’s required to make this solution works.

I’ve got a request from our customer who asked for a help with a SCSM console’s customization. He complained that IT analysts in Incident classification category sometimes set values that had sublevels. Most of time it happened by mistake but in the reports it caused ambiguity and miscounts.

Last week we’ve got a request from our customer in Latin America who wanted to notify an affected user with an attachment link when the attachment is added to Incidents. There’s a solution published on TechNet Service Manager blog that can be used to create a notification workflow. However, using this approach you can send a message with all attachments instead of last one.

When we just released SCUtils FileAttachmentHTML5, one my colleague told me that now we had very similar solutions for SharePoint and HTML5 self-service portals and all ‘file attachment’-related solutions published on this blog required additional steps to implement. It happened because a self-service portal URL address is hardcoded and anyone eager to apply the solutions had to change and rebuild C# code to make it working. That was true and, despite the fact that I had planned to teach you some SCSM coding, many customers preferred a plug’n’play approach. He advised me to create a settings form to keep the self-service portals address for all our future and past solutions.

Exploring the HTML5 System Center 2012 R2 Service Manager Self-Service Portal updated in January 2016 I’ve noticed one curious thing about the knowledge article’s ratings.

In the version 1.2 of SCUtils SLAInstanceDuration we have presented a new feature – a calculated “Active Duration”.

One of our customers requested a tool to get any SCSM entity by Guid. I didn’t know such a tool and decided to make that one.

After my blog post about adding Related Items tab to Manual Activity form in Microsoft System Center 2012 Service Manager, we have found out that some people just need the same ready-to-go solution for Review Activity.

Engaging data from deleted relationships can be very useful in some cases. For instance, to be aware if someone deletes affected users in the closed cases or replaces attachments etc.

In our recent project, I’ve got a request to let custom reports to support multiple values in parameters. It seemed to be a little effort but I spent many hours to make it works.

Many recommendations advice to join the parameter’s multiple values in one using a function JOIN in SQL Reporting Services:

=Join(Parameters!YourParameter.Value,',')

Then using Transact-SQL IN statement check if the variable of the SQL query is among the selected values.

Unfortunately, 'as is' it didn’t work for me.

We periodically receive requests about the SCUtils Email Connector’s connection settings for popular messaging platforms. I’ve decided to post about the connection settings used for those email systems.

First of all, I have to mention that the connection settings of the on-premise systems could be changed on the server side. So it’s a good idea to check the settings with your email administrator.

Before you begin, please make sure that IMAP or POP protocol is enabled for the email account you try to connect.

Recently I’ve received an email from our customer who asked for a script to get the status of OLAP cubes and their measure groups without using the SCSM 2012 console or SQL Management Studio. We had some pre-built scripts to work with Microsoft SQL OLAP so the task was accomplished quite easy and fast.