Smart Access Control Event Log
This dataset provides a detailed log of smart building access control events, capturing user identities, access points, event types, and security actions. It supports anomaly detection, remote security operations, and compliance auditing, making it ideal for facility managers and cybersecurity teams seeking to optimize physical asset protection and investigate unauthorized access attempts.
Sample rows
preview · 8 of 120 rows · all 18 columns| event_idstring | user_rolestring | anomaly_flagboolean | asset_typestring | timestampdatetime | user_idstring | user_namestring | access_point_idstring | access_point_locationstring | access_methodstring | event_typestring | event_reasonstring | asset_idstring | compliance_flagboolean | remote_access_flagboolean | audit_trail_idstring | security_action_takenstring | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SRV-20240601-AB12 | employee | false | office | 2024-06-01T08:14:22Z | U1001 | Elena Duarte | DOOR-OFC-01 | Main Office Entrance | rfid_card | access_granted | RFID match - entry authorized | OFC-01 | true | false | AUD-936252 | blank | Routine entry during business hours |
| VIS-20240601-001 | visitor | false | blank | 2024-06-01T09:07:06Z | VIS-104 | blank | GATE-PARK-02 | South Parking Gate | pin | access_denied | Invalid PIN entered | blank | false | false | AUD-815203 | blank | PIN entered incorrectly three times |
| C-20240601-021 | contractor | false | server_room | 2024-06-01T07:41:14Z | C-2071 | Yusuf Malik | SRV-RM2 | Server Room 2 | biometric | access_granted | Biometric match - contractor access | SRV-02 | true | false | AUD-116237 | blank | Early morning maintenance window |
| ADMIN-20240601-88 | admin | false | lab | 2024-06-01T05:59:50Z | ADMIN005 | Katherine Shaw | LAB-DOOR-1 | Chemistry Lab West | biometric | system_override | Admin override for scheduled patch | LAB-01 | true | false | AUD-502901 | blank | Override for security patch deployment |
| SEC-20240601-01 | security | true | server_room | 2024-06-01T02:11:33Z | S-SEC03 | Miguel Torres | SRV-RM1 | Server Room 1 | manual_override | forced_entry | Forced open alarm detected by system | SRV-01 | false | false | AUD-721164 | Security dispatched to investigate forced entry | Emergency protocol initiated |
| VIS-20240601-002 | visitor | false | blank | 2024-06-01T12:25:19Z | VIS-120 | blank | GATE-PARK-03 | East Parking Gate | pin | access_denied | Expired visitor pass | blank | false | false | AUD-008236 | blank | Visitor pass expired |
| U1002-20240601 | employee | false | office | 2024-06-01T07:56:44Z | U1002 | Alexis Walker | DOOR-OFC-02 | Main Office Rear | rfid_card | access_granted | RFID match - entry authorized | OFC-02 | false | false | blank | blank | Routine entry |
| C-20240601-043 | contractor | false | lab | 2024-06-01T10:18:33Z | C-2098 | Marta Ivanova | LAB-DOOR-2 | Physics Lab North | mobile_app | access_granted | Mobile credential matched | LAB-02 | true | true | AUD-652219 | blank | Remote entry for maintenance |
| VIS-20240601-003 | visitor | false | blank | 2024-06-01T11:07:41Z | VIS-142 | Marcus Lee | DOOR-LOBBY-01 | Lobby Entrance | pin | access_denied | No user name registered | blank | false | false | AUD-139024 | blank | Visitor name missing in system |
| SRV-20240601-XY89 | employee | false | server_room | 2024-06-01T03:31:10Z | U1003 | Owen Chen | SRV-RM3 | Server Room 3 | biometric | access_granted | Biometric match - entry authorized | SRV-03 | true | false | AUD-412825 | blank | Server maintenance shift |
| VIS-20240601-004 | visitor | true | blank | 2024-06-01T10:45:55Z | VIS-159 | blank | DOOR-VIS-01 | Visitor Entrance | other | access_denied | No mobile credential | blank | false | false | AUD-324117 | Visitor flagged for manual check | Unusual credential attempt |
| U1004-20240601 | employee | false | office | 2024-06-01T08:25:33Z | U1004 | Sofia Garcia | DOOR-OFC-03 | Main Office Side | rfid_card | access_granted | RFID match - entry authorized | OFC-03 | true | false | blank | blank | Routine entry |
| C-20240601-055 | contractor | false | blank | 2024-06-01T13:16:48Z | C-2110 | Alicia Dixon | PARK-DOOR-01 | Parking Garage Entry | mobile_app | access_denied | Mobile device not registered | blank | false | true | AUD-208503 | blank | Contractor mobile app failed validation |
| SEC-20240601-02 | security | true | server_room | 2024-06-01T01:02:08Z | S-SEC04 | Leonard Price | SRV-RM2 | Server Room 2 | manual_override | door_forced_open | System detected forced open | SRV-02 | false | false | AUD-813645 | Security team alerted; incident logged | Door forced open outside business hours |
| U1005-20240601 | employee | false | office | 2024-06-01T07:17:51Z | U1005 | Priya Nair | DOOR-OFC-04 | Main Office Emergency Exit | rfid_card | access_granted | RFID match - entry authorized | OFC-04 | false | false | blank | blank | Early entry |
| C-20240601-067 | contractor | false | warehouse | 2024-06-01T14:40:37Z | C-2133 | Gabriel Souza | WARE-DOOR-02 | Warehouse Door East | biometric | access_granted | Biometric match - contractor access | WH-02 | true | false | AUD-957102 | blank | Afternoon delivery access |
| ADMIN-20240601-99 | admin | false | server_room | 2024-06-01T04:21:23Z | ADMIN006 | Noah West | SRV-RM2 | Server Room 2 | manual_override | system_override | Admin override for testing failover | SRV-02 | true | false | AUD-335219 | blank | System override for failover test |
| SEC-20240601-03 | security | true | blank | 2024-06-01T03:57:45Z | S-SEC05 | Olivia Bennett | DOOR-LOBBY-01 | Lobby Entrance | biometric | door_held_open | Door held open alarm triggered | blank | false | false | AUD-490311 | Door monitored, security notified | Door held open for extended time |
| U1006-20240601 | employee | false | office | 2024-06-01T09:29:05Z | U1006 | Hannah Li | DOOR-OFC-05 | Main Office Secondary | rfid_card | access_granted | RFID match - entry authorized | OFC-05 | true | false | blank | blank | Routine office entry |
| C-20240601-089 | contractor | true | blank | 2024-06-01T15:51:12Z | C-2159 | Liam Baker | PARK-DOOR-02 | Parking Garage Exit | biometric | access_denied | Biometric mismatch | blank | false | false | AUD-712498 | Contractor flagged for security review | Biometric mismatch; entry denied |
What the 120 rows show
from the 120-row sampleSecurity (user role) stands out: 19 of its 20 rows have anomaly_
- 23%anomaly_
flag = true - 6access methods
- 6event types
- string 14
- datetime 1
- boolean 3
Columns
18 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 14 columns | |||
event_id | string | Unique identifier for each access control eventunique | SRV-20240601-AB12 |
user_id | string | Unique identifier for the user attempting access | U1001 |
user_name | string | Full name of the user attempting accessoptional | Elena Duarte |
user_role | string | Role or designation of the user (e.g., employee, contractor, visitor)6 values · optional | employee |
access_point_id | string | Unique identifier for the physical access point (e.g., door, gate, turnstile) | DOOR-OFC-01 |
access_point_location | string | Physical location or description of the access pointoptional | Main Office Entrance |
access_method | string | Method used for access (e.g., RFID card, PIN, biometric, mobile app)6 values | rfid_card |
event_type | string | Type of event (e.g., access_granted, access_denied, forced_entry, door_held_open)7 values | access_granted |
event_reason | string | Reason or system message for the event (e.g., invalid credential, expired access, successful authentication)optional | Invalid PIN entered |
asset_id | string | Unique identifier for the protected physical asset or areaoptional | OFC-01 |
asset_type | string | Type of asset being protected (e.g., server room, office, warehouse)6 values · optional | office |
audit_trail_id | string | Identifier for the related audit trail recordoptional | AUD-936252 |
security_action_taken | string | Action taken by security personnel or system in response to the eventoptional | Lab lockdown initiated |
notes | string | Additional notes or comments about the eventoptional | Visitor pass expired |
| Dates and times 1 column | |||
timestamp | datetime | Date and time when the access event occurred (UTC) | 2024-06-01T08:14:22Z |
| True or false 3 columns | |||
compliance_flag | boolean | Indicates if the event is relevant to compliance monitoring (true/false)optional | true |
remote_access_flag | boolean | Indicates if the access attempt was initiated remotelyoptional | false |
anomaly_flag | boolean | Indicates if the event was flagged as anomalous by the systemoptional | false |
Use it for
A technology dashboard
The anomaly_
flag rate, anomaly_ flag by user_ role and a breakdown of asset_ type. Excel, Power BI or Tableau. Why do 28 of 120 rows have anomaly_
flag = true? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Events120SRV-20240601-AB12employeeSEC-20240601-01securityVIS-20240601-004visitor
A software demo
Believable events with timestamp, user_
id and user_ name to fill a screen in front of a buyer.
blueprint · smart-access-control-event-log
Behind this dataset
Same schema. As many rows as you need.
These 120 rows came out of a blueprint — 18 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 event must record timestamp, access point ID, and user credential type.
- Unusual access events (e.g., repeated failed attempts, off-hours access) are flagged for review.
- Only registered users or maintenance staff can access secure areas.
- Events with missing location or credential data are excluded.
- Multi-factor authentication events are tagged separately.
- Access granted and denied events are clearly differentiated.
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-access-control-event-log