→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
‎06-23-2016 04:02 PM
Solved! Go to Solution.
‎07-04-2016 02:34 PM
Select Top 1000000 tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tblAssets.IPAddress,
tsysAssetRelationTypes.Name As [Relation Type],
tblAssets1.AssetName As [Child Asset],
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetID,
tblAssets1.IPAddress As [Child IP Address]
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblAssetRelations
On tblAssets.AssetID = tblAssetRelations.ParentAssetID
Inner Join tsysAssetRelationTypes On tblAssetRelations.Type =
tsysAssetRelationTypes.RelationTypeID
Inner Join tblAssets tblAssets1 On tblAssets1.AssetID =
tblAssetRelations.ChildAssetID
Where tsysAssetRelationTypes.Name Like 'Replicating To %' And
tblAssetCustom.State = 1
‎07-07-2016 10:22 PM
‎07-04-2016 02:34 PM
Select Top 1000000 tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tblAssets.IPAddress,
tsysAssetRelationTypes.Name As [Relation Type],
tblAssets1.AssetName As [Child Asset],
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetID,
tblAssets1.IPAddress As [Child IP Address]
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblAssetRelations
On tblAssets.AssetID = tblAssetRelations.ParentAssetID
Inner Join tsysAssetRelationTypes On tblAssetRelations.Type =
tsysAssetRelationTypes.RelationTypeID
Inner Join tblAssets tblAssets1 On tblAssets1.AssetID =
tblAssetRelations.ChildAssetID
Where tsysAssetRelationTypes.Name Like 'Replicating To %' And
tblAssetCustom.State = 1
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now