David Tech Lab

SELECT C.ROLEUSER ,B.ROLENAME ,A.CLASSID, -- OPRID A.BCNAME -- CI , A.BCMETHOD FROM PSAUTHBUSCOMP A, PSROLECLASS B, PSROLEUSER C WHERE C.ROLENAME = B.ROLE

ProjectView.sqlselectcase PI.OBJECTTYPE when 0 then 'Records' when 1 then 'Indexes' when 2 then 'Fields' when 3 then 'Field Formats' when 4 then 'Translate Values' when 5 then 'Pa

SELECT OBJECTID1,OBJECTVALUE1,OBJECTID2,OBJECTVALUE2,OBJECTID3,OBJECTVALUE3,OBJECTID4,OBJECTVALUE4,OBJECTID5,OBJECTVALUE5,OBJECTID6,OBJECTVALUE6,OBJECTID7,OBJECTVALUE7,PROGSEQ,VERSION,NAMECOUNT,PROGLE

For PeopleTools 8.4x:We could see this information from the navigation:PeopleTools -> Security -> Review Security Information -> Access Log QueriesIt uses the information from the LASTSIGN

Below is the SQL to find out  unused permission lists:SELECT * FROM PSCLASSDEFN AWHERE NOT EXISTS ( SELECT 'X' FROM PSUSERCLASSVW B WHERE A.CLASSID = B.CLASSID )AND NOT EXISTS (SELECT 'X' FROM PSO

SELECT S.SERVERNAME,       X.XLATSHORTNAME,       X.FIELDVALUE,       cast(S.MAXCPU as varchar2(3)) || '%' MAXCPU,       cast(S.PRCSDISKSPACE as varchar2(15)) || 'MB' PRCS_DISK_SPACE,

PS_PTLT_COMP_NAV – Define Components Navigation Setup record (in PT>=8.4xx). It is a very useful table especially when you are given a certain PeopleSoft link or Component and you don’t know how to id

-- Navigation based off ProcessSELECT PRCSPNL.PRCSNAME, MENUGROUP || ' > ' || MENULABEL || ' > ' || BARLABEL || ' > ' || ITEMLABEL "Path"FROM PSMENUITEM MENU, PS_PRCSDEFNPNL PRCSPNL, PSMENUDEFN

The "Find Object References - Record Field" feature in Application Designer, when used to search for queries utilizing a specific field (i.e. "EMPL_STATUS"), is not accurate because it returns que

If you ever have a need to migrate queries from one user to another, you can do it quickly and easily with this useful SQL script. If you want to make the Query Public, simply change the NEWPSUSERID

1.查看PS系统的登录情况：select a.*,b.oprdefndesc from psaccesslog a,psoprdefn bwhere a.logindttm > sysdate - 7 -- 这里说明了查询的是最近一个星期的情况and a.oprid =b.opridand b.oprdefndesc like '%'ORDER BY A.LOGINDTTM

SELECT DISTINCT RTRIM( REVERSE ( SYS_CONNECT_BY_PATH(REVERSE (portal_label), ' > ')) ,' > ') PATH FROM PSPRSMDEFN WHERE PORTAL_NAME = 'EMPLOYEE' AND PORTAL_PRNTOBJNAME = 'PORTAL_ROOT_O

Select Distinct Projectname, ObjectID1,Objectvalue1,ObjectID2, Objectvalue2,ObjectID3, Objectvalue3,ObjectID4, Objectvalue4from PSprojectitemwhere (ObjectID1,Objectvalue1,ObjectID2, Objectvalue2,O