myPeopleSoft

PeopleSoft Community Network

understanding how much stable the system is

Select year,month,count(1) as Project_count,sum(ocount) as Object_count from (
SELECT distinct B.PROJECTNAME,TO_CHAR(B.LASTUPDDTTM ,'yyyy' ) as year,
TO_CHAR(B.LASTUPDDTTM ,'mm' ) as month,
count(1) over (Partition by B.PROJECTNAME) as oCount
FROM PSPROJECTITEM A,
PSPROJECTDEFN B
WHERE ( A.PROJECTNAME = B.PROJECTNAME )
and B.LASTUPDDTTM >sysdate-365)
group by year,month order by year,month

8 members like this

▶ Reply to This

Replies to This Discussion

Permalink Reply by Bonita Northington on June 5, 2013 at 4:29am

Worth Giving it a try !

▶ Reply

Permalink Reply by kristen on July 9, 2017 at 1:06pm

it's a pleasure to meet you. I am USA Army personnel, i have an important thing to discus with you.
Please write me on my email (captkristen899@gmail.com)