Routine~11min

The Lapsed Licence

A customer reported they could still access pro features even though their subscription expired months ago. Turns out a renewal job failed silently and never flipped those licences to expired. 14 licences show status=active but their expiry date is in the past. Nine others are correctly in grace_period — those aren't the problem.

Tables you'll query

userslicenses

What you'll learn

SELECT & FilteringDate & Time Functions
Investigate this case →