cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
faccount
Engaged Sweeper
Hi,

i need a report that will display the number of computer models per department so like


Marketing -> HP 7100 (26)
HP 7600 (43)

Finance -> Hp 7100 (12)
HP 7600 (17)



Etc.


maybe even better if possible break it down by like

Marketing -> HP (69) then when you click on the hp it breaks down the individual models and number of those models.


Thanks for any help
1 REPLY 1
Hemoco
Lansweeper Alumni
try this:

Select top 1000000 tblCompCustom.Department, tblComputerSystemProduct.Vendor,
tblComputerSystemProduct.Name, Count(tblComputers.Computername) As Total
From tblComputers Left Join
tblCompCustom On tblComputers.Computername = tblCompCustom.Computername
Inner Join
tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername
Group By tblCompCustom.Department, tblComputerSystemProduct.Vendor,
tblComputerSystemProduct.Name
Order By tblCompCustom.Department, tblComputerSystemProduct.Vendor,
tblComputerSystemProduct.Name