We’ve had another contribution from the Microsoft Dynamics community and are ready to release the v1.7 version of the D365FO Admin Toolkit!
D365FO Admin Toolkit v1.7
D365FO Admin Toolkit v1.7 Release
Note: This has been built against a 10.0.39 version of D365FO
Let’s look at the new features, functionality, and bug fixes in this release!
New Feature Overview
The new feature this release comes from a good friend of mine in the Dynamics community André Arnaud de Calavon, and extends and enhances the Entra ID Group integration that is available within D365FO.
He has actually put a great write up together on the feature itself: https://dynamicspedia.com/2024/08/enhanced-entra-id-group-integration-in-d365fo-admin-toolkit/
There is also a video of the feature in action: https://youtu.be/oqUK7jcZ6aM
Conclusion
I want to thank the Microsoft Dynamics community again as this D365FO Admin Toolkit has been extremely well received and has had contributions from so many different individuals!
Hi Alex,
Thank you so much for all your work. We have implemented your tool in our company, and it is working great!
I have one question for you, do you have in your roadmap to implement an approval workflow when a user requests the system admin role?
Many thanks for your time,
Javi
Javi,
Thanks for the kind words and glad that the solution is helping at your organization.
As far as offering workflow on SysAdmin approval, I 100% get the feature request, I have to be slightly careful as this functionality exists in the native Fastpath Identity Manager solution that I help lead the development on so I won’t be able to do that development but since this is an open source project someone else can absolutely take the lead on it.
Hi Alex,
I completely understand you point.
Many thanks for your help and time.
Kind regards,
Javi
Hi there,
I was attempting to install your package through LCS, but it failed at step 12 during the GlobalUpdate script for the service model: AOSService on machine DEV-02-1.
As a result, my DevBox environment is now damaged. Is there anything I can do to reinstall the package or restore the environment?
Thanks for your assistance!
Hello,
I would need to know what the error message actually is and what D365FO version you are trying to install against?
Also, in the meantime, you should be able to remove the package manually and it should have no impact on your dev environment.
Hi Alex!, Thanks for fast reply! Its very new devboxes I have spin up especialy for testing your awesome features, My current Version: 10.0.39 (10.0.1860.56).
I have tries install your package on trough the LCS and the error message
GloballJpdate script for service model: AOSService on machine: DEV-27-1
Additionally i was trying to install you package by the cmd code on another enviorement DEVBOX also and its successfully instaleed but the error message i got says:
“Session 1254978 (Ana.Sm.
SELECT T1.ID,T1.NAME,T1.ENABLE,T1.DEL_STARTUPMENU,T1.STATUSLINEINFO,T1.TOOLBARINFO,T1.DEBUGINFO,T1.AUTOINFO,T1.AUTOUPDATE,T1.GARBAGECOLLECTLIMIT,T1.HISTORYLIMIT,T1.MESSAGELIMIT,T1.GENERALINFO,T1.SHOWSTATUSLINE,T1.SHOWTOOLBAR,T1.DEBUGGERPOPUP,T1.SHOWAOTLAYER,T1.DEL_PASSWORD,T1.DEL_OSACCOUNTNAME,T1.STARTUPPROJECT,T1.CONFIRMDELETE,T1.CONFIRMUPDATE,T1.REPORTFONTNAME,T1.REPORTFONTSIZE,T1.FORMFONTNAME,T1.FORMFONTSIZE,T1.PROPERTYFONTNAME,T1.PROPERTYFONTSIZE,T1.INFOLOGLEVEL,T1.COMPANY,T1.AUTOLOGOFF,T1.QUERYTIMELIMIT,T1.TRACEINFO,T1.REPORTTOPMARGIN,T1.REPORTBOTTOMMARGIN,T1.REPORTLEFTMARGIN,T1.REPORTRIGHTMARGIN,T1.COMPILERWARNINGLEVEL,T1.SID,T1.NETWORKDOMAIN,T1.NETWORKALIAS,T1.ENABLEDONCE,T1.EXTERNALUSER,T1.LANGUAGE,T1.HELPLANGUAGE,T1.PREFERREDTIMEZONE,T1.PREFERREDCALENDAR,T1.HOMEPAGEREFRESHDURATION,T1.NOTIFYTIMEZONEMISMATCH,T1.FILTERBYGRIDONBYDEFAULT,T1.GLOBALFORMOPENMODE,T1.DEL_DEFAULTMODELID,T1.SHOWMODELNAMEINAOT,T1.ACCOUNTTYPE,T1.ISSUERRECID,T1.CREDENTIALRECID,T1.GLOBALLISTPAGELINKMODE,T1.GLOBALEXCELEXPORTMODE,T1.CLIENTACCESSLOGLEVEL,T1.DEFAULTPARTITION,T1.GLOBALEXCELEXPORTFILEPATH,T1.EXTERNALIDTYPE,T1.EXTERNALID,T1.PREFERREDLOCALE,T1.IDENTITYPROVIDER,T1.OBJECTID,T1.INTERACTIVELOGON,T1.ISMICROSOFTACCOUNT,T1.RECVERSION,T1.PARTITION,T1.RECID,T2.USERID,T2.LASTLOGIN,T2.PARTITION,T2.RECID FROM USERINFO T1 LEFT OUTER JOIN ADMSYSUSERLOG T2 ON ((T2.PARTITION=5637144576) AND (T1.ID=T2.USERID)) WHERE ((T1.PARTITION=5637144576) AND ( NOT ((T1.ACCOUNTTYPE=?)) AND (T1.ISMICROSOFTACCOUNT=?))) ORDER BY T1.ID OPTION(FAST 49)
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid object name ‘ADMSYSUSERLOG’.
Object Server Azure:
Cannot select a record in User Information (UserInfo). User Information: 0. The SQL database has issued an error.”
Hello,
It doesn’t appear that a database sync has been performed as this is the error: Invalid object name ‘ADMSYSUSERLOG’ which is part of the deployable package.
Hello Alex!
We are getting this error, when we try to assign/revoke SysAdmin with your tool.
We are on 10.0.41.
Method not found: ‘Dynamics.AX.Application.SysApplicationInsightsEventTelemetry Dynamics.AX.Application.SysApplicationInsightsEventTelemetry.addProperty(Dynamics.AX.Application.SysApplicationInsightsProperty)’.
Patrick,
This error was discussed in this GitHub thread: https://github.com/ameyer505/D365FOAdminToolkit/issues/40
This includes a new download here, for 10.0.41 users: https://github.com/user-attachments/files/16690498/D365AdminToolkit_1.7.0.0_10041.zip
Note: This will be included in the next D365FO Admin Toolkit release.
Also a detailed explanation can be found on Jonas’ blog post about this: https://melgaard.nu/xppsugar-public-interfaces/
Thank you, Alex!
Hi Alex,
Great solution! I tried it, and it seems perfect for our current workflow. I presented a demo to my managers, and they were very pleased with it. However, I was asked to conduct a security review on this package.
Can I ask if this package has been approved by any authorized security organizations? Have you encountered questions like this before, and what details do you typically provide regarding the security of your software?
Thanks for your help!
Best regards,
Anatolii
Anatolii,
The D365FO Admin Toolkit is open source and available for free on GitHub. It has not been reviewed by any security organization (I’m not sure one exists for D365FO / X++ packages), but you are more than welcome to review the source code and build the package yourself to ensure compliance. It also is delivered with no warranty or support as it is a passion project with multiple contributors.