Skip to content

Power BI

Teams Phone licenses, paid for and never used: the reclaim report

Cover: Teams Phone licenses that are paid for but unused — no number, no calls, disabled accounts

A Teams Phone license on a disabled account, a user with no number provisioned, or someone who hasn't made a call in 90 days is money leaving the building every month for nothing. The licensing blade will tell you a SKU is assigned; it won't tell you it's wasted. This read-only report joins license assignment to sign-in, Teams usage and the phone number — and tiers every licensed user by how reclaimable they are.

The read-only AI agent that can't touch your tenant

Cover: a read-only AI agent answering endpoint questions from sanitized snapshots, with no live tenant access

"How many devices fail Firewall in Finland?" "Which Lenovos are out of warranty in the Madrid office?" "Is Ollama installed anywhere, and is it approved?" You want to ask your fleet those questions in plain English and get an answer in seconds. The obvious way to build that — hand an AI model live access to Intune and Microsoft Graph — is also the most dangerous. This is the capstone of everything on this site: an AI agent for endpoint management that answers questions about your whole Intune fleet — and holds no access to any live system at all. (For how it compares to Microsoft's native Intune Copilot agents, jump to Where this fits.)

Who's running Ollama on your fleet? A read-only shadow-AI inventory

Cover: read-only shadow-AI inventory flagging unsanctioned local AI tools and leavers

Somewhere on your fleet right now, someone has quietly installed a local LLM. Maybe it's Ollama pulling a model, maybe LM Studio, maybe a coding assistant quietly indexing your repos into a local model that sits on the laptop — and never gets wiped when they leave. Intune won't tell you — it doesn't inventory "AI tools" as a thing. This is a scheduled, read-only collector that turns shadow AI into a governance report: who's running what, sanctioned or not, and the finding that should worry you most — leavers who still have it installed.

One row per device: building the inventory Intune won't hand you

Cover: joining scattered Intune, Entra, warranty and Defender data into one device inventory row

Every fleet question starts the same way — how many devices, running what, owned by whom, and where do they sit? Intune knows all of it. The problem is it knows each part in a different place: the OS on the device blade, the user's country in Entra, the warranty in a Notes field, the Defender agent in a security report. This is the read-only collector that joins them into one flat row per device you can actually slice.