managed_database_security_events

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

Overview

Name	managed_database_security_events
Type	Resource
Id	azure.sql.managed_database_security_events

Fields

The following fields are returned by SELECT queries:

list_by_database

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
name	string	The name of the resource.
applicationName	string	The application used to execute the statement.
clientIp	string	The IP address of the client who executed the statement.
database	string	The database name.
eventTime	string (date-time)	The time when the security event occurred.
principalName	string	The principal user who executed the statement.
securityEventSqlInjectionAdditionalProperties	object	The sql injection additional properties, populated only if the type of the security event is sql injection.
securityEventType	string	The type of the security event. Known values are: "Undefined", "SqlInjectionVulnerability", and "SqlInjectionExploit". (Undefined, SqlInjectionVulnerability, SqlInjectionExploit)
server	string	The server name.
subscription	string	The subscription name.
systemData	object	Azure Resource Manager metadata containing createdBy and modifiedBy information.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list_by_database	select	resource_group_name, managed_instance_name, database_name, subscription_id	$filter, $skip, $top, $skiptoken	Gets a list of security events.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
database_name	string	The name of the database. Required.
managed_instance_name	string	The name of the managed instance. Required.
resource_group_name	string	The name of the resource group. The name is case insensitive. Required.
subscription_id	string
$filter	string	An OData filter expression that filters elements in the collection. Default value is None.
$skip	integer	The number of elements in the collection to skip. Default value is None.
$skiptoken	string	An opaque token that identifies a starting point in the collection. Default value is None.
$top	integer	The number of elements to return from the collection. Default value is None.

SELECT examples

list_by_database

Gets a list of security events.

SELECT
id,
name,
applicationName,
clientIp,
database,
eventTime,
principalName,
securityEventSqlInjectionAdditionalProperties,
securityEventType,
server,
subscription,
systemData,
type
FROM azure.sql.managed_database_security_events
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND managed_instance_name = '{{ managed_instance_name }}' -- required
AND database_name = '{{ database_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
AND $filter = '{{ $filter }}'
AND $skip = '{{ $skip }}'
AND $top = '{{ $top }}'
AND $skiptoken = '{{ $skiptoken }}'
;