Report request - OS, IPLocation, etc.

[jmje]

Hi, I'm looking to generate a site report that includes the following key information :

IP Location (from Asset Groups Page)
Asset Name
OS Type (windows, linux, mac, basically all of them, with the OS Version if possible.)
IP Address
Domain
Address width (32 or 64)
Manufacturer
Model
Serial Number
Last Seen

I can get all the Operating systems, but not the IPLocation, or vice versa. I can't seem to get both. Once I get the IPLocations working right, all I get is windows systems.

I have right clicked the link between tblAssets and tsysOS to "Select all rows from tblAssets", and it doesn't seem to give me linux boxes too.

Last version of code I played with that gives me all assets :

Select Top 1000000 tblAssets.IPAddress,
tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename As [Asset Type],
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssetCustom.Model,
tsysOS.OSname
From tblAssets
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Left Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssetCustom.State = 1
Order By tblAssets.IPAddress,
tblAssets.AssetName Desc

Last version that I was able to use, that gives me IPLocations :

Select Top 1000000 tsysIPLocations.IPLocation,
tblAssets.AssetID,
tblAssets.AssetName,
tblProcessor.AddressWidth,
tblAssets.Domain,
tblAssets.Description,
tblAssets.Lastseen
From tblAssets
Left Join tsysIPLocations On tblAssets.IPNumeric >= tsysIPLocations.StartIP
And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Inner Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID
Order By tsysIPLocations.IPLocation,
tblAssets.AssetName

This would be much easier if I could edit the reports in the dashboard under "IP Locations Overview" widget. Is that possible?


Thanks in advance!