# audit_2025_11_17

timestamp: 2025-11-17T04:42:18.713Z
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-11-17T04:44:08.423Z
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 "user_type" in ($2, $3) and "is_active" = $4 limit $5


timestamp: 2025-11-17T04:44:08.517Z
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-11-16T18:52:59.698Z","lastLoginIp":"::1","failedLoginAttempts":0,"timezone":"UTC","locale":"en-US","userType":"SUPERADMIN","isActive":true,"isSystem":true}


timestamp: 2025-11-17T04:44:08.667Z
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-11-17T04:44:08.774Z
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-11-17T04:44:08.861Z
level: debug
metadata: {}
message:
Knex query response: [{"roleId":"68e06c11-0437-4b39-98b7-fec86c2a51c2","name":"super admin","code":"SUPERADMIN"}]


timestamp: 2025-11-17T04:44:08.873Z
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-11-17T04:44:08.967Z
level: debug
metadata: {}
message:
Knex query response: [{"accessprofileid":"0fc584a4-5073-444c-a70e-a9fb56401307","name":"SUPERADMIN"}]


timestamp: 2025-11-17T04:44:09.371Z
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-11-17T04:44:09.456Z
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-11-17T04:44:09.536Z
level: debug
metadata: {}
message:
Knex query response: [{"applicationId":1,"appName":"EVerify","appDescription":"e verify application","appDisplayName":"E Verify","appIconPath":"casesApp","appUrlSubPath":"/everify"}]


timestamp: 2025-11-17T04:44:09.543Z
level: debug
metadata: {}
message:
Knex query: 
                        WITH RECURSIVE MenuHierarchy AS (
                    SELECT
                        id,
                        name,
                        displayname,
                        parentmenuid,
                        displayorder,
                        app_id,
                        path,
                        iconmarkup,
                        menuitemtype_enum as menuItemType,
                        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,
                        m.iconmarkup,
                        m.menuitemtype_enum as menuItemType,
                        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-11-17T04:44:09.622Z
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","iconmarkup":"","menuitemtype":1,"level":0},{"id":2,"name":"master","displayname":"Masters","parentmenuid":null,"displayorder":2,"app_id":1,"path":null,"iconmarkup":"","menuitemtype":2,"level":0},{"id":3,"name":"appolice","displayname":"AP Police","parentmenuid":null,"displayorder":3,"app_id":1,"path":null,"iconmarkup":"","menuitemtype":2,"level":0},{"id":4,"name":"states","displayname":"States","parentmenuid":2,"displayorder":1,"app_id":1,"path":"/everify/master/states","iconmarkup":"","menuitemtype":1,"level":1},{"id":5,"name":"village","displayname":"Village","parentmenuid":2,"displayorder":4,"app_id":1,"path":"/everify/master/villages","iconmarkup":"","menuitemtype":1,"level":1},{"id":6,"name":"district","displayname":"District","parentmenuid":2,"displayorder":2,"app_id":1,"path":"/everify/master/districts","iconmarkup":"","menuitemtype":1,"level":1},{"id":7,"name":"mandal","displayname":"Manadal","parentmenuid":2,"displayorder":3,"app_id":1,"path":"/everify/master/mandals","iconmarkup":"","menuitemtype":1,"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":"iconmarkup","tableID":0,"columnID":0,"dataTypeID":1043,"dataTypeSize":-1,"dataTypeModifier":2004,"format":"text"},{"name":"menuitemtype","tableID":0,"columnID":0,"dataTypeID":23,"dataTypeSize":4,"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,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,"iconmarkup":null,"menuitemtype":null,"level":null}}


timestamp: 2025-11-17T04:45:38.341Z
level: debug
metadata: {}
message:
Knex query: select "state_id", "state_name", "state_code", "is_union_territory", "country_name", "country_code" from "master"."states" where "is_active" = $1 order by "state_name" asc


timestamp: 2025-11-17T04:45:38.424Z
level: debug
metadata: {}
message:
Knex query response: [{"stateId":29,"stateName":"Andaman and Nicobar Islands","stateCode":"AN","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":1,"stateName":"Andhra Pradesh","stateCode":"AP","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":2,"stateName":"Arunachal Pradesh","stateCode":"ARP","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":3,"stateName":"Assam","stateCode":"AS","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":4,"stateName":"Bihar","stateCode":"BR","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":30,"stateName":"Chandigarh","stateCode":"CH","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":5,"stateName":"Chhattisgarh","stateCode":"CG","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":31,"stateName":"Dadra and Nagar Haveli and Daman and Diu","stateCode":"DN","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":32,"stateName":"Delhi","stateCode":"DL","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":6,"stateName":"Goa","stateCode":"GA","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":7,"stateName":"Gujarat","stateCode":"GJ","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":8,"stateName":"Haryana","stateCode":"HR","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":9,"stateName":"Himachal Pradesh","stateCode":"HP","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":33,"stateName":"Jammu and Kashmir","stateCode":"JK","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":10,"stateName":"Jharkhand","stateCode":"JH","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":11,"stateName":"Karnataka","stateCode":"KA","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":12,"stateName":"Kerala","stateCode":"KL","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":34,"stateName":"Ladakh","stateCode":"LA","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":35,"stateName":"Lakshadweep","stateCode":"LD","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":13,"stateName":"Madhya Pradesh","stateCode":"MP","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":14,"stateName":"Maharashtra","stateCode":"MH","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":15,"stateName":"Manipur","stateCode":"MN","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":16,"stateName":"Meghalaya","stateCode":"ML","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":17,"stateName":"Mizoram","stateCode":"MZ","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":18,"stateName":"Nagaland","stateCode":"NL","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":19,"stateName":"Odisha","stateCode":"OD","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":36,"stateName":"Puducherry","stateCode":"PY","isUnionTerritory":true,"countryName":"India","countryCode":"IN"},{"stateId":20,"stateName":"Punjab","stateCode":"PB","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":21,"stateName":"Rajasthan","stateCode":"RJ","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":37,"stateName":"Sample","stateCode":"","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":22,"stateName":"Sikkim","stateCode":"SK","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":23,"stateName":"Tamil Nadu","stateCode":"TN","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":24,"stateName":"Telangana","stateCode":"TS","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":25,"stateName":"Tripura","stateCode":"TR","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":26,"stateName":"Uttar Pradesh","stateCode":"UP","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":27,"stateName":"Uttarakhand","stateCode":"UK","isUnionTerritory":false,"countryName":"India","countryCode":"IN"},{"stateId":28,"stateName":"West Bengal","stateCode":"WB","isUnionTerritory":false,"countryName":"India","countryCode":"IN"}]


timestamp: 2025-11-17T04:46:06.970Z
level: debug
metadata: {}
message:
Knex query: select "district_id", "district_name", "states"."state_id", "state_name", "state_code", "district_code", "headquarters", "population", "area_sq_km", "latitude", "longitude", "formation_date", "website_url", "notes", "districts"."is_active", "country_name", "country_code" from "master"."districts" inner join "master"."states" on "states"."state_id" = "districts"."state_id" where "districts"."is_active" = $1 order by "district_name" asc


timestamp: 2025-11-17T04:46:07.122Z
level: debug
metadata: {}
message:
Knex query response: [{"districtId":8,"districtName":"Adilabad","stateId":24,"stateName":"Telangana","stateCode":"TS","districtCode":"AB","headquarters":null,"population":null,"areaSqKm":null,"latitude":null,"longitude":null,"formationDate":null,"websiteUrl":null,"notes":null,"isActive":true,"countryName":"India","countryCode":"IN"},{"districtId":1,"districtName":"Capital City District","stateId":1,"stateName":"Andhra Pradesh","stateCode":"AP","districtCode":"CCD01","headquarters":"Metropolis Central","population":"1250000","areaSqKm":"1500.75","latitude":"34.052235","longitude":"-118.243683","formationDate":"1950-04-10","websiteUrl":"http://capitalcitydistrict.example.gov","notes":"The primary administrative and commercial hub of its state. Hosts major governmental offices.","isActive":true,"countryName":"India","countryCode":"IN"},{"districtId":7,"districtName":"New Dist","stateId":1,"stateName":"Andhra Pradesh","stateCode":"AP","districtCode":"DISC","headquarters":null,"population":null,"areaSqKm":null,"latitude":null,"longitude":null,"formationDate":null,"websiteUrl":null,"notes":null,"isActive":true,"countryName":"India","countryCode":"IN"},{"districtId":2,"districtName":"Northern Pines District","stateId":2,"stateName":"Arunachal Pradesh","stateCode":"ARP","districtCode":"NPD02","headquarters":"Pinewood Town","population":"320000","areaSqKm":"4875.50","latitude":"45.523064","longitude":"-122.676483","formationDate":"1978-07-01","websiteUrl":"http://northernpines.example.gov","notes":"Known for its extensive forests, timber industry, and national parks. Popular tourist destination for hiking and camping.","isActive":true,"countryName":"India","countryCode":"IN"},{"districtId":6,"districtName":"Vijayawada","stateId":1,"stateName":"Andhra Pradesh","stateCode":"AP","districtCode":null,"headquarters":null,"population":null,"areaSqKm":null,"latitude":null,"longitude":null,"formationDate":null,"websiteUrl":null,"notes":null,"isActive":true,"countryName":"India","countryCode":"IN"}]


