EnterpriseOne (E1) ESU Investigation
Read Time:49 Sec
The title sounds like something out of CSI or Law & Order SVU…
Today our Development Manager was inquiring about what ESUs have been applied and to what environments.
Here is the SQL that I came up with:
Note: I restricted this query to only ESUs that were applied after our "Fix Current" project completed on 106041 (Feb. 10, 2006). Otherwise, there would be more listings than I could handle. Also, you’ll find the little trick to convert the JDE 6 digit date to something more readable.
SELECT SDPKGNAME as ESU, date(char(Min(Case when SDSUDFUT2= 'PS811' then SDSUDATE end)+1900000)) as PS811, date(char(Min(Case when SDSUDFUT2 = 'DV811' then SDSUDATE end)+1900000)) as DV811, date(char(Min(Case when SDSUDFUT2 = 'PY811' then SDSUDATE end)+1900000)) as PY811, date(char(Min(Case when SDSUDFUT2 = 'PD811' then SDSUDATE end)+1900000)) as PD811 FROM SY811/F9671, SY811/F9670 WHERE (SDSUDET = '90') and (SUSUDATE > 106041) and (SDPKGNAME=SUPKGNAME) GROUP BY SDPKGNAME ORDER BY SDPKGNAME DESC
Happy
0
Sad
0
Excited
0
Sleepy
0
Angry
0
Surprise
0
I enjoy reading your posts, keep them coming
Thanks! I appreciate your feedback. If you have anything that you would like me to try and cover, please let me know.