Inventory: four portals and a VLOOKUP versus one row per device
Before: device facts are trapped across four portals and stitched by hand with VLOOKUP. After: a read-only collector fuses them into one dated row per device you can slice.
Ketan Kamble
BEFORE · FOUR SCREENS + VLOOKUP
AFTER · ONE ROW PER DEVICE
STEP 1 · FACTS IN FOUR PLACES
FOUR SEPARATE PORTALS
Intune OS · Entra country · Notes warranty · Defender health
won’t combine
STEP 2 · THE MANAGER’S QUESTION
A SIMPLE ASK, NO SIMPLE ANSWER
“Dell · out of warranty · Madrid · Windows 10 — how many?”
4 filters, 3 exports
STEP 3 · STITCH IT BY HAND
=VLOOKUP
three exports, glued together
stale the moment you save
and it drifts out of date immediately
▶ Collect-InventoryAllDevices.ps1
read-only → dated snapshot → one row per device
ONE ROW · DATED SNAPSHOT
device · OS · country · warranty · Defender health
one row per device ·
dated · sliceable
Pause