When running the dbo.AGENT_BEHAVIOUR_LOG_1 in Endpoint Manager DB SQL Query, the IP_ADDR value results in an unknown value
search cancel

When running the dbo.AGENT_BEHAVIOUR_LOG_1 in Endpoint Manager DB SQL Query, the IP_ADDR value results in an unknown value

book

Article ID: 280966

calendar_today

Updated On:

Products

Endpoint Protection

Issue/Introduction

When running the dbo.AGENT_BEHAVIOUR_LOG_1 in Endpoint Manager DB SQL Query, the IP_ADDR value results in an unknown value

Resolution

  • From the table "dbo.AGENT_BEHAVIOUR_LOG_1" verified the value of IP address and confirmed that this is an expected behavior based on the character type used for "IP_ADDR" column.
  • If needed to fetch the IP address, it is suggested to use the views  "V_AGENT_BEHAVIOR_LOG" which has the column "IP_ADDR_TXT" that should provide the correct IP address.
Powered by Wolken Software