cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
EtienneHB
Engaged Sweeper II
I all, I have the following reports that show all my equipment in a IP range. I would like to see childs of these assets on a second line.

EX:
COM-001 (that have the Monitor-001 linked to it)
Mon-001
...

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssets.IPAddress Like '192.168.105%' And tblAssetCustom.State = 1
0 REPLIES 0