The Scenario
Someone on the IT security team flagged that two machines are still reporting VS Code version 1.78 — an editor version that predates the security patch your team rolled out six months ago. You need to know which machines are still on unsupported editors, and which developers they belong to.
You have access to the WakaTime admin account for the team. There are 15 developers. You are not going to message each one individually.
The bad version:
- You log into WakaTime, navigate to the user agents section, and try to read machine and editor data off a dashboard not built for bulk review.
- You screenshot the relevant rows, paste them into a Slack message for the security team, realize you forgot three machines, and have to go back.
- WakaTime does not let you export machine data as a CSV directly from the UI, so you end up copying rows manually into Excel.
The security audit deadline is end of week. You have 12 other tickets open. This should not be a half-day task.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the workbook, understands what you are looking at, and through its built-in WakaTime integration it pulls machine and editor data directly — no dashboard screenshotting, no manual row copying.
Open a new workbook and paste this:
Get all WakaTime user agents and machines for my account and populate this Excel sheet with Machine, Editor, Plugin Version, Last Active Date
What You Get
- One row per machine WakaTime has seen on the account.
- Machine name as WakaTime recorded it (usually the hostname).
- Editor name and plugin version in separate columns — ready for the security audit form.
- Last Active Date as a date, so you can sort by staleness immediately.
What If the Data Is Not Quite Ready
You want to flag machines inactive for more than 90 days
Your team decommissions machines after 90 days of no activity:
Fetch my WakaTime machine list. For each machine, if Last Active Date is more than 90 days before today, write "STALE" in a Status column. Otherwise write "Active." Fill this workbook with Machine, Editor, Plugin Version, Last Active Date, Status.
You only want machines running VS Code
You need to isolate VS Code machines for the patch audit:
Fetch WakaTime user agents. Filter to only machines where the editor name contains VS Code. Fill this workbook with Machine, Last Active Date, Plugin Version — sorted by Plugin Version ascending so oldest versions appear first.
You want to flag outdated plugin versions automatically
Your security threshold for VS Code is version 1.79.0:
Fetch WakaTime user agents filtered to VS Code only. Add a Patch Status column: write "OUTDATED" if Plugin Version is below 1.79.0, otherwise "Current." Fill this workbook with Machine, Last Active Date, Plugin Version, Patch Status.
Full audit table with staleness flags and patch status in one pass
Fetch all WakaTime machines and user agents. Keep only rows where the editor is VS Code. Add a Patch Status column: "OUTDATED" if Plugin Version is below 1.79.0, otherwise "Current." Add a Staleness column: "STALE" if Last Active Date is more than 90 days ago, otherwise "Active." Sort by Patch Status then Staleness. Fill this workbook starting at row 2 with Machine, Last Active Date, Plugin Version, Patch Status, Staleness.
The security team gets a single table they can filter without asking you to re-run anything.
Try It
Get the 7-day free trial of SheetXAI and open a new worksheet in your toolchain audit workbook — ask it to pull your team's WakaTime machine and editor list, flag stale machines, and sort by plugin version so the oldest installs surface first. See also how to analyze developer productivity patterns from WakaTime in Excel, or return to the WakaTime integration overview.