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
queryFrequency: 1d
name: SailPointIdentityNowFailedEventsBasedOnTime
severity: High
triggerThreshold: 0
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
relevantTechniques:
- T1133
status: Available
triggerOperator: gt
queryPeriod: 14d
description: |
'Detects failed events based on created time.'
id: 175b79ef-0fc3-4b27-b92a-89b2db6c85c2
version: 1.0.0
entityMappings:
- fieldMappings:
- columnName: technicalName_s
identifier: Name
entityType: Account
kind: Scheduled
tactics:
- InitialAccess