![]() ![]() The first report should give back the asset that has a relation with the initial asset. Where tblAssets.AssetName Like '%111%' And tblAssetCustom.State = 1 Inner Join tsysAssetRelationTypes On tsysAssetRelationTypes.RelationTypeID = On tblAssets.AssetID = tblAssetRelations.ParentAssetID Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype ![]() Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID I'm using the comments field to indicate which switch port I'm connected to, but would like the Switch's AssetName listed as well. Everything works and reports the desired data, but I'd like the AssetName of the ParentAsset, in this case a Switch. ![]()
0 Comments
Leave a Reply. |