Good Morning
I have a problem with my report, in my report I just want to display a "assetgroup" even if 2 or more groups assigned.
My query is based simply on computers that have an assigned ip and show me some information, and not how to display the hard disk capacity in a line only because it shows me several.
I hope you can help me.
Thank you
Select Top (1000000) tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tblAssetCustom.Custom10,
tblAssetGroups.AssetGroup,
tblAssetCustom.Serialnumber,
tblAssets.Mac,
tsysOS.OSname As OS,
tblAssets.Processor,
tblAssets.Memory,
tblAssetCustom.Custom8
From tblAssets
Left Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Left Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tsysIPLocations On tblAssets.IPNumeric >= tsysIPLocations.StartIP
And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Left Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Left Join tblAssetGroupLink On tblAssets.AssetID = tblAssetGroupLink.AssetID
Left Join tblAssetGroups On tblAssetGroups.AssetGroupID =
tblAssetGroupLink.AssetGroupID
Where (tblAssets.IPAddress = '192%') Or
(tblAssets.IPAddress <> '' And tblAssetGroups.AssetGroup Not Like
'Default group' And tblAssetCustom.State = 1)
Order By tblAssets.IPNumeric
