→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
danielk
Engaged Sweeper III
Hi There, how do I generate a report on Computers with more than one hard disk.
Thanks
1 ACCEPTED SOLUTION
Niko0
Engaged Sweeper III
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tblAssets.Username,
tblFloppy.Model,
tblAssets.Lastseen,
SubQuery1.HDDcount
From tblAssets
Inner Join tblFloppy On tblAssets.AssetID = tblFloppy.AssetID
Inner Join (Select Top 1000000 tblFloppy.AssetID,
Count(tblFloppy.floppyID) As HDDcount
From tblFloppy
Group By tblFloppy.AssetID) SubQuery1 On SubQuery1.AssetID = tblAssets.AssetID
Where SubQuery1.HDDcount > 1
Order By tblFloppy.Name

View solution in original post

1 REPLY 1
Niko0
Engaged Sweeper III
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tblAssets.Username,
tblFloppy.Model,
tblAssets.Lastseen,
SubQuery1.HDDcount
From tblAssets
Inner Join tblFloppy On tblAssets.AssetID = tblFloppy.AssetID
Inner Join (Select Top 1000000 tblFloppy.AssetID,
Count(tblFloppy.floppyID) As HDDcount
From tblFloppy
Group By tblFloppy.AssetID) SubQuery1 On SubQuery1.AssetID = tblAssets.AssetID
Where SubQuery1.HDDcount > 1
Order By tblFloppy.Name