SQL Aggregation error and tables

Identity Security Cloud (ISC) ISC Discussion and Questions
1

Hi

We are having the following issue.

We can connect to the MSSQL database(2019) via a direct connection(Microsoft SQL Server) the problem is we only see 2 service accounts in the database when we aggregate

When we use a third party (DBeaver) tool (using the same account) we can see the 2 tables with the users and details and the entitlements in it.

So I think it is not a rights issue
The tables were created for the solution were users and entitlements are stored in

Any ideas on resolving this?

2

If it’s not a rights issue, then it might be an incorrect SQL query used in the account aggregation operation. For reference, here are the docs for JDBC connectors.

3

Came here to make the same suggestion. It’s hard to be faster than @colin_mckibben though!