→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
‎09-23-2010 12:34 AM
‎09-23-2010 11:07 AM
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, Count(tblMonitor.MonitorID) As Total
From tblComputers Inner Join
tblMonitor On tblComputers.Computername = tblMonitor.Computername
Group By tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain
Having Count(tblMonitor.MonitorID) > 1
Order By tblComputers.ComputerUnique
‎09-23-2010 11:07 AM
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, Count(tblMonitor.MonitorID) As Total
From tblComputers Inner Join
tblMonitor On tblComputers.Computername = tblMonitor.Computername
Group By tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain
Having Count(tblMonitor.MonitorID) > 1
Order By tblComputers.ComputerUnique
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now