|Applies To||RSA Authentication Manager 6.1|
Authentication Manager 6.0
RSA ACE/Server 5.2
RSA ACE/Server 5.1
Custom SQL Query
|Issue||Custom Query which obtains information from multiple tables|
Invalid select statement.
A customer desires to create a report which lists information about a user including custom user extension data and token information, for example:
Login Last First Token Personal data
The SQL statement they have tried generates an "Invalid select statement." when they press the Check Syntax or Next> buttons
The query needs to be able to extend across three different tables in the database since not all the information is held in a single table. This means that a query must be devised with obtains data from each place and then combines it as required.
An example of a valid query could be:
SELECT chDefaultLogin, chLastName, chFirstName, chSerialNum, chKey, chData
Note that this will actually generate multiple lines if a user has been assigned more than one token; also there are many other way to use SQL to obtain the desried ouput - this simply demonstrates one particular way.
In general it is important to consider how you use SQL; on large databases it is possible to write a badly formed SQL statement which is valid but will consume all the memory of a computer when executed. SQL specialists (not part of RSA) will know many ways in which SQL statements should be optimized for maximum efficiency.
RSA will be happy to assist in the design of specific custom queries to meet customer requirements; however this is a chargeable service from RSA Professional Services who will be able to quote charges for the desired ad-hoc work.
Other useful knowledgebase articles on the subject may be found at:
A custom query which obtains information from multiple tables A custom query which obtains information from multiple tables
A variety of manuals are referenced in this solution, copies are supplied with the software and online copies are available in RSA SecurCare Online.
Authentication Manager 6.1 Administration Toolkit Reference Guide
Authentication Manager 6.0 Administration Toolkit Reference Guide
ACE/Server 5.2 Administration Toolkit Reference Guide
ACE/Server 5.1 Administration Toolkit Reference Guide
|Legacy Article ID||a33139|