UDT Endpoints Not Seen in 30 Days

What this query does

Identify stale endpoint records that have not connected in 30+ days for cleanup

SWQL Query

SELECT IPAddress, MACAddress, Hostname, ConnectedTo,
       VLANId, LastSeen, FirstSeen
FROM UDT.Endpoints
WHERE LastSeen < ADDDATE('day', -30, GETDATE())
ORDER BY LastSeen ASC

UDT

stale endpoints

cleanup

inventory

Source:POLARISNOC· POLARISNOC Original

Unlock the full POLARISNOC hub

AI-powered SWQL generation, script management, CVE tracking, and verified solution intelligence.