Export both lists on the same date and use the same UPN format. Review absent, inactive and duplicated assignments separately, since a service account may be absent from an HR roster for a valid reason. Confirm the dependent workloads before reclaiming any licence.
Prepare your inputs
Export a roster and a licence assignment list with a common UPN or email address.
Worked example
A licence assigned to an inactive user is a review item. A shared mailbox or service account can have a valid exception.
Review before you use the result
Confirm workloads, retention and account ownership before removing any licence.


