service_members

Creates, updates, deletes, gets or lists a service_members resource.

Overview

Name	service_members
Type	Resource
Id	azure.ad_hybrid_health_service.service_members

Fields

Name	Datatype	Description
activeAlerts	integer	The total number of alerts that are currently active for the server.
additionalInformation	string	The additional information, if any, for the server.
createdDate	string	The date time , in UTC, when the server was onboarded to Azure Active Directory Connect Health.
dimensions	object	The server specific configuration related dimensions.
disabled	boolean	Indicates if the server is disabled or not.
disabledReason	integer	The reason for disabling the server.
installedQfes	object	The list of installed QFEs for the server.
lastDisabled	string	The date and time , in UTC, when the server was last disabled.
lastReboot	string	The date and time, in UTC, when the server was last rebooted.
lastServerReportedMonitoringLevelChange	string	The date and time, in UTC, when the server's data monitoring configuration was last changed.
lastUpdated	string	The date and time, in UTC, when the server properties were last updated.
machineId	string	The id of the machine.
machineName	string	The name of the server.
monitoringConfigurationsComputed	object	The monitoring configuration of the server which determines what activities are monitored by Azure Active Directory Connect Health.
monitoringConfigurationsCustomized	object	The customized monitoring configuration of the server which determines what activities are monitored by Azure Active Directory Connect Health.
osName	string	The name of the operating system installed in the machine.
osVersion	string	The version of the operating system installed in the machine.
properties	object	Server specific properties.
recommendedQfes	object	The list of recommended hotfixes for the server.
resolvedAlerts	integer	The total count of alerts that are resolved for this server.
role	string	The service role that is being monitored in the server.
serverReportedMonitoringLevel	string	The monitoring level reported by the server.
serviceId	string	The service id to whom this server belongs.
serviceMemberId	string	The id of the server.
status	string	The health status of the server.
tenantId	string	The tenant id to whom this server belongs.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	serviceMemberId, serviceName	Gets the details of a server, for a given service, that are onboarded to Azure Active Directory Connect Health Service.
list	SELECT	serviceName	Gets the details of the servers, for a given service, that are onboarded to Azure Active Directory Connect Health Service.
delete	DELETE	serviceMemberId, serviceName	Deletes a server that has been onboarded to Azure Active Directory Connect Health Service.
add	EXEC	serviceName	Onboards a server, for a given service, to Azure Active Directory Connect Health Service.
delete_data	EXEC	serviceMemberId, serviceName	Deletes the data uploaded by the server to Azure Active Directory Connect Health Service.

SELECT examples

Gets the details of the servers, for a given service, that are onboarded to Azure Active Directory Connect Health Service.

SELECT
activeAlerts,
additionalInformation,
createdDate,
dimensions,
disabled,
disabledReason,
installedQfes,
lastDisabled,
lastReboot,
lastServerReportedMonitoringLevelChange,
lastUpdated,
machineId,
machineName,
monitoringConfigurationsComputed,
monitoringConfigurationsCustomized,
osName,
osVersion,
properties,
recommendedQfes,
resolvedAlerts,
role,
serverReportedMonitoringLevel,
serviceId,
serviceMemberId,
status,
tenantId
FROM azure.ad_hybrid_health_service.service_members
WHERE serviceName = '{{ serviceName }}';

DELETE example

Deletes the specified service_members resource.

/*+ delete */
DELETE FROM azure.ad_hybrid_health_service.service_members
WHERE serviceMemberId = '{{ serviceMemberId }}'
AND serviceName = '{{ serviceName }}';