‎03-05-2012 10:47 PM
Solved! Go to Solution.
‎03-06-2012 01:40 PM
kamranfalahat wrote:
As a part of the requirement, I need to figure out to show the number of monitors connected to every machine.
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, Count(tblMonitor.MonitorID) As [Monitor Count]
From tblComputers Inner Join
tblMonitor On tblComputers.Computername = tblMonitor.Computername
Group By tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain
Order By tblComputers.ComputerUnique
‎03-15-2012 10:44 PM
‎03-06-2012 01:40 PM
kamranfalahat wrote:
As a part of the requirement, I need to figure out to show the number of monitors connected to every machine.
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, Count(tblMonitor.MonitorID) As [Monitor Count]
From tblComputers Inner Join
tblMonitor On tblComputers.Computername = tblMonitor.Computername
Group By tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain
Order By tblComputers.ComputerUnique
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now