
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-16-2015 02:08 PM
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:
Some one can help me?
tks!
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!

Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-17-2015 11:57 AM
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'
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-17-2015 11:57 AM
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'
