US - Illinois - Chicago - CRM

Expand all | Collapse all

Determine license count for active users

  • 1.  Determine license count for active users

    GOLD CONTRIBUTOR
    Posted Mar 25, 2019 04:39 PM
    Hello,
    I would like to know how many active licensed users we have in the on-premise Dynamics CRM 2016 environment
    When I look in the deployment manager, it shows a number next to the field "Professional CALs required." Everything else is 0, other than server count.
    Is "Professional CALs required" the count of current users now or current users available to be consumed?

    Thanks

    ------------------------------
    Rod Carlson
    Database Administrator
    Chicago White Sox
    Chicago
    ------------------------------


  • 2.  RE: Determine license count for active users

    TOP CONTRIBUTOR
    Posted Mar 26, 2019 09:36 AM
    Ron,

    I check this every month with an Advanced Find on the User entity and I check for status is enabled.  Then I display the License Type (Professional, Basic, etc.) and the Access-Mode (Read-Write, Read Only, etc.).  This helps me ensure that we stay in compliance as we onboard and offboard people from our system.

    Donna

    ------------------------------
    Donna Liotta
    Manager Business Applications
    National Safety Council
    Itasca IL
    ------------------------------



  • 3.  RE: Determine license count for active users

    GOLD CONTRIBUTOR
    Posted Mar 26, 2019 11:02 AM
    Perfect. Thanks!!

    ------------------------------
    Rod Carlson
    Database Administrator
    Chicago White Sox
    Chicago
    ------------------------------



  • 4.  RE: Determine license count for active users

    TOP CONTRIBUTOR
    Posted 22 days ago
    Donna i need this as well as the last login date and if possible Activity of each user on the system.  Do you know how I can get that?

    Please advise.

    Neal Folgers

    ------------------------------
    Neal Folgers
    Chicago Chapter Leader
    (815)718-3459 (Mobile)
    ------------------------------



  • 5.  RE: Determine license count for active users

    TOP CONTRIBUTOR
    Posted 22 days ago
    Neal,

    I haven't figured out how to determine what activity a user has done other than looking for specific records with a specific user as the last modified by.  That only works if no one modified it after they touched it.  I found a sql query for last login that I found online a while ago.  It is a select against the SystemUser table and the Audit table.  I don't remember who published it online and I may have tweaked it a bit since then (or not) but it has given me what I need to know about who is actually using CRM.

    select select    a.CreatedOn,  a.Action,  a.USERID,  a.OBJECTID,  a.ObjectTypeCode,  u.fullname,  u.isdisabledfrom Audit a join SystemUser u on a.objectid = u.systemuserid where ( u.FullName is not NULL  and u.IsDisabled = 0  and a.Action is not NULL  and a.CreatedOn > '2018-01-01' )Order By a.CreatedOn ASC, u.FullName ASC

    - Donna

    ------------------------------
    Donna Liotta
    Manager Business Applications
    National Safety Council
    Itasca IL
    ------------------------------



  • 6.  RE: Determine license count for active users

    TOP CONTRIBUTOR
    Posted 22 days ago
    Thank You Donna!!

    ------------------------------
    Neal Folgers
    Chicago Chapter Leader
    (815)718-3459 (Mobile)
    ------------------------------



  • 7.  RE: Determine license count for active users

    GOLD CONTRIBUTOR
    Posted 21 days ago
    Similar to logins, does anyone know if the following 'audit' info is accessible and if there is a SQL query that can get at it:
    1) user generation of reports
    2) user exports of views to excel

    This would be as part of data protection efforts to know if/when someone accessed sensitive data and may have extracted it out of D365 CRM.

    ------------------------------
    John Cisek
    Director, Operations
    Family Office Exchange
    Chicago IL
    ------------------------------



  • 8.  RE: Determine license count for active users

    TOP CONTRIBUTOR
    Posted 21 days ago
    I know there is a query (I found it on a web search) that will tell you the last time a report was run and I think you can tell who ran it if the report runs as calling user.  Some of our reports run at elevated permissions and that would report out as "System" as the user. I think it also would include CRM Wizard reports since they are running FetchXML and show up in the reports list, but I have not specifically looked for that. I was using it to try to identify if we could retire any unused SSRS reports.

    I've not seen anything to identify who is running advanced finds or what those advanced finds were.  This is a really good question and I would love to see the answer to0.

    Donna

    ------------------------------
    Donna Liotta
    Manager Business Applications
    National Safety Council
    Itasca IL
    ------------------------------



  • 9.  RE: Determine license count for active users

    GOLD CONTRIBUTOR
    Posted 20 days ago

    Check this out…it answers my original question.

    https://docs.microsoft.com/en-us/power-platform/admin/enable-use-comprehensive-auditing

    An office 365 Enterprise E3 or E5 license is required to do Activity Logging, including D365 activities.   There is a list of events that are audited, and it includes Exports to Excel and Report Viewer exports.  If you have the right license, you can review the audit data in the O365 Security and Compliance Center.

    "To turn it on, click Start recording user and admin activity on the Audit log search page in the Security & Compliance Center."



    ------------------------------
    John Cisek
    Director, Operations
    Family Office Exchange
    Chicago IL
    ------------------------------



  • 10.  RE: Determine license count for active users

    TOP CONTRIBUTOR
    Posted 19 days ago
    Donna how do i run this SQL??

    ------------------------------
    Neal Folgers
    Chicago Chapter Leader
    (815)718-3459 (Mobile)
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role