Excel Add-In for Azure Active Directory

Build 24.0.9062

DirectoryAudits

Retrieves all directory audit items for the authenticated user.

Table Specific Information

Select

Most filters are handled server side, but the specific field of Id will change the endpoint we use to retrieve the data. It must be specified with an '=' or IN condition. For example:

SELECT * FROM DirectoryAudits WHERE Id = 'Directory_2183313c-ac52-4772-8482-7b2eb2a5d7c9_LBZWQ_311068785'
SELECT * FROM DirectoryAudits WHERE Id IN ('Directory_2183313c-ac52-4772-8482-7b2eb2a5d7c9_LBZWQ_311068785')
SELECT * FROM DirectoryAudits WHERE ActivityDisplayName LIKE '%Update%'

Columns

Name Type Description
id [KEY] String The id of the DirectoryAudit.
activityDateTime Datetime The activityDateTime of the DirectoryAudit.
activityDisplayName String The activityDisplayName of the DirectoryAudit.
additionalDetails String The additionalDetails of the DirectoryAudit.
category String The category of the DirectoryAudit.
correlationId String The correlationId of the DirectoryAudit.
initiatedBy_app_appid String The initiatedBy_app_appid of the DirectoryAudit.
initiatedBy_app_displayName String The initiatedBy_app_displayName of the DirectoryAudit.
initiatedBy_app_servicePrincipalId String The initiatedBy_app_servicePrincipalId of the DirectoryAudit.
initiatedBy_app_servicePrincipalName String The initiatedBy_app_servicePrincipalName of the DirectoryAudit.
loggedByService String The loggedByService of the DirectoryAudit.
operationType String The operationType of the DirectoryAudit.
result String The result of the DirectoryAudit.
resultReason String The resultReason of the DirectoryAudit.
targetResources String The targetResources of the DirectoryAudit.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062