Smart Workspace Access Audit Log
This dataset provides detailed, timestamped audit logs of physical and IoT-enabled access events in modern shared office spaces. It captures user identities, device and location context, access outcomes, and methods, supporting security analysis, compliance reporting, and operational optimization for smart workspaces. Facilities managers, cybersecurity teams, and proptech consultants can leverage this data to monitor security, analyze space utilization, and ensure regulatory compliance.
Sample rows
preview · 8 of 120 rows · all 17 columns| event_idstring | access_methodstring | location_floorinteger | access_grantedboolean | reason_deniedstring | event_timestampdatetime | user_idstring | user_rolestring | device_idstring | device_typestring | location_idstring | location_namestring | location_buildingstring | access_typestring | user_departmentstring | user_emailstring | event_notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| EVT-20230601-001A | RFID | 1 | true | blank | 2023-06-01T06:13:17Z | EMP5142 | employee | DL-12A | door-lock | LOC-1F-ENTR | Main Entrance | HQ-North | entry | Engineering | oliver.smith@ | Employee entered building via RFID |
| EVT-20230601-002B | RFID | 5 | true | blank | 2023-06-01T08:23:44Z | EMP8361 | employee | BR-021 | badge-reader | LOC-5F-MTGA | Meeting Room A | HQ-East | entry | Marketing | emma.jones@ | Access to meeting room granted |
| EVT-20230601-003C | mobile-app | 9 | false | Unauthorized area | 2023-06-01T09:02:11Z | CON7245 | contractor | DL-09B | door-lock | LOC-9F-UTIL | Utility Room | HQ-Tower | entry | Facilities | lucas.hall@ | Contractor denied entry; area restricted |
| EVT-20230601-004D | other | 17 | true | blank | 2023-06-01T10:17:35Z | ADMIN2 | admin | CAM-03 | camera | LOC-17F-SRV | Server Room | HQ-Tower | device-interaction | Security | admin.security@ | Admin performed camera maintenance |
| EVT-20230601-005E | RFID | 1 | true | blank | 2023-06-01T07:38:59Z | EMP2394 | employee | BR-012 | badge-reader | LOC-1F-RCPT | Reception | HQ-North | entry | Finance | mia.lee@ | Employee badge scanned at reception |
| EVT-20230601-006F | RFID | 5 | true | blank | 2023-06-01T18:14:22Z | EMP5142 | employee | BR-021 | badge-reader | LOC-5F-MTGA | Meeting Room A | HQ-East | exit | Engineering | oliver.smith@ | Meeting room exited after session |
| EVT-20230601-007G | mobile-app | 9 | true | blank | 2023-06-01T23:01:01Z | CON7245 | contractor | DL-09B | door-lock | LOC-9F-UTIL | Utility Room | HQ-Tower | exit | Facilities | lucas.hall@ | Contractor exited utility room |
| EVT-20230601-008H | mobile-app | 5 | true | blank | 2023-06-01T11:25:10Z | EMP8361 | employee | SN-107 | sensor | LOC-5F-ENV1 | Environmental Sensor Zone | HQ-East | device-interaction | Marketing | emma.jones@ | Sensor calibration performed |
| EVT-20230601-009I | RFID | 1 | true | blank | 2023-06-01T06:40:48Z | GUEST1001 | guest | BR-015 | badge-reader | LOC-1F-ENTR | Main Entrance | HQ-East | entry | blank | sophia.taylor@ | Guest entered via badge reader |
| EVT-20230601-010J | RFID | 1 | true | blank | 2023-06-01T19:02:21Z | GUEST1001 | guest | BR-015 | badge-reader | LOC-1F-ENTR | Main Entrance | HQ-East | exit | blank | sophia.taylor@ | Guest exited via badge reader |
| EVT-20230601-011K | RFID | 1 | true | blank | 2023-06-01T17:51:12Z | EMP2394 | employee | DL-12A | door-lock | LOC-1F-ENTR | Main Entrance | HQ-North | exit | Finance | mia.lee@ | Employee exited building |
| EVT-20230601-012L | PIN | -1 | false | PIN incorrect | 2023-06-01T05:59:48Z | CON9184 | contractor | DL-02D | door-lock | LOC-B1-STOR | Basement Storage | HQ-Tower | entry | Temporary Staff | harry.evans@ | PIN denied for basement entry |
| EVT-20230601-013M | biometric | 17 | true | blank | 2023-06-01T12:06:38Z | EMP2507 | employee | DL-17V | door-lock | LOC-17F-VLT | Vault Room | HQ-Tower | entry | Executive | jack.wilson@ | Biometric scan successful for vault |
| EVT-20230601-014N | other | 3 | false | Access revoked | 2023-06-01T12:23:51Z | ADMIN1 | admin | CAM-02 | camera | LOC-3F-SRV | Server Room | HQ-North | device-interaction | IT | admin.it@ | Admin denied device interaction |
| EVT-20230601-015O | mobile-app | 9 | true | blank | 2023-06-01T07:50:32Z | EMP7621 | employee | SN-109 | sensor | LOC-9F-ENV2 | Environmental Sensor | HQ-North | device-interaction | R&D | benjamin.morris@ | Sensor maintenance completed |
| EVT-20230601-016P | biometric | 27 | false | Expired credentials | 2023-06-01T06:22:18Z | EMP3508 | employee | DL-27E | door-lock | LOC-27F-EXS | Executive Suite | HQ-Tower | entry | Executive | amelia.clark@ | Biometric denied for suite access |
| EVT-20230601-017Q | mobile-app | 2 | true | blank | 2023-06-01T08:14:35Z | CON6302 | contractor | SN-205 | sensor | LOC-2F-MECH | Mechanical Room | HQ-North | device-interaction | Facilities | grace.martin@ | Contractor checked mechanical sensor |
| EVT-20230601-018R | RFID | 1 | true | blank | 2023-06-01T16:33:09Z | EMP7621 | employee | DL-12A | door-lock | LOC-1F-ENTR | Main Entrance | HQ-North | exit | R&D | benjamin.morris@ | Employee exited building after work |
| EVT-20230601-019S | biometric | 17 | true | blank | 2023-06-01T18:48:51Z | EMP2507 | employee | DL-17V | door-lock | LOC-17F-VLT | Vault Room | HQ-Tower | exit | Executive | jack.wilson@ | Vault access session ended |
| EVT-20230601-020T | RFID | 2 | true | blank | 2023-06-01T08:46:27Z | EMP3508 | employee | BR-011 | badge-reader | LOC-2F-CLAB | Collaboration Lab | HQ-East | entry | Executive | amelia.clark@ | Employee accessed collaboration lab |
What the 120 rows show
from the 120-row sampleBiometric (access method) stands out: mean location_
- 69%access_
granted = true - 2median location_
floor - 4access types
- 5user roles
- 5device types
- 6location buildings
Median 2, from -2 to 27.
- string 14
- integer 1
- datetime 1
- boolean 1
Columns
17 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 14 columns | |||
event_id | string | Unique identifier for each access eventunique | EVT-20230601-001A |
user_id | string | Unique identifier for the user involved in the access event | EMP5142 |
user_role | string | Role of the user (e.g., employee, guest, contractor, admin)employee · guest · contractor · admin · other | employee |
device_id | string | Unique identifier for the IoT device or access point used | DL-12A |
device_type | string | Type of device (e.g., door-lock, sensor, camera, badge-reader)door-lock · sensor · camera · badge-reader · other | door-lock |
location_id | string | Unique identifier for the physical location or room | LOC-1F-ENTR |
location_name | string | Human-readable name of the location (e.g., Meeting Room A, Main Entrance) | Main Entrance |
location_building | string | Name or identifier of the building6 buildings · optional | HQ-North |
access_type | string | Type of access event (e.g., entry, exit, denied, device-interaction)entry · exit · denied · device-interaction · other | entry |
access_method | string | Method used for access (e.g., RFID, mobile-app, biometric, PIN)RFID · mobile-app · biometric · PIN · other | RFID |
reason_denied | string | Reason for access denial, if applicable (e.g., expired credentials, unauthorized area)9 denieds · optional | Unauthorized area |
user_department | string | Department or team the user belongs tooptional | Engineering |
user_email | string | Email address of the user (for audit and compliance)optional | oliver.smith@ |
event_notes | string | Additional notes or comments about the eventoptional | Employee exited building |
| Numbers 1 column | |||
location_floor | integer | Floor number of the location within the building0 or more · optional | 1 |
| Dates and times 1 column | |||
event_timestamp | datetime | Date and time when the access event occurred (UTC) | 2023-06-01T06:13:17Z |
| True or false 1 column | |||
access_granted | boolean | Indicates whether access was granted (true) or denied (false) | true |
Use it for
A technology dashboard
The access_
granted rate, location_ floor by access_ method and a breakdown of reason_ denied. Excel, Power BI or Tableau. Why do the 13 biometric rows have a mean location_
floor of 16.2? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Events120EVT-20230601-001A1RFIDEVT-20230601-002B5RFIDEVT-20230601-003C9mobile-a…
A software demo
Believable events with event_
timestamp, user_ id and user_ role to fill a screen in front of a buyer.
blueprint · smart-workspace-access-audit-log
Behind this dataset
Same schema. As many rows as you need.
These 120 rows came out of a blueprint — 17 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
- Each log entry must specify user role and access point type (e.g., RFID, mobile app, biometric).
- Timestamp must be recorded in ISO 8601 format and reflect timezone of property.
- Access attempts flagged as unauthorized trigger security incident status.
- IoT-registered access points must log device health status at time of event.
- Space utilization flagged if occupancy exceeds configured threshold.
1 credit per row. Preview 20 rows free. Buy rows for the full run.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- smart-workspace-access-audit-log