Reports through a AssetGroups Dymanic

[Martind]

I would like to be able to make a report on the basis of an AssetGroups Dymanic?

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssetGroups.AssetGroup,
tblAssets.Lasttried,
tblADComputers.Description,
tblAssetGroups.Dynamic
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Inner Join tblAssetGroupLink On tblAssets.AssetID = tblAssetGroupLink.AssetID
Inner Join tblAssetGroups On tblAssetGroups.AssetGroupID =
tblAssetGroupLink.AssetGroupID
Where tblAssets.AssetName = 'Sap Gui Old' And tblAssets.AssetName =
'Sap Gui Old' And tblAssetCustom.State = 1

[Nick_VDB · Accepted solution]

It is currently not possible to create a report that will give back if an asset is in a dynamic group. This is only possible for static groups. The reason for this is because for static groups an asset is marked as being in the static group because it is manually added to that groups.

However, for a dynamic group that assets are added when you click on the 'report' for the dynamic group. This occurs every time the report is called, all the assets are checked and those that meet the requirements are added to the report. They are however not stored as being in the dynamic group in any table in the database.