M365 user details (Internal Incubating)¶
OctoSAM Incubating Internal Query
Incubating queries have beta status. They might be experimental. They are not yet fully tested and might change in the future. Once tested and matured these queries may get moved to the regular query tree Consult with Octosoft if and when to use this query
List user details for M365 dashboard.
Fields¶
| Name | Type | Visible | Description |
|---|---|---|---|
| Organization ID | numeric | false | Internal ID that references the Organization entity (Foreign Key) |
| Organization | string | true | Name of the organization this entity is mapped to |
| User ID | numeric | false | Internal ID for the User entity (Primary Key) |
| User Guid | guid | false | A unique ID that can be used to link to this user object by external applications, |
| User | string | true | Distinct user name. Use Column Chooser to show partial values such as Login Name, Domain or Display Name of users |
| Created | date | true | Date/Time this entity was created |
| Last Scan | date | true | Date/Time this entity got scanned last |
| Directory Last Logon Timestamp | date | true | LastLogonTimestamp attribute from Active Directory (updated on import and housekeeping). Resolution: 14 days. |
| Directory Disabled | bool | true | True if the UserAccountControl attribute has the disable bit set |
| Deleted In Directory | bool | true | True, if the user object was deleted from the directory. |
| Deleted In Directory First Detected | date | true | Date/Time the DeletedInDirectory flag was set, |
| Entra Id Created Date Time | date | true | Date/Time created in Entra ID |
| Entra Id Last Sign In Date Time | date | true | Date/Time this user last signed in to Entra ID. This information may not be available depending on your Entra ID license. |
| Last Activation Date | date | true | |
| Last Activity Date | date | true | |
| Current Date Time | date | false | Date and time the query was run. For reference if you use and save query results. |
Main entities referenced from this query¶
Query information¶
| Property | Value | Description |
|---|---|---|
| Query Guid | 2e0d4cd2-dc5e-4ff4-9705-a0703f3f3be5 | The internal id of the query. Must be unique |
| SupportsDesktop | true | If true, the query can be started from the OctoSAM Windows GUI |
| SupportsWeb | false | If true, the query can be started from the OctoSAM Web UI |