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