→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
rsayeed
Engaged Sweeper
Can this be done? Thanks
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
Try this one:

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

View solution in original post

1 REPLY 1
Hemoco
Lansweeper Alumni
Try this one:

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