SQL to find Project Name, Description, LASTUPDDTTM, LASTUPDOPRID and number of custom objects in any environment.

SQL to find Project Name, Description,  LASTUPDDTTM, LASTUPDOPRID and number of custom objects  in any environment.

SELECT P.PROJECTNAME, P.PROJECTDESCR, P.LASTUPDDTTM, P.LASTUPDOPRID,(SELECT COUNT(*) FROM PSPROJECTITEM I WHERE I.PROJECTNAME = P.PROJECTNAME AND I.OBJECTVALUE1 NOT LIKE '%XXX%') AS PS_OBJECTS_CUSTOMISED FROM PSPROJECTDEFN P WHERE P.LASTUPDOPRID NOT IN ('PS','PPLTOOLS') ORDER BY P.LASTUPDDTTM DESC;