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

SCOM Self Service with au2mator – Start Maintenance Mode

How to provide a Self Service Request to Start 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

Run the following Query against your SCOM DB, to create and fill a custom table named “zTable_au2mator_SCOMReasons”

USE [SCOhelp]
GO

INSERT INTO [dbo].[zTable_au2mator_SCOMReasons]
           ([ReasonCode]
           ,[Text])
     VALUES
           ('0','Other (Planned)'),
		   ('1','Other (Unplanned)'),
		   ('2','Hardware: Maintenance (Planned)'),
		   ('3','Hardware: Maintenance (Unplanned)'),
		   ('4','Hardware: Installation (Planned)'),
		   ('5','Hardware: Installation (Unplanned)'),
		   ('6','Operating System: Reconfiguration (Planned)'),
		   ('7','Operating System: Reconfiguration (Unplanned)'),
		   ('8','Application: Maintenance (Planned)'),
		   ('9','Application: Maintenance (Unplanned)'),
		   ('10','Application: Installation (Planned)'),
		   ('11','Application: Unresponsive'),
		   ('12','Application: Unstable'),
		   ('13','Security issue'),
		   ('14','Loss of network connectivity (Unplanned)')
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

Type: SQL Query

Authentication: *depends on your environment*

Question: c_DurationInMinutes

Question: Minutes

Required: true

Order: 2

Type: Int

Question: c_Reason

Question: Select a Reason

Required: true

Order: 3

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 ReasonCode as Code, Text as Reason from zTable_au2mator_SCOMReasons

Type: SQL Query

Authentication: *depends on your environment*

Question: c_Comment

Question: Comment

Required: false

Order: 4

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/

2019-12-31T12:47:06+00:00December 31st, 2019|Uncategorized|0 Comments

Webcast – Get more with System Center and au2mator

See our latest Webcast Recording – Get more with System Center and au2mator, hosted by Michael Seidl, Microsoft MVP and au2mator CEO.

We talked about

  • au2mator and System Center – better together
  • How au2mator and System Center Orchestrator, work together
  • Self Service: Password Reset
  • Self Service: Secure Password Reset
  • Self Service: User Onboarding
  • Self Service: Software Request
  • Self Service: User Management
  • ROI reached at first year
  • au2mator Premier Services

 

You can watch the Video here:

 

 

 

2019-09-14T18:58:38+00:00September 14th, 2019|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