ccovert
Member
Hi,
I am a project manager at our Town corporation. I've already asked our JDE Systems analyst/amin and they do not have an answer for this.
We'd like to run a report or SQL query to get this type of information if possible:
1.) All modules/components installed (i.e. GL, AP, AR, GL, Contract Management, AM, etc) and sub-components
2.) Of the modules installed (by matching against other tables) determine if they have ever been used (i.e.: someone ever created a record(s) in that module/sub-component)
3.)Licenses available VS Used by Users for each component.
4.) When was the last time a module was used (not for each user, but by anyone).
Is this available as a canned report or has someone the SQL query(s) to pull this report?
Much appreciated.
Thank You
Chris
I am a project manager at our Town corporation. I've already asked our JDE Systems analyst/amin and they do not have an answer for this.
We'd like to run a report or SQL query to get this type of information if possible:
1.) All modules/components installed (i.e. GL, AP, AR, GL, Contract Management, AM, etc) and sub-components
2.) Of the modules installed (by matching against other tables) determine if they have ever been used (i.e.: someone ever created a record(s) in that module/sub-component)
3.)Licenses available VS Used by Users for each component.
4.) When was the last time a module was used (not for each user, but by anyone).
Is this available as a canned report or has someone the SQL query(s) to pull this report?
Much appreciated.
Thank You
Chris