→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
MasterBaK33
Engaged Sweeper
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
1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
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

View solution in original post

1 REPLY 1
Daniel_B
Lansweeper Alumni
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