000022475 - Custom SQL query for reporting all agent hosts and associated IP addresses including secondary nodes in RSA ACE/Server and RSA Authentication Manager

Document created by RSA Customer Support Employee on Jun 16, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000022475
Applies ToRSA ACE/Server 5.2
RSA Authentication Manager 6.0
RSA Authentication Manager 6.1
IssueCustom SQL query for reporting all agent hosts and associated IP addresses including secondary nodes in RSA ACE/Server and RSA Authentication Manager
How to generate list of IP addresses in RSA ACE/Server database to help avoid duplication and failure to add new agent host
ResolutionA custom SQL query can be written to achieve the desired output. Here is the SQL query syntax:

SELECT SDClient.chName,

SDClient.chNetAddress,

SDSecondaryNode.chName,

SDSecondaryNode.chNetAddress

from SDClient

LEFT OUTER JOIN SDSecondaryNode ON SDClient.iClientNum = SDSecondaryNode.iClientNum ORDER BY SDClient.chName
Legacy Article IDa29317

Attachments

    Outcomes