Add A JDE EnterpriseOne Environment To Every Role/Group
You can use the below SQL to add an EnterpriseOne environment to every role or group in your installation:
INSERT INTO SY910/F0093 (LLUSER,LLLL,LLSEQ,LLMNI) SELECT ULUSER, 'PD910','1.00','' FROM SY910/F0092
More Stories
Quick Tip: IBM Navigator for i Default URL
This is a really quick one but I keep forgetting it: http://<SERVERNAME>:2004/ibm/console
Windows God Mode… What!?!
Windows God Mode is a hidden feature in the Windows operating system that allows users to access all of the system’s control panel options and settings in a single place.
How To Test A SQL Server Connection
There is an easy way to test your SQL Server connection when running Windows without any special software. I found...
4 Lines To Export Outlook Rules To Excel/CSV Using PowerShell
I used to use a ton of Outlook Rules to organize the thousands of emails that I receive each day....
Get The Size & Record Count Of All Tables In A SQL Server Database
Use the SQL query below to display the size and record count of all tables in an SQL Server database....
How To Get AS400/iSeries Job Queue Information Using SQL
I received a request the other day about the JD Edwards EnterpriseOne job queues and what the maximum number of...