List Active Sessions

1 min

POST

{{url}}/aioc-rest-web/rest/sc/policy/advancedSearchActiveSessions

Request Overview

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

Fields

firstResult (number): The index of the first session to return.
maxResult (number): The maximum number of sessions to return.
advancedSearchInput: For advanced search criteria. If you do not need advanced filters, set it to null.

Path Parameters

urlstring
Default
url

Header Parameters

Content-Typestring
Default
application/json
X-XSRF-TOKENstring
Default
{{csrftoken}}

Body Parameters

bodyobject
Default
{"advancedSearchInput":null,"firstResult":0,"maxResult":10}

Responses

200List Active Sessions

curl

curl --request POST \
     --url {{url}}/aioc-rest-web/rest/sc/policy/advancedSearchActiveSessions \
     --header 'accept: application/json' \
     --header 'content-type: application/json' \
     --header 'x-xsrf-token: {{csrftoken}}' \
     --data '"{\"advancedSearchInput\":null,\"firstResult\":0,\"maxResult\":10}"'

javascript

var myHeaders = new Headers();
myHeaders.append("accept", "application/json");
myHeaders.append("content-type", "application/json");
myHeaders.append("x-xsrf-token", "{{csrftoken}}");

var raw = JSON.stringify("{\"advancedSearchInput\":null,\"firstResult\":0,\"maxResult\":10}");

var requestOptions = {
   method: 'POST',
   headers: myHeaders,
   body: raw,
   redirect: 'follow'
};

fetch("{{url}}/aioc-rest-web/rest/sc/policy/advancedSearchActiveSessions", requestOptions)
   .then(response => response.text())
   .then(result => console.log(result))
   .catch(error => console.log('error', error));

ruby

require "uri"
require "json"
require "net/http"

url = URI("{{url}}/aioc-rest-web/rest/sc/policy/advancedSearchActiveSessions")

http = Net::HTTP.new(url.host, url.port);
request = Net::HTTP::Post.new(url)
request["accept"] = "application/json"
request["content-type"] = "application/json"
request["x-xsrf-token"] = "{{csrftoken}}"
request.body = JSON.dump("{\"advancedSearchInput\":null,\"firstResult\":0,\"maxResult\":10}")

response = http.request(request)
puts response.read_body

python

import requests
import json

url = "{{url}}/aioc-rest-web/rest/sc/policy/advancedSearchActiveSessions"

payload = json.dumps("{\"advancedSearchInput\":null,\"firstResult\":0,\"maxResult\":10}")
headers = {
   'accept': 'application/json',
   'content-type': 'application/json',
   'x-xsrf-token': '{{csrftoken}}'
}

response = requests.request("POST", url, headers=headers, data=payload)

print(response.text)

200

[
    {
        "dbId": 4828186,
        "sessionId": "9c2b988a-0b19-4fc1-816e-c0ef92eb6575",
        "userName": "SQLPROXY",
        "userId": "5801ea43-a1c4-4553-ab6e-720eb206938f",
        "host": "10.20.42.35",
        "hostName": "ORACLE 12.1 NEW",
        "startTime": 1737359082345,
        "endTime": null,
        "globalUserName": null,
        "clientIp": "10.20.42.57",
        "instanceName": "ceydauluturk",
        "accessProtocol": "ORACLE_TNS",
        "reasonForConnection": null,
        "tenantId": null,
        "approvalId": null,
        "agentId": null,
        "idleDuration": null,
        "command4Search": null,
        "deviceGroups4Search": null,
        "recordLimit4Search": null,
        "videoAvailability": null,
        "sessionAudits": [],
        "sessionAudit": null,
        "remoteAppName": null,
        "remoteAppUser": null,
        "remoteAppDeviceIp": null,
        "isExactMatch4Search": null,
        "isJobOps": null,
        "hashInfo": null,
        "hashDate": null,
        "tamperProof": null,
        "ocrEnabledForDevice": null,
        "filterExactHost": null,
        "userFullName": "test test",
        "status": null,
        "firstResult": null,
        "maxResult": null,
        "tamperProofCheckEnabled": null,
        "currentTamperProofLogVersion": "v2",
        "negativeUsername4Search": false,
        "negativeHost4Search": false,
        "negativeDeviceGroup4Search": false,
        "syslogMap": {
            "sessionId": "9c2b988a-0b19-4fc1-816e-c0ef92eb6575",
            "userName": "SQLPROXY",
            "userId": "5801ea43-a1c4-4553-ab6e-720eb206938f",
            "tenantId": null,
            "host": "10.20.42.35",
            "hostName": "ORACLE 12.1 NEW",
            "startTime": 1737359082345,
            "endTime": null,
            "globalUserName": null,
            "clientIp": "10.20.42.57",
            "instanceName": "ceydauluturk",
            "accessProtocol": "ORACLE_TNS",
            "totalDuration": -1,
            "idleDuration": null,
            "remoteApplicationName": null
        },
        "allowed4Search": null
    },
    {
        "dbId": 4828142,
        "sessionId": "65c2b207-7b12-4a91-8d72-0526b1ea33a1",
        "userName": "SQLPROXY",
        "userId": "5801ea43-a1c4-4553-ab6e-720eb206938f",
        "host": "10.20.42.35",
        "hostName": "ORACLE 12.1 NEW",
        "startTime": 1737359053520,
        "endTime": null,
        "globalUserName": null,
        "clientIp": "10.20.42.57",
        "instanceName": "ceydauluturk",
        "accessProtocol": "ORACLE_TNS",
        "reasonForConnection": null,
        "tenantId": null,
        "approvalId": null,
        "agentId": null,
        "idleDuration": null,
        "command4Search": null,
        "deviceGroups4Search": null,
        "recordLimit4Search": null,
        "videoAvailability": null,
        "sessionAudits": [],
        "sessionAudit": null,
        "remoteAppName": null,
        "remoteAppUser": null,
        "remoteAppDeviceIp": null,
        "isExactMatch4Search": null,
        "isJobOps": null,
        "hashInfo": null,
        "hashDate": null,
        "tamperProof": null,
        "ocrEnabledForDevice": null,
        "filterExactHost": null,
        "userFullName": "test test",
        "status": null,
        "firstResult": null,
        "maxResult": null,
        "tamperProofCheckEnabled": null,
        "currentTamperProofLogVersion": "v2",
        "negativeUsername4Search": false,
        "negativeHost4Search": false,
        "negativeDeviceGroup4Search": false,
        "syslogMap": {
            "sessionId": "65c2b207-7b12-4a91-8d72-0526b1ea33a1",
            "userName": "SQLPROXY",
            "userId": "5801ea43-a1c4-4553-ab6e-720eb206938f",
            "tenantId": null,
            "host": "10.20.42.35",
            "hostName": "ORACLE 12.1 NEW",
            "startTime": 1737359053520,
            "endTime": null,
            "globalUserName": null,
            "clientIp": "10.20.42.57",
            "instanceName": "ceydauluturk",
            "accessProtocol": "ORACLE_TNS",
            "totalDuration": -1,
            "idleDuration": null,
            "remoteApplicationName": null
        },
        "allowed4Search": null
    },
    {
        "dbId": 4827283,
        "sessionId": "657f1453-a4c1-4a3e-b094-8c6e02c5dd1e",
        "userName": "SQLPROXY",
        "userId": "5801ea43-a1c4-4553-ab6e-720eb206938f",
        "host": "10.20.42.35",
        "hostName": "ORACLE 12.1 NEW",
        "startTime": 1737357272465,
        "endTime": null,
        "globalUserName": null,
        "clientIp": "10.20.42.57",
        "instanceName": "ceydauluturk",
        "accessProtocol": "ORACLE_TNS",
        "reasonForConnection": null,
        "tenantId": null,
        "approvalId": null,
        "agentId": null,
        "idleDuration": null,
        "command4Search": null,
        "deviceGroups4Search": null,
        "recordLimit4Search": null,
        "videoAvailability": null,
        "sessionAudits": [],
        "sessionAudit": null,
        "remoteAppName": null,
        "remoteAppUser": null,
        "remoteAppDeviceIp": null,
        "isExactMatch4Search": null,
        "isJobOps": null,
        "hashInfo": null,
        "hashDate": null,
        "tamperProof": null,
        "ocrEnabledForDevice": null,
        "filterExactHost": null,
        "userFullName": "test test",
        "status": null,
        "firstResult": null,
        "maxResult": null,
        "tamperProofCheckEnabled": null,
        "currentTamperProofLogVersion": "v2",
        "negativeUsername4Search": false,
        "negativeHost4Search": false,
        "negativeDeviceGroup4Search": false,
        "syslogMap": {
            "sessionId": "657f1453-a4c1-4a3e-b094-8c6e02c5dd1e",
            "userName": "SQLPROXY",
            "userId": "5801ea43-a1c4-4553-ab6e-720eb206938f",
            "tenantId": null,
            "host": "10.20.42.35",
            "hostName": "ORACLE 12.1 NEW",
            "startTime": 1737357272465,
            "endTime": null,
            "globalUserName": null,
            "clientIp": "10.20.42.57",
            "instanceName": "ceydauluturk",
            "accessProtocol": "ORACLE_TNS",
            "totalDuration": -1,
            "idleDuration": null,
            "remoteApplicationName": null
        },
        "allowed4Search": null
    }
]