Lansweeper Classic Report Builder (SQL)

Turns an inventory or helpdesk question into a correct, ready-to-paste T-SQL report for Lansweeper Classic’s on-prem database — no more guessing table and column names.

The Lansweeper Classic Report Builder skill writes, fixes, and explains SQL reports for Lansweeper Classic’s on-prem SQL Server database. It draws on the full 735-table schema (columns, primary/foreign keys) plus a library of ready-to-adapt example reports to produce idiomatic queries — the clickable-asset pattern, icon columns, active-state filtering, and the standard location/OS joins that make a report feel native to the console. It works from a plain-language question, a pasted query that needs fixing or explaining, or a request to adapt a known pattern (assets by OS, missing patches, warranty expiry, EOL software, and more). This is for Lansweeper Classic (on-prem) only — not Cloud/Sites or the MCP data connectors.

image 159

Why Report Builder Matters Here

  • IT perspective

    “I need a report that answers this specific inventory question, right now.”
    Schema lookup: the right joins and exact column names across 735 tables, without guessing.
    Idiom: clickable assets, icon columns, and active-state filtering that feel native to the console instead of a raw SQL dump.

  • Security perspective

    “Can this surface risk — EOL software, missing patches, stale scans — not just inventory counts?”
    Built-in patterns: EOL tiering with red/amber/green row coloring, version-comparison logic for out-of-date software, scan-freshness warnings.
    Reuse: these are documented, ready-to-adapt patterns (the “how real published reports are built” conventions), not something built from scratch each time.

Requirements

Lansweeper plan

Lansweeper Classic (on-prem) installation with Report Builder access.

LLM

Claude 3.5+, Gemini, ChatGPT, Copilot

Step by step setup guide

Step 1 — Download
Download the skill package for your platform. Select Claude, ChatGPT, Gemini, or Copilot and the corresponding package downloads automatically.

Step 2 — Install

  • Claude: install as a plugin/skill in Claude Desktop or Code.
  • ChatGPT: install as an app.
  • Gemini (Antigravity): load it into your agent’s skill folder.
  • Copilot: import it as a solution in Power Platform / Copilot Studio — this creates the “LS Classic Report Builder” agent, with an MS Teams channel already configured.

Step 3— Ask

  • Claude: “write a report showing all Windows assets with disk space under 10%.”
  • ChatGPT: “fix this Lansweeper report, it’s not filtering out decommissioned assets” (paste the query).
  • Gemini (Antigravity): “give me a report of software installs older than the current version.”
  • Copilot: “show me all servers past their OS end-of-life date” in the agent’s chat or in Teams.
Related Skills
See all skills