SCOM Self Service with au2mator – Stop Maintenance Mode

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/

2020-01-02T17:19:49+00:00January 2nd, 2020|Request, ShowCase, Uncategorized|0 Comments

Disable a User as au2mator Self Service Portal Service with SCO

Hi,

Here we will show, how to create a Disable a User Service for the au2mator Self Service Portal.

First, the Runbook, it is included in our public Download on TechNet Gallery, Download link is below.

Create the Service

For this Service, we will need the Runbook 04.06-Disable a User

So Navigate to the au2mator Self Service Portal and create a new Service.

We called it “Disable a User” with a nice Description and a Icon

 

Next we configure some Instructions at the “ADVANCED” Tab

 

Next, and of course the important step, chose your Runbook 04.03-Install Software and 04.99.01-Approval Runbook

Now navigate to “QUESTIONS” and configure the Questions.

For the Checkbox we choose the “Yes-No” Question type

For the Date we use Date Question Type, and provide a proper formatting, this is important, cause this will correspond to the Runbook.

Save the Service and let’s try it.

Start the Request a Software Service

 

 

As a Result,

  • the User Account will set to expire by the end of 24.04.2018, yes 1 day early than selected
  • if you select “Immediately” the DatePicker will be hidden and the User will be disabled.

 

Download the Runbooks: https://gallery.technet.microsoft.com/Orchestrator-Runbook-4ea2d970

Download the Images: https://au2mator.com/service-images/

 

au2mate everything

Your au2mator Team

2018-04-26T12:47:31+00:00April 19th, 2018|Request, Uncategorized|0 Comments

Create a User as au2mator Self Service Portal Service with SCO

Hi,

Here we will show, how to create a Create User (User Onboarding) Service for the au2mator Self Service Portal.

First, the Runbook, it is included in our public Download on TechNet Gallery, Download link is below.

Create the Service

For this Service, we will need the Runbook 04.05-User Onboarding

So Navigate to the au2mator Self Service Portal and create a new Service.

We called it “New User” with a nice Description and a Icon.

If you like you can add an Approval Step, in this case we navigate to the “ADVANCED” Tab and enter some Instructions.

Next, and of course the important step, chose your Runbook  04.05-User Onboarding

Next, got to the “QUESTIONS”

The First Name and Last Name will be a Simple Text Question Type without any Regular Expression.

The Location will be requested from Active Directory, in this case we have an OU for each Location

 

For example, this is our Location OU Structure.