Query For The User Count In The Dynamics CRM On-Premise Adapter
Article ID: KB0078677
Updated On:
| Products | Versions |
|---|---|
| TIBCO Scribe Insight | - |
Description
To determine the number of users within your Microsoft Dynamics CRM on-premise database that the Insight Adapter for Dynamics CRM counts, connect to your on-premise database using SQL Server Management Studio, and run the following SQL query:
SELECT count(*) FROM systemuserbase WHERE setupuser = 'false' AND isdisabled = 'false' AND (accessmode = 0 OR accessmode = 3)
For additional information, see the following in the Scribe Insight Help: How The Adapter Counts Users
For additional information, see the following in the Scribe Insight Help: How The Adapter Counts Users
Issue/Introduction
Determine the number of users in your Microsoft Dynamics CRM on -premise database.
Feedback
Yes
No
Powered by
