Finance | Project Operations, Human Resources, ...

How to report D365FO system users and last time each logged in?

(0) Share

Report

Posted on by Ian Waring

436

We know there is a report that does this - if you have Public Sector enabled (we don't and expect it to do unwanted changes to our system if we enable it). Or you can look at the user log (System Admin > Enquiries > System Users) but this just lists each login event - and I can't find a location where I can query this data, merge with the user list and expose everyone who's not logged on in the last three months.

Is there a more systematic way of exposing which users haven't logged in during the last 4 weeks (or any other time period)?

I have the same question (0)

All responses (6)

Answers (0)

WillWU 22,361 on at

Like (0)

Report

Hi Ian Waring,

I think you have thought of all the possibilities, the most systematic way would be the Dormant User Account Reporting that exists in the system.

If you cannot activate the "Public Sector" license configuration for some reason, you could simply download the user log from the system, and play with data in Excel to get what you want.

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (0)

Report

Hi Ian,

The Dormant user security accounts report mentioned by Will is available without public sector enabled and would meet your requirement. You can specify the number of inactive days on the parameters of the report.

Was this reply helpful? Yes No
Ian Waring 436 on at

Like (0)

Report

Thank you - though this doesn't appear in any of the menus nor in feature management on D365FO 10.0.20...

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (0)

Report

Hi Ian,

Please check again. The report is added a long time ago and should be visible in your environment. For the exact location, see next screenshot:

Was this reply helpful? Yes No
Ian Waring 436 on at

Like (0)

Report

Was this reply helpful? Yes No
André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (0)

Report

Hi Ian,

My bad... I have checked the properties. This report is linked to the Public sector features.

The report is getting the last login from the standard table SysUserLog. If you don't want to enable the public sector features, you can use this table for retrieving the login details.

Was this reply helpful? Yes No