--- title: List Active Sessions slug: kron-pam-api-collection-381-patch3/list-active-sessions docTags: createdAt: 2026-10-21T06:07:16.182Z --- { "id": "KLzryUyngYuQ3SA7NMjVp", "type": "api-oas-v2", "data": { "method": "POST", "url": "{{url}}/aioc-rest-web/rest/sc/policy/advancedSearchActiveSessions", "name": "", "description": "

Request Overview

\n

This method lists all active sessions in KRON PAM. It supports pagination and optional advanced search parameters.

\n

Fields

\n", "contentType": "application/json", "request": { "headerParameters": [ { "name": "Content-Type", "description": "", "default": "application/json", "value": "application/json", "type": "string" }, { "name": "X-XSRF-TOKEN", "description": "", "default": "{{csrftoken}}", "value": "{{csrftoken}}", "type": "string" } ], "queryParameters": [], "pathParameters": [ { "name": "url", "description": "", "default": "url", "value": "url", "type": "string" } ], "bodyDataParameters": [ { "name": "body", "description": "", "default": "{\"advancedSearchInput\":null,\"firstResult\":0,\"maxResult\":10}", "value": "{\"advancedSearchInput\":null,\"firstResult\":0,\"maxResult\":10}", "type": "object" } ], "formDataParameters": [], "oAuthParameters": [] }, "responses": [ { "statusCode": "200", "description": "List Active Sessions", "jsonExample": "[\n {\n \"dbId\": 4828186,\n \"sessionId\": \"9c2b988a-0b19-4fc1-816e-c0ef92eb6575\",\n \"userName\": \"SQLPROXY\",\n \"userId\": \"5801ea43-a1c4-4553-ab6e-720eb206938f\",\n \"host\": \"10.20.42.35\",\n \"hostName\": \"ORACLE 12.1 NEW\",\n \"startTime\": 1737359082345,\n \"endTime\": null,\n \"globalUserName\": null,\n \"clientIp\": \"10.20.42.57\",\n \"instanceName\": \"ceydauluturk\",\n \"accessProtocol\": \"ORACLE_TNS\",\n \"reasonForConnection\": null,\n \"tenantId\": null,\n \"approvalId\": null,\n \"agentId\": null,\n \"idleDuration\": null,\n \"command4Search\": null,\n \"deviceGroups4Search\": null,\n \"recordLimit4Search\": null,\n \"videoAvailability\": null,\n \"sessionAudits\": [],\n \"sessionAudit\": null,\n \"remoteAppName\": null,\n \"remoteAppUser\": null,\n \"remoteAppDeviceIp\": null,\n \"isExactMatch4Search\": null,\n \"isJobOps\": null,\n \"hashInfo\": null,\n \"hashDate\": null,\n \"tamperProof\": null,\n \"ocrEnabledForDevice\": null,\n \"filterExactHost\": null,\n \"userFullName\": \"test test\",\n \"status\": null,\n \"firstResult\": null,\n \"maxResult\": null,\n \"tamperProofCheckEnabled\": null,\n \"currentTamperProofLogVersion\": \"v2\",\n \"negativeUsername4Search\": false,\n \"negativeHost4Search\": false,\n \"negativeDeviceGroup4Search\": false,\n \"syslogMap\": {\n \"sessionId\": \"9c2b988a-0b19-4fc1-816e-c0ef92eb6575\",\n \"userName\": \"SQLPROXY\",\n \"userId\": \"5801ea43-a1c4-4553-ab6e-720eb206938f\",\n \"tenantId\": null,\n \"host\": \"10.20.42.35\",\n \"hostName\": \"ORACLE 12.1 NEW\",\n \"startTime\": 1737359082345,\n \"endTime\": null,\n \"globalUserName\": null,\n \"clientIp\": \"10.20.42.57\",\n \"instanceName\": \"ceydauluturk\",\n \"accessProtocol\": \"ORACLE_TNS\",\n \"totalDuration\": -1,\n \"idleDuration\": null,\n \"remoteApplicationName\": null\n },\n \"allowed4Search\": null\n },\n {\n \"dbId\": 4828142,\n \"sessionId\": \"65c2b207-7b12-4a91-8d72-0526b1ea33a1\",\n \"userName\": \"SQLPROXY\",\n \"userId\": \"5801ea43-a1c4-4553-ab6e-720eb206938f\",\n \"host\": \"10.20.42.35\",\n \"hostName\": \"ORACLE 12.1 NEW\",\n \"startTime\": 1737359053520,\n \"endTime\": null,\n \"globalUserName\": null,\n \"clientIp\": \"10.20.42.57\",\n \"instanceName\": \"ceydauluturk\",\n \"accessProtocol\": \"ORACLE_TNS\",\n \"reasonForConnection\": null,\n \"tenantId\": null,\n \"approvalId\": null,\n \"agentId\": null,\n \"idleDuration\": null,\n \"command4Search\": null,\n \"deviceGroups4Search\": null,\n \"recordLimit4Search\": null,\n \"videoAvailability\": null,\n \"sessionAudits\": [],\n \"sessionAudit\": null,\n \"remoteAppName\": null,\n \"remoteAppUser\": null,\n \"remoteAppDeviceIp\": null,\n \"isExactMatch4Search\": null,\n \"isJobOps\": null,\n \"hashInfo\": null,\n \"hashDate\": null,\n \"tamperProof\": null,\n \"ocrEnabledForDevice\": null,\n \"filterExactHost\": null,\n \"userFullName\": \"test test\",\n \"status\": null,\n \"firstResult\": null,\n \"maxResult\": null,\n \"tamperProofCheckEnabled\": null,\n \"currentTamperProofLogVersion\": \"v2\",\n \"negativeUsername4Search\": false,\n \"negativeHost4Search\": false,\n \"negativeDeviceGroup4Search\": false,\n \"syslogMap\": {\n \"sessionId\": \"65c2b207-7b12-4a91-8d72-0526b1ea33a1\",\n \"userName\": \"SQLPROXY\",\n \"userId\": \"5801ea43-a1c4-4553-ab6e-720eb206938f\",\n \"tenantId\": null,\n \"host\": \"10.20.42.35\",\n \"hostName\": \"ORACLE 12.1 NEW\",\n \"startTime\": 1737359053520,\n \"endTime\": null,\n \"globalUserName\": null,\n \"clientIp\": \"10.20.42.57\",\n \"instanceName\": \"ceydauluturk\",\n \"accessProtocol\": \"ORACLE_TNS\",\n \"totalDuration\": -1,\n \"idleDuration\": null,\n \"remoteApplicationName\": null\n },\n \"allowed4Search\": null\n },\n {\n \"dbId\": 4827283,\n \"sessionId\": \"657f1453-a4c1-4a3e-b094-8c6e02c5dd1e\",\n \"userName\": \"SQLPROXY\",\n \"userId\": \"5801ea43-a1c4-4553-ab6e-720eb206938f\",\n \"host\": \"10.20.42.35\",\n \"hostName\": \"ORACLE 12.1 NEW\",\n \"startTime\": 1737357272465,\n \"endTime\": null,\n \"globalUserName\": null,\n \"clientIp\": \"10.20.42.57\",\n \"instanceName\": \"ceydauluturk\",\n \"accessProtocol\": \"ORACLE_TNS\",\n \"reasonForConnection\": null,\n \"tenantId\": null,\n \"approvalId\": null,\n \"agentId\": null,\n \"idleDuration\": null,\n \"command4Search\": null,\n \"deviceGroups4Search\": null,\n \"recordLimit4Search\": null,\n \"videoAvailability\": null,\n \"sessionAudits\": [],\n \"sessionAudit\": null,\n \"remoteAppName\": null,\n \"remoteAppUser\": null,\n \"remoteAppDeviceIp\": null,\n \"isExactMatch4Search\": null,\n \"isJobOps\": null,\n \"hashInfo\": null,\n \"hashDate\": null,\n \"tamperProof\": null,\n \"ocrEnabledForDevice\": null,\n \"filterExactHost\": null,\n \"userFullName\": \"test test\",\n \"status\": null,\n \"firstResult\": null,\n \"maxResult\": null,\n \"tamperProofCheckEnabled\": null,\n \"currentTamperProofLogVersion\": \"v2\",\n \"negativeUsername4Search\": false,\n \"negativeHost4Search\": false,\n \"negativeDeviceGroup4Search\": false,\n \"syslogMap\": {\n \"sessionId\": \"657f1453-a4c1-4a3e-b094-8c6e02c5dd1e\",\n \"userName\": \"SQLPROXY\",\n \"userId\": \"5801ea43-a1c4-4553-ab6e-720eb206938f\",\n \"tenantId\": null,\n \"host\": \"10.20.42.35\",\n \"hostName\": \"ORACLE 12.1 NEW\",\n \"startTime\": 1737357272465,\n \"endTime\": null,\n \"globalUserName\": null,\n \"clientIp\": \"10.20.42.57\",\n \"instanceName\": \"ceydauluturk\",\n \"accessProtocol\": \"ORACLE_TNS\",\n \"totalDuration\": -1,\n \"idleDuration\": null,\n \"remoteApplicationName\": null\n },\n \"allowed4Search\": null\n }\n]" } ], "examples": { "languages": [ { "id": "4weeHqMV9FpAydm3P6Tfg", "language": "curl", "label": "cURL", "code": "curl --request POST \\\n --url {{url}}/aioc-rest-web/rest/sc/policy/advancedSearchActiveSessions \\\n --header 'accept: application/json' \\\n --header 'content-type: application/json' \\\n --header 'x-xsrf-token: {{csrftoken}}' \\\n --data '\"{\\\"advancedSearchInput\\\":null,\\\"firstResult\\\":0,\\\"maxResult\\\":10}\"'" }, { "id": "wd_I7PXp_aHAmKYYhNqRc", "language": "javascript", "label": "javascript", "code": "var myHeaders = new Headers();\nmyHeaders.append(\"accept\", \"application/json\");\nmyHeaders.append(\"content-type\", \"application/json\");\nmyHeaders.append(\"x-xsrf-token\", \"{{csrftoken}}\");\n\nvar raw = JSON.stringify(\"{\\\"advancedSearchInput\\\":null,\\\"firstResult\\\":0,\\\"maxResult\\\":10}\");\n\nvar requestOptions = {\n method: 'POST',\n headers: myHeaders,\n body: raw,\n redirect: 'follow'\n};\n\nfetch(\"{{url}}/aioc-rest-web/rest/sc/policy/advancedSearchActiveSessions\", requestOptions)\n .then(response => response.text())\n .then(result => console.log(result))\n .catch(error => console.log('error', error));" }, { "id": "TPzaVLIgqD2NXVx60xh7l", "language": "ruby", "label": "Ruby", "code": "require \"uri\"\nrequire \"json\"\nrequire \"net/http\"\n\nurl = URI(\"{{url}}/aioc-rest-web/rest/sc/policy/advancedSearchActiveSessions\")\n\nhttp = Net::HTTP.new(url.host, url.port);\nrequest = Net::HTTP::Post.new(url)\nrequest[\"accept\"] = \"application/json\"\nrequest[\"content-type\"] = \"application/json\"\nrequest[\"x-xsrf-token\"] = \"{{csrftoken}}\"\nrequest.body = JSON.dump(\"{\\\"advancedSearchInput\\\":null,\\\"firstResult\\\":0,\\\"maxResult\\\":10}\")\n\nresponse = http.request(request)\nputs response.read_body\n" }, { "id": "A2TX8x6x5UCcDF0cEA1TR", "language": "python", "label": "Python", "code": "import requests\nimport json\n\nurl = \"{{url}}/aioc-rest-web/rest/sc/policy/advancedSearchActiveSessions\"\n\npayload = json.dumps(\"{\\\"advancedSearchInput\\\":null,\\\"firstResult\\\":0,\\\"maxResult\\\":10}\")\nheaders = {\n 'accept': 'application/json',\n 'content-type': 'application/json',\n 'x-xsrf-token': '{{csrftoken}}'\n}\n\nresponse = requests.request(\"POST\", url, headers=headers, data=payload)\n\nprint(response.text)\n" } ], "selectedLanguageId": "4weeHqMV9FpAydm3P6Tfg" }, "results": { "languages": [ { "id": "kSoJRKHW5vy7RICgDo1CE", "language": "200", "code": "[\n {\n \"dbId\": 4828186,\n \"sessionId\": \"9c2b988a-0b19-4fc1-816e-c0ef92eb6575\",\n \"userName\": \"SQLPROXY\",\n \"userId\": \"5801ea43-a1c4-4553-ab6e-720eb206938f\",\n \"host\": \"10.20.42.35\",\n \"hostName\": \"ORACLE 12.1 NEW\",\n \"startTime\": 1737359082345,\n \"endTime\": null,\n \"globalUserName\": null,\n \"clientIp\": \"10.20.42.57\",\n \"instanceName\": \"ceydauluturk\",\n \"accessProtocol\": \"ORACLE_TNS\",\n \"reasonForConnection\": null,\n \"tenantId\": null,\n \"approvalId\": null,\n \"agentId\": null,\n \"idleDuration\": null,\n \"command4Search\": null,\n \"deviceGroups4Search\": null,\n \"recordLimit4Search\": null,\n \"videoAvailability\": null,\n \"sessionAudits\": [],\n \"sessionAudit\": null,\n \"remoteAppName\": null,\n \"remoteAppUser\": null,\n \"remoteAppDeviceIp\": null,\n \"isExactMatch4Search\": null,\n \"isJobOps\": null,\n \"hashInfo\": null,\n \"hashDate\": null,\n \"tamperProof\": null,\n \"ocrEnabledForDevice\": null,\n \"filterExactHost\": null,\n \"userFullName\": \"test test\",\n \"status\": null,\n \"firstResult\": null,\n \"maxResult\": null,\n \"tamperProofCheckEnabled\": null,\n \"currentTamperProofLogVersion\": \"v2\",\n \"negativeUsername4Search\": false,\n \"negativeHost4Search\": false,\n \"negativeDeviceGroup4Search\": false,\n \"syslogMap\": {\n \"sessionId\": \"9c2b988a-0b19-4fc1-816e-c0ef92eb6575\",\n \"userName\": \"SQLPROXY\",\n \"userId\": \"5801ea43-a1c4-4553-ab6e-720eb206938f\",\n \"tenantId\": null,\n \"host\": \"10.20.42.35\",\n \"hostName\": \"ORACLE 12.1 NEW\",\n \"startTime\": 1737359082345,\n \"endTime\": null,\n \"globalUserName\": null,\n \"clientIp\": \"10.20.42.57\",\n \"instanceName\": \"ceydauluturk\",\n \"accessProtocol\": \"ORACLE_TNS\",\n \"totalDuration\": -1,\n \"idleDuration\": null,\n \"remoteApplicationName\": null\n },\n \"allowed4Search\": null\n },\n {\n \"dbId\": 4828142,\n \"sessionId\": \"65c2b207-7b12-4a91-8d72-0526b1ea33a1\",\n \"userName\": \"SQLPROXY\",\n \"userId\": \"5801ea43-a1c4-4553-ab6e-720eb206938f\",\n \"host\": \"10.20.42.35\",\n \"hostName\": \"ORACLE 12.1 NEW\",\n \"startTime\": 1737359053520,\n \"endTime\": null,\n \"globalUserName\": null,\n \"clientIp\": \"10.20.42.57\",\n \"instanceName\": \"ceydauluturk\",\n \"accessProtocol\": \"ORACLE_TNS\",\n \"reasonForConnection\": null,\n \"tenantId\": null,\n \"approvalId\": null,\n \"agentId\": null,\n \"idleDuration\": null,\n \"command4Search\": null,\n \"deviceGroups4Search\": null,\n \"recordLimit4Search\": null,\n \"videoAvailability\": null,\n \"sessionAudits\": [],\n \"sessionAudit\": null,\n \"remoteAppName\": null,\n \"remoteAppUser\": null,\n \"remoteAppDeviceIp\": null,\n \"isExactMatch4Search\": null,\n \"isJobOps\": null,\n \"hashInfo\": null,\n \"hashDate\": null,\n \"tamperProof\": null,\n \"ocrEnabledForDevice\": null,\n \"filterExactHost\": null,\n \"userFullName\": \"test test\",\n \"status\": null,\n \"firstResult\": null,\n \"maxResult\": null,\n \"tamperProofCheckEnabled\": null,\n \"currentTamperProofLogVersion\": \"v2\",\n \"negativeUsername4Search\": false,\n \"negativeHost4Search\": false,\n \"negativeDeviceGroup4Search\": false,\n \"syslogMap\": {\n \"sessionId\": \"65c2b207-7b12-4a91-8d72-0526b1ea33a1\",\n \"userName\": \"SQLPROXY\",\n \"userId\": \"5801ea43-a1c4-4553-ab6e-720eb206938f\",\n \"tenantId\": null,\n \"host\": \"10.20.42.35\",\n \"hostName\": \"ORACLE 12.1 NEW\",\n \"startTime\": 1737359053520,\n \"endTime\": null,\n \"globalUserName\": null,\n \"clientIp\": \"10.20.42.57\",\n \"instanceName\": \"ceydauluturk\",\n \"accessProtocol\": \"ORACLE_TNS\",\n \"totalDuration\": -1,\n \"idleDuration\": null,\n \"remoteApplicationName\": null\n },\n \"allowed4Search\": null\n },\n {\n \"dbId\": 4827283,\n \"sessionId\": \"657f1453-a4c1-4a3e-b094-8c6e02c5dd1e\",\n \"userName\": \"SQLPROXY\",\n \"userId\": \"5801ea43-a1c4-4553-ab6e-720eb206938f\",\n \"host\": \"10.20.42.35\",\n \"hostName\": \"ORACLE 12.1 NEW\",\n \"startTime\": 1737357272465,\n \"endTime\": null,\n \"globalUserName\": null,\n \"clientIp\": \"10.20.42.57\",\n \"instanceName\": \"ceydauluturk\",\n \"accessProtocol\": \"ORACLE_TNS\",\n \"reasonForConnection\": null,\n \"tenantId\": null,\n \"approvalId\": null,\n \"agentId\": null,\n \"idleDuration\": null,\n \"command4Search\": null,\n \"deviceGroups4Search\": null,\n \"recordLimit4Search\": null,\n \"videoAvailability\": null,\n \"sessionAudits\": [],\n \"sessionAudit\": null,\n \"remoteAppName\": null,\n \"remoteAppUser\": null,\n \"remoteAppDeviceIp\": null,\n \"isExactMatch4Search\": null,\n \"isJobOps\": null,\n \"hashInfo\": null,\n \"hashDate\": null,\n \"tamperProof\": null,\n \"ocrEnabledForDevice\": null,\n \"filterExactHost\": null,\n \"userFullName\": \"test test\",\n \"status\": null,\n \"firstResult\": null,\n \"maxResult\": null,\n \"tamperProofCheckEnabled\": null,\n \"currentTamperProofLogVersion\": \"v2\",\n \"negativeUsername4Search\": false,\n \"negativeHost4Search\": false,\n \"negativeDeviceGroup4Search\": false,\n \"syslogMap\": {\n \"sessionId\": \"657f1453-a4c1-4a3e-b094-8c6e02c5dd1e\",\n \"userName\": \"SQLPROXY\",\n \"userId\": \"5801ea43-a1c4-4553-ab6e-720eb206938f\",\n \"tenantId\": null,\n \"host\": \"10.20.42.35\",\n \"hostName\": \"ORACLE 12.1 NEW\",\n \"startTime\": 1737357272465,\n \"endTime\": null,\n \"globalUserName\": null,\n \"clientIp\": \"10.20.42.57\",\n \"instanceName\": \"ceydauluturk\",\n \"accessProtocol\": \"ORACLE_TNS\",\n \"totalDuration\": -1,\n \"idleDuration\": null,\n \"remoteApplicationName\": null\n },\n \"allowed4Search\": null\n }\n]" } ], "selectedLanguageId": "kSoJRKHW5vy7RICgDo1CE" } }, "children": [ { "text": "" } ] }