# audit_2025_05_21

timestamp: 2025-05-21T08:33:12.635Z
level: debug
metadata: {}
message:
Knex query response: {"command":"SELECT","rowCount":1,"oid":null,"rows":[{"?column?":1}],"fields":[{"name":"?column?","tableID":0,"columnID":0,"dataTypeID":23,"dataTypeSize":4,"dataTypeModifier":-1,"format":"text"}],"_Parsers":[null],"_Types":{"_types":{"arrayParser":{},"builtins":{"BOOL":16,"BYTEA":17,"CHAR":18,"INT8":20,"INT2":21,"INT4":23,"REGPROC":24,"TEXT":25,"OID":26,"TID":27,"XID":28,"CID":29,"JSON":114,"XML":142,"PG_NODE_TREE":194,"SMGR":210,"PATH":602,"POLYGON":604,"CIDR":650,"FLOAT4":700,"FLOAT8":701,"ABSTIME":702,"RELTIME":703,"TINTERVAL":704,"CIRCLE":718,"MACADDR8":774,"MONEY":790,"MACADDR":829,"INET":869,"ACLITEM":1033,"BPCHAR":1042,"VARCHAR":1043,"DATE":1082,"TIME":1083,"TIMESTAMP":1114,"TIMESTAMPTZ":1184,"INTERVAL":1186,"TIMETZ":1266,"BIT":1560,"VARBIT":1562,"NUMERIC":1700,"REFCURSOR":1790,"REGPROCEDURE":2202,"REGOPER":2203,"REGOPERATOR":2204,"REGCLASS":2205,"REGTYPE":2206,"UUID":2950,"TXID_SNAPSHOT":2970,"PG_LSN":3220,"PG_NDISTINCT":3361,"PG_DEPENDENCIES":3402,"TSVECTOR":3614,"TSQUERY":3615,"GTSVECTOR":3642,"REGCONFIG":3734,"REGDICTIONARY":3769,"JSONB":3802,"REGNAMESPACE":4089,"REGROLE":4096}},"text":{},"binary":{}},"RowCtor":null,"rowAsArray":false,"_PrebuiltEmptyResultObject":{"?column?":null}}


timestamp: 2025-05-22T06:14:59.218Z
level: debug
metadata: {}
message:
Knex query: select "user_id", "username", "email", "email_verified", "password_hash", "password_salt", "first_name", "last_name", "phone_number", "phone_verified", "last_login", "last_login_ip", "failed_login_attempts", "timezone", "locale", "user_type", "is_active", "is_system" from "identity"."users" where "username" = $1 and "is_active" = $2 limit $3


timestamp: 2025-05-22T06:14:59.296Z
level: debug
metadata: {}
message:
Knex query response: {"userId":"1c702878-d657-4393-b551-22e8879c8025","username":"admin","email":"admin@mail.com","emailVerified":true,"passwordHash":"664bb692f30c9bc71ade","passwordSalt":{"iv":"6fb399fc5f8d9fa567fee517f1e363c6","tag":"24bbcc859702605c80773975918d2560"},"firstName":"admin","lastName":null,"phoneNumber":null,"phoneVerified":true,"lastLogin":"2025-05-21T07:56:06.858Z","lastLoginIp":"::1","failedLoginAttempts":0,"timezone":"UTC","locale":"en-US","userType":"SUPERADMIN","isActive":true,"isSystem":true}


timestamp: 2025-05-22T06:14:59.462Z
level: debug
metadata: {}
message:
Knex query: update "identity"."users" set "failed_login_attempts" = $1, "last_login" = $2, "last_login_ip" = $3 where "user_id" = $4


timestamp: 2025-05-22T06:14:59.531Z
level: debug
metadata: {}
message:
Knex query: select "user_roles"."role_id", "roles"."name", "roles"."code" from "core"."user_roles" inner join "core"."roles" on "roles"."role_id" = "user_roles"."role_id" where "user_roles"."user_id" = $1 and "user_roles"."is_active" = $2 and "core"."roles"."is_active" = $3


timestamp: 2025-05-22T06:14:59.587Z
level: debug
metadata: {}
message:
Knex query response: [{"roleId":"68e06c11-0437-4b39-98b7-fec86c2a51c2","name":"super admin","code":"SUPERADMIN"}]


timestamp: 2025-05-22T06:14:59.596Z
level: debug
metadata: {}
message:
Knex query: select "useraccessprofile"."accessprofileid", "access_profiles"."name" from "core"."useraccessprofile" inner join "core"."access_profiles" on "access_profiles"."profile_id" = "useraccessprofile"."accessprofileid" where "useraccessprofile"."userid" = $1 and "access_profiles"."is_active" = $2


timestamp: 2025-05-22T06:14:59.654Z
level: debug
metadata: {}
message:
Knex query response: [{"accessprofileid":"0fc584a4-5073-444c-a70e-a9fb56401307","name":"SUPERADMIN"}]


# audit_2025_05_22

timestamp: 2025-05-22T07:22:34.910Z
level: debug
metadata: {}
message:
Knex query response: {"userId":"1c702878-d657-4393-b551-22e8879c8025","username":"admin","email":"admin@mail.com","emailVerified":true,"passwordHash":"664bb692f30c9bc71ade","passwordSalt":{"iv":"6fb399fc5f8d9fa567fee517f1e363c6","tag":"24bbcc859702605c80773975918d2560"},"firstName":"admin","lastName":null,"phoneNumber":null,"phoneVerified":true,"lastLogin":"2025-05-22T06:14:59.441Z","lastLoginIp":"::1","failedLoginAttempts":0,"timezone":"UTC","locale":"en-US","userType":"SUPERADMIN","isActive":true,"isSystem":true}


timestamp: 2025-05-22T07:23:55.709Z
level: debug
metadata: {}
message:
Knex query: select "accessprofileid" from "core"."useraccessprofile" inner join "core"."access_profiles" on "access_profiles"."profile_id" = "useraccessprofile"."accessprofileid" where "userid" = $1


timestamp: 2025-05-22T07:23:55.819Z
level: debug
metadata: {}
message:
Knex query: select "applicationid" as "application_id", "app"."name" as "app_name", "app"."description" as "app_description", "app"."displayname" as "app_display_name", "app"."iconpath" as "app_icon_path", "app"."urlsubpath" as "app_url_sub_path" from "core"."accessprofileapp" inner join "core"."app" on "app"."id" = "accessprofileapp"."applicationid" where "accessprofileid" in ($1) and "app"."isactive" = $2


timestamp: 2025-05-22T07:23:55.907Z
level: debug
metadata: {}
message:
Knex query response: [{"applicationId":1,"appName":"EVerify","appDescription":"e verify application","appDisplayName":"E Verify","appIconPath":"","appUrlSubPath":"/everify"}]


timestamp: 2025-05-22T07:23:55.919Z
level: debug
metadata: {}
message:
Knex query: 
                        WITH RECURSIVE MenuHierarchy AS (
                    SELECT
                        id,
                        name,
                        displayname,
                        parentmenuid,
                        displayorder,
                        app_id,
                        path,
                        0 AS level
                       
                    FROM core.menubar
                    WHERE (parentmenuid IS NULL OR parentmenuid = 0) AND app_id = $1

                    UNION ALL

                    SELECT
                        m.id,
                        m.name,
                        m.displayname,
                        m.parentmenuid,
                        m.displayorder,
                        m.app_id,
                        m.path,
                        mh.level + 1
                          
                    FROM core.menubar m
                    INNER JOIN MenuHierarchy mh ON m.parentmenuid = mh.id
                    WHERE m.isactive = true AND m.app_id = $2
                    )
                    SELECT *
                    FROM MenuHierarchy
                    ORDER BY id, level;
                        


timestamp: 2025-05-22T07:23:55.978Z
level: debug
metadata: {}
message:
Knex query response: {"command":"SELECT","rowCount":7,"oid":null,"rows":[{"id":1,"name":"Dashboard","displayname":"Dashboard","parentmenuid":null,"displayorder":1,"app_id":1,"path":"/everify/dashboard","level":0},{"id":2,"name":"Parent 1","displayname":"Parent One","parentmenuid":null,"displayorder":2,"app_id":1,"path":null,"level":0},{"id":3,"name":"Parent 1","displayname":"Parent Two","parentmenuid":null,"displayorder":3,"app_id":1,"path":null,"level":0},{"id":4,"name":"Parent 1","displayname":"Sub Parent 1 Child 1 ","parentmenuid":2,"displayorder":3,"app_id":1,"path":"/everify/child11","level":1},{"id":5,"name":"Parent 1","displayname":"Sub Parent 1 Child 2 ","parentmenuid":2,"displayorder":3,"app_id":1,"path":"/everify/child12","level":1},{"id":6,"name":"Parent 1","displayname":"Sub Parent 2 Child 1 ","parentmenuid":3,"displayorder":3,"app_id":1,"path":"/everify/child21","level":1},{"id":7,"name":"Parent 1","displayname":"Sub Parent 2 Child 2 ","parentmenuid":3,"displayorder":3,"app_id":1,"path":"/everify/child22","level":1}],"fields":[{"name":"id","tableID":0,"columnID":0,"dataTypeID":23,"dataTypeSize":4,"dataTypeModifier":-1,"format":"text"},{"name":"name","tableID":0,"columnID":0,"dataTypeID":1043,"dataTypeSize":-1,"dataTypeModifier":104,"format":"text"},{"name":"displayname","tableID":0,"columnID":0,"dataTypeID":1043,"dataTypeSize":-1,"dataTypeModifier":104,"format":"text"},{"name":"parentmenuid","tableID":0,"columnID":0,"dataTypeID":23,"dataTypeSize":4,"dataTypeModifier":-1,"format":"text"},{"name":"displayorder","tableID":0,"columnID":0,"dataTypeID":23,"dataTypeSize":4,"dataTypeModifier":-1,"format":"text"},{"name":"app_id","tableID":0,"columnID":0,"dataTypeID":23,"dataTypeSize":4,"dataTypeModifier":-1,"format":"text"},{"name":"path","tableID":0,"columnID":0,"dataTypeID":1043,"dataTypeSize":-1,"dataTypeModifier":-1,"format":"text"},{"name":"level","tableID":0,"columnID":0,"dataTypeID":23,"dataTypeSize":4,"dataTypeModifier":-1,"format":"text"}],"_Parsers":[null,null,null,null,null,null,null,null],"_Types":{"_types":{"arrayParser":{},"builtins":{"BOOL":16,"BYTEA":17,"CHAR":18,"INT8":20,"INT2":21,"INT4":23,"REGPROC":24,"TEXT":25,"OID":26,"TID":27,"XID":28,"CID":29,"JSON":114,"XML":142,"PG_NODE_TREE":194,"SMGR":210,"PATH":602,"POLYGON":604,"CIDR":650,"FLOAT4":700,"FLOAT8":701,"ABSTIME":702,"RELTIME":703,"TINTERVAL":704,"CIRCLE":718,"MACADDR8":774,"MONEY":790,"MACADDR":829,"INET":869,"ACLITEM":1033,"BPCHAR":1042,"VARCHAR":1043,"DATE":1082,"TIME":1083,"TIMESTAMP":1114,"TIMESTAMPTZ":1184,"INTERVAL":1186,"TIMETZ":1266,"BIT":1560,"VARBIT":1562,"NUMERIC":1700,"REFCURSOR":1790,"REGPROCEDURE":2202,"REGOPER":2203,"REGOPERATOR":2204,"REGCLASS":2205,"REGTYPE":2206,"UUID":2950,"TXID_SNAPSHOT":2970,"PG_LSN":3220,"PG_NDISTINCT":3361,"PG_DEPENDENCIES":3402,"TSVECTOR":3614,"TSQUERY":3615,"GTSVECTOR":3642,"REGCONFIG":3734,"REGDICTIONARY":3769,"JSONB":3802,"REGNAMESPACE":4089,"REGROLE":4096}},"text":{},"binary":{}},"RowCtor":null,"rowAsArray":false,"_PrebuiltEmptyResultObject":{"id":null,"name":null,"displayname":null,"parentmenuid":null,"displayorder":null,"app_id":null,"path":null,"level":null}}


timestamp: 2025-05-22T08:06:33.938Z
level: debug
metadata: {}
message:
Knex query response: [{"applicationId":1,"appName":"EVerify","appDescription":"e verify application","appDisplayName":"E Verify","appIconPath":"casesApp","appUrlSubPath":"/everify"}]


# audit_2025_05_23

timestamp: 2025-05-23T07:16:24.260Z
level: debug
metadata: {}
message:
Knex query response: {"userId":"1c702878-d657-4393-b551-22e8879c8025","username":"admin","email":"admin@mail.com","emailVerified":true,"passwordHash":"664bb692f30c9bc71ade","passwordSalt":{"iv":"6fb399fc5f8d9fa567fee517f1e363c6","tag":"24bbcc859702605c80773975918d2560"},"firstName":"admin","lastName":null,"phoneNumber":null,"phoneVerified":true,"lastLogin":"2025-05-22T07:22:35.072Z","lastLoginIp":"::1","failedLoginAttempts":0,"timezone":"UTC","locale":"en-US","userType":"SUPERADMIN","isActive":true,"isSystem":true}


