LastLogon Report for AD LastLogonTimestamp and Exchange OnPremise Attributes

Question

Hi, as I am not that good in writing custom reports I wanted to ask if its possible to get a report that can be configured for different time ranges (30, 60, 90 etc.. days) for showing inactive accounts. There is already a report, but it just involves the LastLogonTimestamp attribute. There are occasions where this is not updated, but the mailbox is still in use.

Could you give me a hint or an custom report for this?

Thank you very much in advance!

Answer 1

Hello,

When a user signs in to the on-premises Exchange mailbox, the lastLogonTimestamp and lastLogon properties of the corresponding on-premises user are updated. The Inactive users built-in report (located in the Reports/All Reports/Users container by default) considers the following properties when determining whether the user is inactive:

• whenCreated
• lastLogonTimestamp
• lastLogon
• pwdLastSet

As such, the Inactive users report takes into account sign-ins to the on-premises Exchange mailboxes.