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
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
- Github Repositority: https://github.com/au2mator/SCOM-Stop-Maintenance-Mode
- 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: Select DA
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*
Feel free to configure other Question or Service Options, click Save to finish the work
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/