As a Kisi Organization Owner or Administrator, it can be beneficial to create detailed reports on the events that occur within your Organization or Place specific events. Kisi lets you export all events to use in external software, with Event Exports.
Learn more about Reports in Kisi's documentation portal at docs.kisi.io.
- Create an export at Reports > Event Export. You can select a time period when doing this.
- Once the export is completed, you may download the report in .csv format from this page.
- Load the .csv file in your preferred spreadsheet software (excel, google sheets, open office, etc.)
- Here's where the process will vary by what software you use. You will need to identify which events are of interest to you and filter your results for them. Columns you should become familiar with are detailed below:
- actor_id: A unique identified for the user or member triggering the event.
- actor_email: The email address associated to the account of the user or member triggering the event. For example, the email address of someone who unlocked a door.
- action: What occurred. Most likely you are interested in 'unlock' actions. Try filtering for these.
- object_type: The type of object that is the subject of the event. It could be a lock (doors), a user, an alarm zone, etc. You're most likely interested in 'locks'
- object_id: A unique identifier for the object. When combined with the object_type this essentially refers to a specific object, such as 'Lock 123'
- message: A human-readable description of the event. For example, this will be useful to determine which door was unlocked, and furthermore associate an object_id to a door.
- created_at: The timestamp at which the event occurred.
- Now that you understand these fields, try searching the 'message' column for an event where someone unlocked a door you want to audit.
- Once you have found such a message, look up the 'object_type' and 'object_id' in the same row. Write these down.
- Now, filter the entire sheet for 'action' = unlock, as well as the 'object_type' and 'object_id' you just found. This will show you only the unlock events for that particular lock/door.
- Repeat this process as many times as you need, for as many doors as you like, either in one combined report or as separate sheets depending on your needs.
- If you would like to display users by name rather than email address, you will need to provide supplemental data and perform a table join or vlookup to add in new columns. Try using our Member/User export feature to supply some of this data.