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
name: SailPointIdentityNowFailedEventsBasedOnTime
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
entityMappings:
- entityType: Account
fieldMappings:
- columnName: technicalName_s
identifier: Name
queryPeriod: 14d
version: 1.0.0
tactics:
- InitialAccess
triggerOperator: gt
kind: Scheduled
triggerThreshold: 0
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/SailPointIdentityNow/Analytic Rules/SailPointIdentityNowFailedEventsBasedOnTime.yaml
relevantTechniques:
- T1133
id: 175b79ef-0fc3-4b27-b92a-89b2db6c85c2
severity: High
requiredDataConnectors:
- connectorId: SailPointIdentityNow
dataTypes:
- SailPointIDN_Events_CL
status: Available
description: |
'Detects failed events based on created time.'
queryFrequency: 1d