→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Diego_Tomazzoni
Engaged Sweeper III
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!
1 ACCEPTED SOLUTION
Susan_A
Lansweeper Alumni
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'

View solution in original post

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