Dynamics CRM – 获取用户最后一次登录时间

方式1 Power Platform管理中心

通过Power Platform管理中心的 “分析”

方式2 FetchXML

制作SSRS报表，FetchXML如下

<fetch aggregate="true">
  <entity name="audit">
    <attribute name="createdon" alias="LastLoginDate" aggregate="max" />
    <filter>
      <condition attribute="operation" operator="eq" value="4" />
    </filter>
    <link-entity name="systemuser" from="systemuserid" to="objectid" link-type="inner" alias="SystemUser">
      <attribute name="fullname" alias="FullName" groupby="true" />
      <attribute name="domainname" alias="DomainName" groupby="true" />
      <attribute name="isdisabled" alias="IsDisabled" groupby="true" />
      <attribute name="accessmode" alias="AccessMode" groupby="true" />
      <attribute name="userlicensetype" alias="UserLicenseType" groupby="true" />
    </link-entity>
  </entity>
</fetch>

方式3 SQL

在XrmToolBox里使用“SQL 4 CDS”进行查询，SQL如下

SELECT   MAX(audit.createdon) AS LastLoginDate,
         SystemUser.fullname AS FullName,
         SystemUser.domainname AS DomainName,
         SystemUser.isdisabled AS IsDisabled,
         SystemUser.accessmode AS AccessMode,
         SystemUser.userlicensetype AS UserLicenseType
FROM     audit
         INNER JOIN
         systemuser AS SystemUser
         ON audit.objectid = SystemUser.systemuserid
WHERE    audit.operation = 4
GROUP BY SystemUser.fullname, SystemUser.domainname, SystemUser.isdisabled, SystemUser.accessmode, SystemUser.userlicensetype;

备注

1.如果使用方式2或方式3，需开启“审核功能”

2.Operation Choices/Options