Active Directory: Count of Users Whose Last Login is within 30 Days Ago
submitted
A
Addison Caldwell
This is helpful to someone who's trying to obtain/maintain visibility into a count of stale/inactive users at an organization. This is a good Metric for QBRs or recurring site reviews. Also, this Metric could be used to build a user audit with the intention of an end customer confirming that all looks as expected.
Users[? DaysSinceLastLogin <
31
&& UserStatus == Active
&& DaysSinceLastLogin != null
&& Email !=null
] | length(@)