Hi,
I am trying (perhaps in a clumsy way!) to make a report of assets with one or more missing custom fields filled out. It sort of works, but my problem is, that assets only in Default Group doesn't show up! If I then assign the assets to another group, it shows up, even if I remove it from the group again!
Select Top 1000000 tblassets.AssetID,
tblassets.AssetName,
tsysassettypes.AssetTypename,
tblAssetGroups.AssetGroup,
tblassetcustom.Custom8 As System,
tblassetcustom.Custom1 As Service,
tblassetcustom.PurchaseDate,
tblassetcustom.Custom3 As HW,
tblassetcustom.Custom2 As VLAN,
tblassetcustom.Custom4 As Building,
tblassetcustom.Custom7 As Priority,
tsysassettypes.AssetTypeIcon10 As icon,
tblassets.Firstseen
From tblassets
Inner Join tblAssetGroupLink On tblassets.AssetID = tblAssetGroupLink.AssetID
Inner Join tblAssetGroups On tblAssetGroups.AssetGroupID =
tblAssetGroupLink.AssetGroupID
Inner Join tblassetcustom On tblassets.AssetID = tblassetcustom.AssetID
Inner Join tsysassettypes On tsysassettypes.AssetType = tblassets.Assettype
Where (tblassets.AssetName <> 'None' And tblassetcustom.Custom8 <> 'NoSystem'
And tblassetcustom.Custom2 = '' And tblassetcustom.State = 1) Or
(tblassets.AssetName <> 'None' And tblassetcustom.Custom8 <> 'NoSystem' And
tblassetcustom.Custom1 = '' And tblassetcustom.State = 1) Or
(tblassets.AssetName <> 'None' And tblassetcustom.Custom8 = '' And
tblassetcustom.Custom8 <> 'NoSystem' And tblassetcustom.State = 1) Or
(tblassets.AssetName <> 'None' And tblassetcustom.Custom8 <> 'NoSystem' And
tblassetcustom.Custom3 = 'yes' And tblassetcustom.Custom4 = '' And
tblassetcustom.State = 1) Or
(tblassets.AssetName <> 'None' And tblassetcustom.Custom8 <> 'NoSystem' And
tblassetcustom.PurchaseDate = '' And tblassetcustom.Custom3 = 'yes' And
tblassetcustom.State = 1)
Order By tblassets.Firstseen Desc
Any help appreciated 🙂
Thank you
Kind regards Peter