Need help with report

[rberg]

I am not too good with sql. We have multiple IP locations and would like a report can pull information from a defined ip location and give the following information:

Asset Name
IP Address
Mac address for above IP address
Type
manufacturer
Model
Serial
last seen
custom field 1
custom field 2
custom field 3

[Hemoco]

A sample report can be seen below. You can filter the IP location within the report results.

Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysIPLocations.IPLocation,
tblNetwork.IPAddress,
tblNetwork.MACaddress,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Serialnumber,
tblAssets.Lastseen,
tblAssetCustom.Custom1,
tblAssetCustom.Custom2,
tblAssetCustom.Custom3
From tblAssets
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Left Outer Join tsysIPLocations On tblAssets.IPNumeric >=
tsysIPLocations.StartIP And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Inner Join tblNetwork On tblAssets.AssetID = tblNetwork.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblNetwork.IPEnabled = 1 And tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName