Data Acquisition

SCIM Connector accesses data from Secret Server through reports. The following reports are added to Secret Server and should not be modified unless instructed to by Delinea Support or Professional Services. If these reports do not appear in Secret Server or SCIM Connector is not able to retrieve the appropriate data, these reports can be manually created by a secret server administrator. The SQL for the report can be found in \SCIMConnector\SqlQuery directory. Do not modify the SQL in these files unless instructed to by Delinea Support or Professional Services.

  • “SCIM All Users”:

  • “SCIM All User Groups”:

  • “SCIM All Groups”:

  • “SCIM All Folders”:

  • “SCIM All Secrets”:

  • “SCIM All Folders Permission”:

  • “SCIM All Secrets Permission”:

  • “SS Report All Role”:

  • “SS Rerport All User Roles”:

  • To fetch disabled users and groups from Postman, remove Enable=1 and Active=1 checks from the report SQL script created in Secret Server.

  • To fetch disabled users in Secret Server, modify the SCIM All Users and SCIM All User Groups report scripts. Additionally, modify the groups in the SCIM All Groups report script..

  • To fetch users who have no Email ID from postman, remove the isnull([EmailAddress],'')!=" check from the report SQL script which is created in Secret Server.

  • To fetch users who have no Email ID, the change is required in SCIM All Users and SCIM All User Groups report script in Secret Server.

  • To distinguish between local and domain users the SQL queries of SCIM All Users and SCIM All Groups reports on Secret Server have been updated.

  • We have also updated the SCIM_ALL_USER_GROUPS and SCIM_ALL_USER_ROLES reports to remove the system users and groups from the results of these queries.

The SQL for the reports can be found in C:\inetpub\wwwroot\SCIMConnector\SqlQuery directory.

Update SQL Script in Secret Server

To update the report SQL script in Secret Server, follow these steps:

  1. Open Reports in Secret Server.
  2. Update and click on the SCIM report.
  3. Click Edit.
  4. In Report SQL text-area field, update the SQL script and click Save.

You must keep the same clause conditions in both SQL scripts (ALL User and All User Groups) reports because the data will be mismatched, and you won’t get the correct data from the SCIM Endpoint.