SQL Server statement tracing
For RSA Key Manager 2.0.x
If you need to look at the SQL statements generated by Key Manager Server, use SQL Server Profiler.
Start Microsoft SQL Server SQL Profiler
Create a new trace
Click on the "Event Selection" tab
Check "Show all columns"
Select the event "Stored procedure -> RPC:Completed" and select only the columns "TextData", "DatabaseName" and "StartTime".
Click on "Column filters"
Select "DatabaseName"
Expand 'Like' and type (with no quote)
"kmsDataStore" for 2.0.x Key Manager Server
"RKM" for 2.1.x Key Manager Server
Select "TextData"
Expand 'Like' and type (with no quote)
"declare%"
Click Ok
Click Run
Now all requests to the database will be logged. Use the pause and clear buttons to manage the trace.
If you have to view only GetKeyByID requests, use the following TextData Filter if you are using RKM Server 2.0.x:
declare%FROM CryptoKeys, Ciphers, KeyClass, ApplicationGroup WHERE CryptoKeys.keyClass = @P0 AND CryptoKeys.keyID = @P1%
For RSA Key Manager 2.7
Start Microsoft SQL Server SQL Profiler
Create a new trace
Click on the "Event Selection" tab
Check "Show all columns"
Select the event "Stored procedure -> RPC:Completed" and select only the columns "TextData", "DatabaseName" and "SPID".
Click on "Column filters"
Select "DatabaseName"
Expand 'Like' and type (with no quote)
"RKM"
Select "TextData"
Expand 'Like' and type (with no quote)
"declare%"
Click Ok
Click Run
Related Articles
No SQL Strategy found for SQL statement: Execute CreateAccount when using a Generic Database AFX connector in RSA Identity… 52Number of Views Slow INSERT statement executing from the SoD_Rule_Pkg in RSA Identity Governance & Lifecycle 115Number of Views Microprocessor Side-Channel Vulnerabilities (CVE-2018-3639 and CVE-2018-3640): Impact on RSA products 96Number of Views CERT/CC Vulnerability Note VU#475445: Potential Impact on RSA Products 32Number of Views Important Statement from RSA Regarding RSA SecurID Software Token Provisioning Best Practices 102Number of Views
Trending Articles
RSA Authentication Manager 8.9 Patches and Hotfixes Readme RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA-2026-24: RSA Authentication Manager Security Update for Third-Party Component Vulnerabilities IDR SSO - Step 3: Deploy the Identity Router RSA Authentication Manager 8.9 Setup and Configuration Guide