We cannot as the Audit Table is not available Update – - Just checked it- Audi Table is available in SQL 4 CDS so ignore the below detailsĬ an we use the new SQL Data Connection for CDS (preview) to query Audit information ? We can also use the wonderful User Audit Viewer XrmToolBox Plugin for getting the user audit details. WHERE su.systemuserid IN (SELECT systemuserid Now there could be some users who have never accessed the application, to get details of those user we can use the below query GROUP BY su.fullname, su.domainname, su.userlicensetype, su.accessmode, su.isdisabled We can also run the following SQL Query (in case of on-premise) to get the details We can use below FetchXML query to get the same details This view can be filtered to show only the User Access via Web event to get the last logon details for the users. Some of these details can also be captured by enabling Audit user access. through Command Data Service Analytics (formerly Organization Insights). We can get the different metrics about the usage of the platform like active user usage, the operation performed, the entity used, plugins and API statics, etc.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |