Report of specific dynamique group with install date

[MasterBaK33]

Hi,

I have created a dynamic group named "Snow Inventory" to see all Workstations with this spécific software installed, but when I launch the view, one 'important' information is missing.
I need to have "installed date software" row

So How I can do this with report?

Thanks

[Daniel_B · Accepted solution]

Modifying the asset list format for dynamic groups is not currently supported. For this purpose you need to create a custom report. Please find an example query below:

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Lastseen,
  tSoftware.softwareName,
  tSoftware.softwareVersion,
  tSoftware.Installdate
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join (Select tblSoftware.AssetID,
    tblSoftwareUni.softwareName,
    tblSoftware.softwareVersion,
    tblSoftware.Installdate
  From tblSoftware
    Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
  Where tblSoftwareUni.softwareName Like 'Snow inventory%') tSoftware
    On tSoftware.AssetID = tblAssets.AssetID
Where tblAssetCustom.State = 1
Order By tblAssets.AssetName,
  tSoftware.softwareName