List All Microsoft Dynamics AX Software

[Diego_Tomazzoni]

Hi,
I want to list all Microsoft Dynamics AX Software with computer and user name, last seen and last tried. I Found a similar script to list all Microsoft Office and change the tblSoftwareUni.softwareName to Like 'Microsoft Dynamics%' but the report do not list anything


The code is:

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblAssets.IPAddress,
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblSoftwareUni.softwareName As Software,
  tblSoftware.softwareVersion As Version,
  tblSoftwareUni.SoftwarePublisher As Publisher,
  tsysOS.Image As icon
From tblAssets
  Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
  Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblSoftwareUni.softwareName Like 'Microsoft Dynamics%' And
  SubString(tblSoftwareUni.softwareName, Len(tblSoftwareUni.softwareName) - 4,
  3) = ' 20' And tblAssetCustom.State = 1
Order By tblAssets.Domain,
  tblAssets.AssetName,
  Software

Some one can help me?
tks!

[Susan_A · Accepted solution]

Remove the snippet below from your query. This was only relevant for the Office report and specifies that only software names that end in a year should be listed.

And SubString(tblSoftwareUni.softwareName, Len(tblSoftwareUni.softwareName) - 4,
  3) = ' 20'