ai.surenasolutions.in / 127.0.0.1 / surena_crm / biometric_device_audit_events

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Press Ctrl+Enter to execute query

Table navigation bar Use only icons, only text or both.
How to display various action links Use only icons, only text or both.
Allow to display all the rows Whether a user should be displayed a "show all (rows)" button.
Maximum number of rows to display Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Default sorting order `SMART` - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Highlight pointer Highlight row pointed by the mouse cursor.
Row marker Highlight selected rows.
Grid editing: trigger action
Grid editing: save all edited cells at once
Repeat headers Repeat the headers every X cells, `0` deactivates this feature.
Limit column characters Maximum number of characters shown in any non-numeric column on browse view.
Where to show the table row links These are Edit, Copy and Delete links.
Show row links anyway Whether to show row links even in the absence of a unique key.
Primary key default sort order Default sort order for tables with a primary key.
Remember table's sorting When browsing tables, the sorting of each table is remembered.
Relational display For display Options

Table navigation bar

Use only icons, only text or both.

How to display various action links

Use only icons, only text or both.

Allow to display all the rows

Whether a user should be displayed a "show all (rows)" button.

Maximum number of rows to display

Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.

Default sorting order

SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.

Highlight pointer

Highlight row pointed by the mouse cursor.

Row marker

Highlight selected rows.

Grid editing: trigger action

Grid editing: save all edited cells at once

Repeat headers

Repeat the headers every X cells, 0 deactivates this feature.

Limit column characters

Maximum number of characters shown in any non-numeric column on browse view.

Where to show the table row links

These are Edit, Copy and Delete links.

Show row links anyway

Whether to show row links even in the absence of a unique key.

Primary key default sort order

Default sort order for tables with a primary key.

Remember table's sorting

When browsing tables, the sorting of each table is remembered.

Relational display

For display Options

			id	device_id	entity_type	entity_id	action_code	actor_user_id	request_id	before_json	after_json	metadata_json	event_at_utc	created_at
Edit	Copy	Delete DELETE FROM biometric_device_audit_events WHERE `biometric_device_audit_events`.`id` = 1	1	1	DEVICE_COMMAND	6e85fc3c-d26c-4836-88e8-690c4ccfa72c	DEVICE_USER_COMMAND_QUEUED	1	ff9162382277c9f7197c94bc96e265bf	NULL	NULL	{"command_type":"DEVICE_USER_CREATE","device_perso...	2026-09-14 13:49:14	2026-09-14 13:49:14
Edit	Copy	Delete DELETE FROM biometric_device_audit_events WHERE `biometric_device_audit_events`.`id` = 2	2	1	DEVICE_COMMAND	6e85fc3c-d26c-4836-88e8-690c4ccfa72c	DEVICE_COMMAND_CLAIMED	NULL	71744ace8fa74c4a7c66debb784f9093	NULL	NULL	{"connector_instance_id":4,"command_type":"DEVICE_...	2026-09-14 13:49:17	2026-09-14 13:49:17
Edit	Copy	Delete DELETE FROM biometric_device_audit_events WHERE `biometric_device_audit_events`.`id` = 3	3	1	DEVICE_COMMAND	6e85fc3c-d26c-4836-88e8-690c4ccfa72c	DEVICE_COMMAND_COMPLETED	NULL	4e7c6aed5ae991f27248acdc36db6391	NULL	NULL	{"connector_instance_id":4,"command_type":"DEVICE_...	2026-09-14 13:49:19	2026-09-14 13:49:19
Edit	Copy	Delete DELETE FROM biometric_device_audit_events WHERE `biometric_device_audit_events`.`id` = 4	4	1	DEVICE_COMMAND	0965564e-eb62-444a-b7dd-c80a5d4c2b9b	DEVICE_USER_COMMAND_QUEUED	1	afcf003bf18431a9d1c169981e7d7496	NULL	NULL	{"command_type":"DEVICE_USER_DELETE","device_perso...	2026-09-14 13:52:47	2026-09-14 13:52:47
Edit	Copy	Delete DELETE FROM biometric_device_audit_events WHERE `biometric_device_audit_events`.`id` = 5	5	1	DEVICE_COMMAND	0965564e-eb62-444a-b7dd-c80a5d4c2b9b	DEVICE_COMMAND_CLAIMED	NULL	cdc0b2843a12c3fb80f3fb37df7a2ae3	NULL	NULL	{"connector_instance_id":4,"command_type":"DEVICE_...	2026-09-14 13:53:17	2026-09-14 13:53:17
Edit	Copy	Delete DELETE FROM biometric_device_audit_events WHERE `biometric_device_audit_events`.`id` = 6	6	1	DEVICE_COMMAND	0965564e-eb62-444a-b7dd-c80a5d4c2b9b	DEVICE_COMMAND_COMPLETED	NULL	dad76da5280e71c11412f036c4eaed4e	NULL	NULL	{"connector_instance_id":4,"command_type":"DEVICE_...	2026-09-14 13:53:19	2026-09-14 13:53:19
Edit	Copy	Delete DELETE FROM biometric_device_audit_events WHERE `biometric_device_audit_events`.`id` = 7	7	1	DEVICE_USER_INVENTORY	1	DEVICE_USER_INVENTORY_RECONCILED	NULL	30a4587670ca2280bdc96ad03b404621	NULL	NULL	{"connector_instance_id":4,"inventory_complete":tr...	2026-09-14 14:15:25	2026-09-14 14:15:25
Edit	Copy	Delete DELETE FROM biometric_device_audit_events WHERE `biometric_device_audit_events`.`id` = 8	8	1	DEVICE_USER_INVENTORY	1	DEVICE_USER_INVENTORY_RECONCILED	NULL	6d3f7fb7616945667f9e65465627fa0b	NULL	NULL	{"connector_instance_id":4,"inventory_complete":tr...	2026-09-14 14:24:43	2026-09-14 14:24:43
Edit	Copy	Delete DELETE FROM biometric_device_audit_events WHERE `biometric_device_audit_events`.`id` = 9	9	1	DEVICE_COMMAND	56e35861-b49a-4049-99ec-d784d142944f	DEVICE_USER_COMMAND_QUEUED	1	8d4b38894c7d7b7d6442d8ac7ab44e4d	NULL	NULL	{"command_type":"DEVICE_USER_CREATE","device_perso...	2026-09-14 15:33:00	2026-09-14 15:33:00
Edit	Copy	Delete DELETE FROM biometric_device_audit_events WHERE `biometric_device_audit_events`.`id` = 10	10	1	DEVICE_COMMAND	56e35861-b49a-4049-99ec-d784d142944f	DEVICE_COMMAND_CLAIMED	NULL	283310ce8c0b926874d4fc812e0abad7	NULL	NULL	{"connector_instance_id":4,"command_type":"DEVICE_...	2026-09-14 15:33:18	2026-09-14 15:33:18
Edit	Copy	Delete DELETE FROM biometric_device_audit_events WHERE `biometric_device_audit_events`.`id` = 11	11	1	EMPLOYEE_MAPPING	3	DEVICE_USER_MAPPING_CREATED_AFTER_VERIFIED_CREATE	NULL	7de5a48f66704b502a0cd9cf63bb662a	NULL	NULL	{"employee_id":8,"device_person_id":"8","valid_fro...	2026-09-14 15:43:24	2026-09-14 15:43:24
Edit	Copy	Delete DELETE FROM biometric_device_audit_events WHERE `biometric_device_audit_events`.`id` = 12	12	1	DEVICE_COMMAND	56e35861-b49a-4049-99ec-d784d142944f	DEVICE_COMMAND_COMPLETED	NULL	7de5a48f66704b502a0cd9cf63bb662a	NULL	NULL	{"connector_instance_id":4,"command_type":"DEVICE_...	2026-09-14 15:43:24	2026-09-14 15:43:24
Edit	Copy	Delete DELETE FROM biometric_device_audit_events WHERE `biometric_device_audit_events`.`id` = 13	13	1	DEVICE_USER_INVENTORY	1	DEVICE_USER_INVENTORY_RECONCILED	NULL	ede003b72e3c10ebc0b9d3c91aec01f3	NULL	NULL	{"connector_instance_id":4,"inventory_complete":tr...	2026-09-14 15:43:25	2026-09-14 15:43:25
Edit	Copy	Delete DELETE FROM biometric_device_audit_events WHERE `biometric_device_audit_events`.`id` = 14	14	1	DEVICE_COMMAND	53646433-cbf0-4449-84d0-44977410ce96	DEVICE_USER_COMMAND_QUEUED	1	8834c2492063149da37a19f7feb0da29	NULL	NULL	{"command_type":"DEVICE_USER_UPDATE","device_perso...	2026-09-14 15:47:08	2026-09-14 15:47:08
Edit	Copy	Delete DELETE FROM biometric_device_audit_events WHERE `biometric_device_audit_events`.`id` = 15	15	1	DEVICE_COMMAND	53646433-cbf0-4449-84d0-44977410ce96	DEVICE_COMMAND_CLAIMED	NULL	031b69f171aed387f422d1b6b12e9e80	NULL	NULL	{"connector_instance_id":4,"command_type":"DEVICE_...	2026-09-14 15:47:17	2026-09-14 15:47:17
Edit	Copy	Delete DELETE FROM biometric_device_audit_events WHERE `biometric_device_audit_events`.`id` = 16	16	1	DEVICE_COMMAND	53646433-cbf0-4449-84d0-44977410ce96	DEVICE_COMMAND_COMPLETED	NULL	38ba45c0c7c860468e7189264cfa871a	NULL	NULL	{"connector_instance_id":4,"command_type":"DEVICE_...	2026-09-14 15:47:19	2026-09-14 15:47:19
Edit	Copy	Delete DELETE FROM biometric_device_audit_events WHERE `biometric_device_audit_events`.`id` = 17	17	1	DEVICE_USER_INVENTORY	1	DEVICE_USER_INVENTORY_RECONCILED	NULL	e5b6d5fd52c4a4ed7138befbafef9460	NULL	NULL	{"connector_instance_id":4,"inventory_complete":tr...	2026-09-14 15:47:20	2026-09-14 15:47:20
Edit	Copy	Delete DELETE FROM biometric_device_audit_events WHERE `biometric_device_audit_events`.`id` = 18	18	1	DEVICE_COMMAND	042c6c44-9f21-4c9f-9cc2-8de82f8ee74d	DEVICE_USER_COMMAND_QUEUED	1	55a29574eb9568ea1eb674b51cc4d300	NULL	NULL	{"command_type":"DEVICE_USER_UPDATE","device_perso...	2026-09-14 15:57:41	2026-09-14 15:57:41
Edit	Copy	Delete DELETE FROM biometric_device_audit_events WHERE `biometric_device_audit_events`.`id` = 19	19	1	DEVICE_COMMAND	042c6c44-9f21-4c9f-9cc2-8de82f8ee74d	DEVICE_COMMAND_CLAIMED	NULL	83c1cc89d2712b2ce6c474c4c39b32c0	NULL	NULL	{"connector_instance_id":4,"command_type":"DEVICE_...	2026-09-14 15:58:17	2026-09-14 15:58:17
Edit	Copy	Delete DELETE FROM biometric_device_audit_events WHERE `biometric_device_audit_events`.`id` = 20	20	1	DEVICE_COMMAND	042c6c44-9f21-4c9f-9cc2-8de82f8ee74d	DEVICE_COMMAND_COMPLETED	NULL	856d7666adc1442d56225a2b1463bc81	NULL	NULL	{"connector_instance_id":4,"command_type":"DEVICE_...	2026-09-14 15:58:19	2026-09-14 15:58:19
Edit	Copy	Delete DELETE FROM biometric_device_audit_events WHERE `biometric_device_audit_events`.`id` = 21	21	1	DEVICE_USER_INVENTORY	1	DEVICE_USER_INVENTORY_RECONCILED	NULL	00906e6bb06fff643d8709c060ea303c	NULL	NULL	{"connector_instance_id":4,"inventory_complete":tr...	2026-09-14 15:58:20	2026-09-14 15:58:20
Edit	Copy	Delete DELETE FROM biometric_device_audit_events WHERE `biometric_device_audit_events`.`id` = 22	22	1	DEVICE_COMMAND	a3357cc9-e499-4444-85e1-5d29a8d7efea	DEVICE_USER_COMMAND_QUEUED	1	39a6928dcabc97f237656742d63c8a12	NULL	NULL	{"command_type":"DEVICE_USER_DISABLE","device_pers...	2026-09-14 16:12:20	2026-09-14 16:12:20
Edit	Copy	Delete DELETE FROM biometric_device_audit_events WHERE `biometric_device_audit_events`.`id` = 23	23	1	DEVICE_COMMAND	a3357cc9-e499-4444-85e1-5d29a8d7efea	DEVICE_COMMAND_CLAIMED	NULL	c825dfddc5180897b0af02b99720e242	NULL	NULL	{"connector_instance_id":4,"command_type":"DEVICE_...	2026-09-14 16:13:18	2026-09-14 16:13:18
Edit	Copy	Delete DELETE FROM biometric_device_audit_events WHERE `biometric_device_audit_events`.`id` = 24	24	1	DEVICE_COMMAND	a3357cc9-e499-4444-85e1-5d29a8d7efea	DEVICE_COMMAND_COMPLETED	NULL	a5632919ff25428b46f7e720b7373332	NULL	NULL	{"connector_instance_id":4,"command_type":"DEVICE_...	2026-09-14 16:13:20	2026-09-14 16:13:20
Edit	Copy	Delete DELETE FROM biometric_device_audit_events WHERE `biometric_device_audit_events`.`id` = 25	25	1	DEVICE_USER_INVENTORY	1	DEVICE_USER_INVENTORY_RECONCILED	NULL	cb10ccbee3cabc8a8739d0c832566ce9	NULL	NULL	{"connector_instance_id":4,"inventory_complete":tr...	2026-09-14 16:13:21	2026-09-14 16:13:21

Customize appearance of the navigation panel.

Customize the navigation tree.

Servers display options.

Databases display options.

Tables display options.

SQL upload ( 0 ) x -

Customize browse mode.

Navigation panel

Customize appearance of the navigation panel.

Navigation tree

Customize the navigation tree.

Servers

Servers display options.

Databases

Databases display options.

Tables

Tables display options.

SQL upload ( 0 ) x -

Browse mode

Customize browse mode.