Excel
Copilot
ChatGPTAutomate
Intermediate·20 min
Track software license allocation and usage
Analyze license usage data to surface underused or over-allocated software licenses before the next renewal.
ClaudeUpdated Sep 30, 2026
Scenario
IT suspects the company is paying for licenses nobody uses.
Mission
Count how many licenses have gone quiet for 90+ days.
Start Files
| LicenseID | AssignedTo | DaysSinceLastLogin |
|---|---|---|
| LIC-3001 | Skyler Finch | 110 |
| LIC-3002 | Skyler Finch | 139 |
| LIC-3003 | Jordan Diaz | 103 |
| LIC-3004 | Quinn Ortega | 170 |
| LIC-3005 | Avery Chen | 122 |
Preview — first 5 rows of license-assignments.csv
Your task
- Filter the license list for anything with 90 or more days since the last login.
- Count how many licenses meet that threshold.
- Note which licenses are the strongest reclaim candidates for the next renewal.
Prompt idea:
Here is a license assignment export with days since each person's last login. How many licenses have gone 90+ days unused, and which ones are the clearest candidates to reclaim?
Check Your Result
How many licenses have gone 90 or more days without a login?
Need a hint?
Filter DaysSinceLastLogin >= 90 and count the rows.
Reveal Solution
The solution files contain the completed challenge. Review the approach to see if you missed any edge cases.
Related Workflows
WORK WITH LIMINALS
Make AI useful for your team.
Get practical help with AI consulting or ask about training courses for your team.