→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
oiverson
Engaged Sweeper
i was playing building a report and i was going along fine until i added some fields that created 18 records for each machine. i tried to back out of those fields, but they seemed to have stuck. i'm a complete idiot with SQL, so i was wondering if anyone saw anything glaring in my statement below.

i have no problem recreating the statement being careful to not hit those fields that i added (i think they were the ones just below the tbl. fields)


Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Username,
tblOperatingsystem.Organization,
tblBIOS.Manufacturer,
tblAssets.Description,
tblAssets.Processor,
tblProcessor.NumberOfCores,
tblAssets.Memory,
tblOperatingsystem.Caption,
tblOperatingsystem.ServicePackMajorVersion,
tblBIOS.SerialNumber,
tblAssets.IPAddress,
tblAssets.Lastseen
From tblAssets
Inner Join tblBIOS On tblAssets.AssetID = tblBIOS.AssetID
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Inner Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID
Inner Join tblDesktop On tblAssets.AssetID = tblDesktop.AssetID
2 REPLIES 2
oiverson
Engaged Sweeper
thanks!
poweld1
Champion Sweeper
Put Distinct in the first line, i.e. Select Distinct Top 1000000 tblAssets.AssetID,