![](https://img-blog.csdnimg.cn/20201014180756780.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SQL
文章平均质量分 81
conanxun
这个作者很懒,什么都没留下…
展开
-
Check if user has access to CI
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原创 2012-08-23 16:42:51 · 527 阅读 · 0 评论 -
PeopleSoft-Project-View
ProjectView.sql select case 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转载 2016-06-13 17:04:03 · 254 阅读 · 0 评论 -
找到PeopleCode经过customized的所有Object
SELECT OBJECTID1,OBJECTVALUE1,OBJECTID2,OBJECTVALUE2,OBJECTID3,OBJECTVALUE3,OBJECTID4,OBJECTVALUE4,OBJECTID5,OBJECTVALUE5,OBJECTID6,OBJECTVALUE6,OBJECTID7,OBJECTVALUE7,PROGSEQ,VERSION,NAMECOUNT,PROGLE原创 2013-01-15 15:01:32 · 66 阅读 · 0 评论 -
How to Retrieve Information on Users Currently Logged on?
For PeopleTools 8.4x: We could see this information from the navigation: PeopleTools -> Security -> Review Security Information -> Access Log Queries It uses the information from the LASTSIGN转载 2013-01-04 12:29:24 · 111 阅读 · 0 评论 -
SQL to find out unused permission lists
Below is the SQL to find out unused permission lists: SELECT * FROM PSCLASSDEFN A WHERE NOT EXISTS ( SELECT 'X' FROM PSUSERCLASSVW B WHERE A.CLASSID = B.CLASSID ) AND NOT EXISTS (SELECT 'X' FROM PSO转载 2012-12-17 16:02:06 · 54 阅读 · 0 评论 -
Process Scheduler monitoring useful script
SELECT S.SERVERNAME, X.XLATSHORTNAME, X.FIELDVALUE, cast(S.MAXCPU as varchar2(3)) || '%' MAXCPU, cast(S.PRCSDISKSPACE as varchar2(15)) || 'MB' PRCS_DISK_SPACE,转载 2012-09-14 18:09:45 · 382 阅读 · 0 评论 -
PS_PTLT_COMP_NAV
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转载 2012-09-14 18:07:09 · 816 阅读 · 0 评论 -
获取Process、Component 和 Page 的导航路径
-- Navigation based off Process SELECT PRCSPNL.PRCSNAME, MENUGROUP || ' > ' || MENULABEL || ' > ' || BARLABEL || ' > ' || ITEMLABEL "Path" FROM PSMENUITEM MENU, PS_PRCSDEFNPNL PRCSPNL, PSMENUDEFN转载 2012-09-14 13:08:46 · 487 阅读 · 0 评论 -
search for queries utilizing a specific field
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转载 2012-09-14 17:13:18 · 520 阅读 · 0 评论 -
Migrating Queries from One User To Another
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转载 2012-09-14 16:48:21 · 523 阅读 · 0 评论 -
PeopleSoft系统开发&管理常用SQL
1.查看PS系统的登录情况: select a.*,b.oprdefndesc from psaccesslog a,psoprdefn b where a.logindttm > sysdate - 7 -- 这里说明了查询的是最近一个星期的情况 and a.oprid =b.oprid and b.oprdefndesc like '%' ORDER BY A.LOGINDTTM转载 2012-09-07 02:10:23 · 210 阅读 · 0 评论 -
Get process's navigation path by using process name
SELECT DISTINCT RTRIM( REVERSE ( SYS_CONNECT_BY_PATH(REVERSE (portal_label), ' > ')) ,' > ') PATH FROM PSPRSMDEFN WHERE PORTAL_NAME = 'EMPLOYEE' AND PORTAL_PRNTOBJNAME = 'PORTAL_ROOT_O原创 2012-08-23 12:23:39 · 728 阅读 · 0 评论 -
To know the project Dependencies
Select Distinct Projectname, ObjectID1,Objectvalue1,ObjectID2, Objectvalue2,ObjectID3, Objectvalue3,ObjectID4, Objectvalue4 from PSprojectitem where (ObjectID1,Objectvalue1,ObjectID2, Objectvalue2,O转载 2016-06-13 17:06:36 · 149 阅读 · 0 评论