So, to continue with the SQL theme from our E1 Development Manager, here is one that retrieves info about the projects that have been promoted since a given date. It gives the Project Name, Project Description, Object Name, Object Description, Object Type and the person’s userid that is on the object in PY.

There are many things that I find frustrating about the GUI tools for EnterpriseOne (E1), especially when doing Systems Administration functions.

Apparently, I’m not the only one. We give read-only access to most of the SysAdmin applications to our developers. You may have your own opinions about that, but it’s what we chose to do.

Anyway, our development manager gets a lot of CNC-type questions from our users and doesn’t like to always “bother” us with them. One of the questions she gets is “Who has access to the application or UBE?”. She got tired of wading through the multiple GUI applications required to get that information and came up with a very slick SQL query that returns the information quickly:

While trying to delete an object the other day, I received the ever-helpful “Object exists in an active project” error. Since our developers have created a few hundred OMW projects, I didn’t want to go searching through every project to see where this object was. I realize that I should have been able to look at the News/Status tab and get the info, but it didn’t seem to be working.

When installing ESUs, an OMW project is created. If you have installed a lot of ESUs those projects can make it very annoying when trying to find other legitimate projects that you have access to. Yes, you can filter the OMW Project display, but I kinda find that annoying too. Anyway, I created a very simple SQL that I run once in a while to clean up my OMW:

DELETE FROM sy811/f98221
WHERE PUOMWUSER = 'userid'
AND PUOMWPRJID LIKE 'JJ%'

Of course the syntax will need to be adjusted if using a database other than an IBM iSeries.