Showing results for 
Show  only  | Search instead for 
Did you mean: 
Engaged Sweeper
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


Hello everyone,
Due to the age of this post, it has been archived. Please feel free to start a new post if you wish to continue to discuss this topic.
Thank you for understanding.