SailPointIdentityNowFailedEventsBasedOnTime

Back


Id	175b79ef-0fc3-4b27-b92a-89b2db6c85c2
Rulename	SailPointIdentityNowFailedEventsBasedOnTime
Description	Detects failed events based on created time.
Severity	High
Tactics	InitialAccess
Techniques	T1133
Required data connectors	SailPointIdentityNow
Kind	Scheduled
Query frequency	1d
Query period	14d
Trigger threshold	0
Trigger operator	gt
Source Uri	https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/SailPointIdentityNow/Analytic Rules/SailPointIdentityNowFailedEventsBasedOnTime.yaml
Version	1.0.0
Arm template	175b79ef-0fc3-4b27-b92a-89b2db6c85c2.json

KQL

declare query_parameters(lbperiod:timespan = 14d, createdTime:string = "2020-08-19T20:34:38.676Z");
  SailPointIDN_Events_CL
  | where TimeGenerated > ago(lbperiod)
  | where status_s == "FAILED"
  | where created_t >= created_t
  | sort by created_t

YAML

description: |
    'Detects failed events based on created time.'
version: 1.0.0
triggerThreshold: 0
tactics:
- InitialAccess
queryPeriod: 14d
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/SailPointIdentityNow/Analytic Rules/SailPointIdentityNowFailedEventsBasedOnTime.yaml
triggerOperator: gt
status: Available
id: 175b79ef-0fc3-4b27-b92a-89b2db6c85c2
name: SailPointIdentityNowFailedEventsBasedOnTime
queryFrequency: 1d
severity: High
kind: Scheduled
entityMappings:
- fieldMappings:
  - columnName: technicalName_s
    identifier: Name
  entityType: Account
relevantTechniques:
- T1133
query: |
  declare query_parameters(lbperiod:timespan = 14d, createdTime:string = "2020-08-19T20:34:38.676Z");
    SailPointIDN_Events_CL
    | where TimeGenerated > ago(lbperiod)
    | where status_s == "FAILED"
    | where created_t >= created_t
    | sort by created_t  
requiredDataConnectors:
- dataTypes:
  - SailPointIDN_Events_CL
  connectorId: SailPointIdentityNow

ARM