One of challenges in using Lansweeper is we don't care to report or see servers. But, inevitably servers show up as staff logs into servers. So, I found a work around to help us sort which workstations have not been scanned.
In our company, we use specific naming standards. All servers start with S all workstations start with W.
Here is a modified version of the "Never Scanned OS" report which will report on only those workstations beginning with W:
SELECT TOP (100) PERCENT dbo.tblComputers.Computername AS Computer, dbo.tblComputers.Username, dbo.tblComputers.Domain,
dbo.tblComputers.Firstseen AS [First seen], dbo.tblComputers.Lastseen AS [Last seen],
CAST(dbo.tblComputers.Lastseen - dbo.tblComputers.Firstseen AS bigint) AS [days alive]
FROM dbo.tblComputers LEFT OUTER JOIN
dbo.tblOperatingsystem ON dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername
WHERE (dbo.tblOperatingsystem.Computername IS NULL) AND (dbo.tblOperatingsystem.Computername LIKE 'W%')
ORDER BY dbo.tblComputers.Domain, [days alive] DESC
