Automatic Monitoring Template
Automatic monitoring template allows you to configure monitoring by discovering all managed instances in the specified Azure subscription automatically.
To configure monitoring using the automatic monitoring template, perform the following steps:
In the System Center Operations Manager console, navigate to Authoring | Management Pack Templates, right-click Azure SQL MI - Automatic, and select Add Monitoring Wizard….
At the Monitoring Type step, select Azure SQL MI - Automatic, and select Next.
At the General Properties step, enter a name and description, and from the Select destination management pack dropdown list, select a management pack that you want to use to store the template.
At the Azure Endpoints step, select the Enable checkbox if you want to change default Azure Endpoints checkbox, and modify the default Azure endpoints, if necessary. The default endpoints for creating Azure Service Principal Name are as follows:
- Authority URI:
- Management Service URI:
- Database Resource URI:
- Graph API Resource URI:
- Authority URI:
At the SPN Configuration step, select any of the following options:
Select this option if you want your Azure Service Principal Name to be created automatically by the Azure SQL MI MP library using the Azure REST API.
Ensure that the account that you use must have either the Owner role (or higher), or any of the following roles:
Active Directory Administrator
Service Administrator or Co-Administrator
For more information, see How to - Use the portal to create an Azure AD application and service principal that can access resources.
Use Existing Run As Profile
Select this option if you want to use your own Azure Service Principal Name.
If you select the Auto-Create SPN option, the Microsoft Azure sign-in window will be displayed. In this window, enter your work, school, or personal Microsoft account credentials, select Next, and complete the form.
Upon the successful creation of the Azure AD application, at the Auto-Create SPN Status step, authentication data will be displayed. Select Next.
If you want to use an existing Run As Profile, at the SPN Configuration step, select the Use Existing Run As Profile option, select Next, and select an existing Run As Account associated with the Azure service principal name. This Run As Account will be used for authentication in Azure Cloud.
At the Subscription Permissions step, select the Azure subscriptions that you want to monitor.
At the SQL Connection Settings step, select an authentication method that you want to use to connect to your managed instances.
Regardless of the selected option, ensure to grant required permissions to the selected monitoring account for all the managed instances. For more information, see Security Configuration.
At the Configure Instances Filtering step, you can configure the filtering options:
Select this option to specify instances that shouldn't be discovered.
Select this option to specify only those instances that you want to be discovered.
Use an asterisk to replace any symbol/symbols.
At the Summary step, review the connection settings and select Create.