It is possible to put these fields in one report but then you will get too many duplicate rows. Therefore we have created three reports for you:
The will give you all memory information:
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Username,
tblAssetCustom.Serialnumber,
tblAssets.Processor,
tblPhysicalMemory.DeviceLocator,
tblPhysicalMemory.Capacity,
tblPhysicalMemory.Speed
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblPhysicalMemory On tblAssets.AssetID = tblPhysicalMemory.AssetID
The second report will give information about the hard disks:
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Username,
tblAssetCustom.Serialnumber,
tblAssets.Processor,
tblFloppy.Name,
tblFloppy.InterfaceType,
tblFloppy.Size
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblFloppy On tblAssets.AssetID = tblFloppy.AssetID
The third report will give you all network interfaces:
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Username,
tblAssetCustom.Serialnumber,
tblAssets.Processor,
tblNetwork.Description,
tblNetwork.MACaddress,
tblNetwork.DHCPenabled
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblFloppy On tblAssets.AssetID = tblFloppy.AssetID
Inner Join tblNetwork On tblAssets.AssetID = tblNetwork.AssetID