→ 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: 
mbjhug
Engaged Sweeper
Select Top 1000000 tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.PurchaseDate,
tblAssetCustom.Warrantydate,
tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Memory,
tblDiskdrives.FileSystem,
tblDiskdrives.Freespace,
tblDiskdrives.Size,
tsysOS.OSname,
tsysOS.OScode As icon,
tblProcessor.Name
From tblAssetCustom
Inner Join tblAssets On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Inner Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID,
tsysOS




I'm trying to create a report for brand, model, processor, OS, memory, disk size, disk used, and age of device. When I run the report, there are multiple lines with same asset, but with different OS names for each line, all of which are repeated several times, then the entire chunk for that asset is displayed again, but without the file system or free space.

I'm very new to this so any help would be greatly appreciated!
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
You haven't linked tsysOS to anything. Please try the report below instead.
Select Top 1000000 tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.PurchaseDate,
tblAssetCustom.Warrantydate,
tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Memory,
tblDiskdrives.FileSystem,
tblDiskdrives.Freespace,
tblDiskdrives.Size,
tsysOS.OSname,
tsysOS.OScode As icon,
tblProcessor.Name
From tblAssetCustom
Inner Join tblAssets On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Inner Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID
inner join tsysOS on tblAssets.OScode = tsysOS.OScode

View solution in original post

1 REPLY 1
Hemoco
Lansweeper Alumni
You haven't linked tsysOS to anything. Please try the report below instead.
Select Top 1000000 tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.PurchaseDate,
tblAssetCustom.Warrantydate,
tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Memory,
tblDiskdrives.FileSystem,
tblDiskdrives.Freespace,
tblDiskdrives.Size,
tsysOS.OSname,
tsysOS.OScode As icon,
tblProcessor.Name
From tblAssetCustom
Inner Join tblAssets On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Inner Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID
inner join tsysOS on tblAssets.OScode = tsysOS.OScode