30% of hardware assets in mid-market organizations are 'ghost assets' — present on the books but physically gone or undiscoverable. The reverse is just as bad: laptops and servers in use but never registered. Physical reconciliation paired with auto-discovery is the only fix.

Without a structured workflow, hardware data lives in purchasing files, the service desk and finance — none of which reconcile. Inventory drift reaches 15-30% within months of a manual audit, inflating insurance and taxes by 10-20%.

Utilyx models hardware inventory as an executable decision tree with auto-discovery, structured registration, ghost-asset reconciliation and a live status dashboard — buildable by an IT manager without coding.

The workflow is structured as a decision tree with 4 main branches (Discovery, Registration, Reconciliation, Reporting) running on each scan cycle, with parallel enrichment sub-branches and 7 steps end-to-end. Every step is executed by a named actor (Discovery Agent, AI Copilot, IT Manager, Logistics) and every action is appended to the timeline_asset audit subtable.

• Step 1 (Start — Discovery Agent): the sql-query auto-discovery scan runs against the network and enrolled endpoints, returning raw device signals (hostname, ip_address, mac_address, os, serial_number, make, model). The AI Copilot normalizes and deduplicates the raw feed.

• Step 2 (AI Copilot classification): the Copilot assigns category (laptop / server / mobile / peripheral) and criticality (low / medium / high) from usage signals, then splits the tree — Branch A (new device, no serial match in catalog): route to Registration; Branch B (known device, serial_number matches): route to Reconciliation.

• Step 3A (Registration — IT Manager): new assets are registered with fields serial_number, make, model, purchase_date, purchase_cost, category, criticality, assigned_site, owner, status='available' — validated by the workflow. Sub-branch: if purchase_cost is missing, hold + procurement query.

• Step 3B (Reconciliation — AI Copilot): known devices are compared to the catalog record. Sub-branch B1 (match): update last_seen timestamp and status; Sub-branch B2 (catalog record but not discovered = ghost asset): create enrichment task; Sub-branch B3 (discovered but no catalog record = rogue device): create registration task + security alert.

• Step 4 (Status tracking): each asset moves through statuses — assigned, available, in_repair, retired — with transitions triggered by service-desk events and validated via sql-query on the asset_status table.

• Step 5 (usePDF asset report): usePDF generates a formatted hardware inventory report (counts by category, status, site, owner) for audits, insurance and finance — available in 7 languages.

• Step 6 (useArchive): useArchive stores every inventory snapshot in a tamper-evident archive with index fields asset_id, serial_number, category, site, status, scan_date for the legal retention period.

• Step 7 (Dashboard): a live dashboard renders asset counts by category, status, location and owner — refreshed in real time from the catalog table.

Teams that deploy Utilyx reach 98% inventory accuracy within the first month, cut ghost assets from 30% to under 3% (a 90% reduction), eliminate the annual physical audit (saving ~120 hours/year) and reduce insurance/tax overpayment by 15% through real-time reconciliation.

The no-code designer and AI copilot let an IT manager build the full discovery-to-dashboard workflow in a single session — no consultants, no scripting, at 70% lower TCO than legacy ITAM suites. Reconciliation runs on every scan cycle, so drift is corrected continuously, not annually.