How to provide a Self Service Request to Stop your SCOM Maintenance Mode in au2mator Self Service Portal.

So your Business Service Owners can easily maintain their Distributed Applications in SCOM.

au2mator Self Service Portal is providing a front-end for your Microsoft Automation.

System Center Orchestrator, SMA, Azure Automation and PowerShell Scripts can be used to be triggered by an au2mator Service.

In this video we will show you, how au2mator – Self Service Portal is providing the SCOM Information’s like a list of Distributed Applications.  So your Business Service Owner, or IT Staff can easily start and stop a Maintenance Mode, without using the SCOM Console.

So you can provide easy access to your SCOM System, without any security Risk and  the possibility of a human error.

And by providing a Self Service with au2mator, you decrease the load in your IT Department, increase the Quality by Automation.

Also the User of the Self Service will be much more satisfied, cause they receive an immediate response and solution of their request.

How to build with System Center Orchestrator

Detailed Description not available at the moment

How to build with PowerShell

Preperation

Please navigate and Download the PowerShell Script for au2mator Self Service Portal and save to your PowerShell Script Location.

Open the File and adjust the Variables to your needs and Environment

  • TechNet Gallery: na

Run the following SQL Query against your SCOM Database to create a Custom View named “zView_au2mator_DAList“

CREATE VIEW [dbo].[zView_au2mator_DAList]
AS
SELECT        TOP (100) PERCENT bme.DisplayName AS Name, CASE WHEN IsInMaintenanceMode = 1 THEN 'Yes' WHEN IsInMaintenanceMode <> 1 THEN 'No' ELSE 'No' END AS InMaintenance
FROM            dbo.State AS s INNER JOIN
                         dbo.BaseManagedEntity AS bme LEFT OUTER JOIN
                         dbo.MaintenanceMode AS MM ON bme.BaseManagedEntityId = MM.BaseManagedEntityId ON s.BaseManagedEntityId = bme.BaseManagedEntityId
WHERE        (s.MonitorId IN
                             (SELECT        MonitorId
                               FROM            dbo.Monitor
                               WHERE        (MonitorName = 'System.Health.EntityState')))  AND (bme.FullName LIKE 'Service_%')
ORDER BY Name
Go

Build au2mator Service

Login as admin to au2mator Self Service Portal

Navigate to Services and click New to create a new Service

Enter Name, Description, select a Service Group and choose a nice Image

Navigate to Runbooks and Select your PowerShell File, which you have downloaded and adopted.

Next navigate to Question and configure each Question

Question: c_SCOMDA

Question: Select DA

Required: true

Order: 1

SQL Server: *SQL Server with your SCOM DB*

SQL Port: *SQL Port with your SCOM DB*

SQL Database: OperationsManager *change if you chossed a different name*

SQL Query: select * from zView_au2mator_DAList where InMaintenance = ‘Yes’

Type: SQL Query

Authentication: *depends on your environment*

Question: c_Comment

Question: Comment

Required: false

Order: 2

Type: Text

Feel free to configure other Question or Service Options, click Save to finish the work

Customization

Our Scripts on TechNet Gallery, GitHub or on this Blog are provided as is, without any Support.

If you need help to customize this Service or create custom Worklfows, we would love to help you.

See our Premier Services for more Details: https://au2mator.com/premier-services/