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.

  • last updated 30 Nov 2025
  • by GoMask
The brief that made it

Physical security monitoring and incident investigation

Sample rows

preview · 8 of 120 rows · all 17 columns
event_idstringaccess_methodstringlocation_floorintegeraccess_grantedbooleanreason_deniedstringevent_timestampdatetimeuser_idstringuser_rolestringdevice_idstringdevice_typestringlocation_idstringlocation_namestringlocation_buildingstringaccess_typestringuser_departmentstringuser_emailstringevent_notesstring
EVT-20230601-001ARFID1trueblank2023-06-01T06:13:17ZEMP5142employeeDL-12Adoor-lockLOC-1F-ENTRMain EntranceHQ-NorthentryEngineeringoliver.smith@corp.comEmployee entered building via RFID
EVT-20230601-002BRFID5trueblank2023-06-01T08:23:44ZEMP8361employeeBR-021badge-readerLOC-5F-MTGAMeeting Room AHQ-EastentryMarketingemma.jones@corp.comAccess to meeting room granted
EVT-20230601-003Cmobile-app9falseUnauthorized area2023-06-01T09:02:11ZCON7245contractorDL-09Bdoor-lockLOC-9F-UTILUtility RoomHQ-TowerentryFacilitieslucas.hall@tempstaff.comContractor denied entry; area restricted
EVT-20230601-004Dother17trueblank2023-06-01T10:17:35ZADMIN2adminCAM-03cameraLOC-17F-SRVServer RoomHQ-Towerdevice-interactionSecurityadmin.security@corp.comAdmin performed camera maintenance
EVT-20230601-005ERFID1trueblank2023-06-01T07:38:59ZEMP2394employeeBR-012badge-readerLOC-1F-RCPTReceptionHQ-NorthentryFinancemia.lee@corp.comEmployee badge scanned at reception
EVT-20230601-006FRFID5trueblank2023-06-01T18:14:22ZEMP5142employeeBR-021badge-readerLOC-5F-MTGAMeeting Room AHQ-EastexitEngineeringoliver.smith@corp.comMeeting room exited after session
EVT-20230601-007Gmobile-app9trueblank2023-06-01T23:01:01ZCON7245contractorDL-09Bdoor-lockLOC-9F-UTILUtility RoomHQ-TowerexitFacilitieslucas.hall@tempstaff.comContractor exited utility room
EVT-20230601-008Hmobile-app5trueblank2023-06-01T11:25:10ZEMP8361employeeSN-107sensorLOC-5F-ENV1Environmental Sensor ZoneHQ-Eastdevice-interactionMarketingemma.jones@corp.comSensor calibration performed

What the 120 rows show

from the 120-row sample

Biometric (access method) stands out: mean location_floor is 16.2, against 3.3 for the rest.

  • 69%access_granted = true
  • 2median location_floor
  • 4access types
  • 5user roles
  • 5device types
  • 6location buildings
location_floor120 rows, in bands of 5
035709672541401-51530location_floor →

Median 2, from -2 to 27.

reason_denied37 rows with a value · 83 left blank
  1. Expired credentials8
  2. Invalid device6
  3. Unauthorized time5
  4. Unauthorized area4
  5. PIN incorrect4
  6. Access revoked4
  7. Elevator lockout3
  8. Expired badge2
  9. Device error1
17 columns by typefrom the column list below
  • string 14
  • integer 1
  • datetime 1
  • boolean 1

Columns

17 columns in four groups
blueprint · 17 columns
columntypedescriptionexample
Text 14 columns
event_idstringUnique identifier for each access eventuniqueEVT-20230601-001A
user_idstringUnique identifier for the user involved in the access eventEMP5142
user_rolestringRole of the user (e.g., employee, guest, contractor, admin)employee · guest · contractor · admin · otheremployee
device_idstringUnique identifier for the IoT device or access point usedDL-12A
device_typestringType of device (e.g., door-lock, sensor, camera, badge-reader)door-lock · sensor · camera · badge-reader · otherdoor-lock
location_idstringUnique identifier for the physical location or roomLOC-1F-ENTR
location_namestringHuman-readable name of the location (e.g., Meeting Room A, Main Entrance)Main Entrance
location_buildingstringName or identifier of the building6 buildings · optionalHQ-North
access_typestringType of access event (e.g., entry, exit, denied, device-interaction)entry · exit · denied · device-interaction · otherentry
access_methodstringMethod used for access (e.g., RFID, mobile-app, biometric, PIN)RFID · mobile-app · biometric · PIN · otherRFID
reason_deniedstringReason for access denial, if applicable (e.g., expired credentials, unauthorized area)9 denieds · optionalUnauthorized area
user_departmentstringDepartment or team the user belongs tooptionalEngineering
user_emailstringEmail address of the user (for audit and compliance)optionaloliver.smith@corp.com
event_notesstringAdditional notes or comments about the eventoptionalEmployee exited building
Numbers 1 column
location_floorintegerFloor number of the location within the building0 or more · optional1
Dates and times 1 column
event_timestampdatetimeDate and time when the access event occurred (UTC)2023-06-01T06:13:17Z
True or false 1 column
access_grantedbooleanIndicates whether access was granted (true) or denied (false)true

Use it for

  • access granted69%83 of 120 rows

    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.

  • A software demo

    Believable events with event_timestamp, user_id and user_role to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 17 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset120 rows17 columns
Yours1,000 rows17 columnslocation_id: UK only

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.

Rules it was built with
  • 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.
Rows
Open the blueprint in Data Factory

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

What should your data show?

Preview 20 rows free
No signup. No card.