A repository for reusable code related to AX 2012 administration and maintenance.

This script fixes both Table and Field IDs in SqlDictionary (data db) to match the AX code (Model db). Useful for after a database has been restored and the table or field IDs do not match. Instead of letting the database synchronization process drop and recreate the table, just run this SQL Script!

Lists the versions for all the DLLs which will load in AX. It checks nine locations on every computer provided to the command. Run this script against all clients (RDP/Citrix/end-user) and servers. This can be used to confirm that all DLLs deployed match in file version.

.\Get-AxDllVersions.ps1

Example single value:

ComputerName : Server1 FileVersion : 6.3.5000.3084 ProductVersion : 6.3.5000.3084 OriginalName : Microsoft.Dynamics.Retail.TestConnector.dll FilePath : \DAXDEVMCA1\c$\Program Files\Microsoft Dynamics AX\60\Server\Server1\bin\Connectors FileDescription :
ProductName : Microsoft Dynamics AX Status : Success

.\Get-AxDllVersions.ps1 -ComputerName "Server1","Server2"

.\Get-AxDllVersions.ps1 -ComputerName (Get-Content "ComputerList.txt")  | Export-csv "c:\temp\AX_DLL_Versions.csv" -NotypeInformation

The script must be run as an account having Administrator access all computers. The script will skip any offline/inaccessible computers.