Detecting PeopleTools Changes

From TekiWiki
Jump to: navigation, search
@setup

@filesuffix

undefine days

prompt Please enter Number of Days to Go Back:

Prompt Number of days reported: &&days 

set echo off
set verify off

spool changes&&filesuffix.txt

prompt ******************************************************************
prompt                P R O J E C T   C H A N G E S
prompt ******************************************************************

select pd.projectname,pd.lastupdoprid
,(CASE p.ObjectType 
WHEN 0 THEN 'Record'
WHEN 1 THEN 'Index'
WHEN 2 THEN 'Field'
WHEN 3 THEN 'Field Format'
WHEN 4 THEN 'Translate Value'
WHEN 5 THEN 'Pages'
WHEN 6 THEN 'Menus'
WHEN 7 THEN 'Components'
WHEN 8 THEN 'Record PeopleCode'
WHEN 9 THEN 'Menu PeopleCode'
WHEN 10 THEN 'Query'
WHEN 11 THEN 'Tree Structures'
WHEN 12 THEN 'Trees'
WHEN 13 THEN 'Access group'
WHEN 14 THEN 'Color'
WHEN 15 THEN 'Style'
WHEN 16 THEN 'N/A'
WHEN 17 THEN 'Business process'
WHEN 18 THEN 'Activity'
WHEN 19 THEN 'Role'
WHEN 20 THEN 'Process Definition'
WHEN 21 THEN 'Server Definition'
WHEN 22 THEN 'Process Type Definition'
WHEN 23 THEN 'Job Definitions'
WHEN 24 THEN 'Recurrence Definition'
WHEN 25 THEN 'Message Catalog'
WHEN 26 THEN 'Dimension'
WHEN 27 THEN 'Cube Definitions'
WHEN 28 THEN 'Cube Instance Definitions'
WHEN 29 THEN 'Business Interlink'
WHEN 30 THEN 'SQL'
WHEN 31 THEN 'File Layout Definition'
WHEN 32 THEN 'Component Interfaces'
WHEN 33 THEN 'AE program'
WHEN 34 THEN 'AE section'
WHEN 35 THEN 'Message Node'
WHEN 36 THEN 'Message Channel'
WHEN 37 THEN 'Message'
WHEN 38 THEN 'Approval rule set'
WHEN 39 THEN 'Message PeopleCode'
WHEN 40 THEN 'Subscription PeopleCode'
WHEN 41 THEN 'N/A'
WHEN 42 THEN 'Component Interface PeopleCode'
WHEN 43 THEN 'AE PeopleCode'
WHEN 44 THEN 'Page PeopleCode'
WHEN 45 THEN 'Page Field PeopleCode'
WHEN 46 THEN 'Component PeopleCode'
WHEN 47 THEN 'Component Record PeopleCode'
WHEN 48 THEN 'Component Rec Fld PeopleCode'
WHEN 49 THEN 'Image'
WHEN 50 THEN 'Style sheet'
WHEN 51 THEN 'HTML'
WHEN 52 THEN 'Not used'
WHEN 53 THEN 'Permission List'
WHEN 54 THEN 'Portal Registry Definitions'
WHEN 55 THEN 'Portal Registry Structures'
WHEN 56 THEN 'URL Definitions'
WHEN 57 THEN 'Application Packages'
WHEN 58 THEN 'Application Package Peoplecode'
WHEN 59 THEN 'Portal Registry User Homepage'
WHEN 60 THEN 'Problem Type'
WHEN 61 THEN 'Archive Templates'
WHEN 62 THEN 'XSLT'
WHEN 63 THEN 'Portal Registry User Favorite'
WHEN 64 THEN 'Mobile Page'
WHEN 65 THEN 'Relationships'
WHEN 66 THEN 'Component Interface Property Peoplecode'
WHEN 67 THEN 'Optimization Models'
WHEN 68 THEN 'File References'
WHEN 69 THEN 'File Type Codes'
WHEN 70 THEN 'Archive Object Definitions'
WHEN 71 THEN 'Archive Templates (Type 2)'
WHEN 72 THEN 'Diagnostic Plug In'
WHEN 73 THEN 'Analytic Model'
WHEN 79 THEN 'Service'
WHEN 80 THEN 'Service Operation'
WHEN 81 THEN 'Service Operation Handler'
WHEN 82 THEN 'Service Operation Version'
WHEN 83 THEN 'Service Operation Routing'
WHEN 84 THEN 'IB Queue'
WHEN 85 THEN 'XMLP Template Defn'
WHEN 86 THEN 'XMLP Report Defn'
WHEN 87 THEN 'XMLP File Defn'
WHEN 88 THEN 'XMLP Data Source Definition'
ELSE 'UNKNOWN:'||p.ObjectType END) AS OBJECTTYPE
,pd.lastupddttm,p.* 
from psprojectitem p,psprojectdefn pd
where 
pd.lastupddttm>sysdate-&&days
and p.projectname=pd.projectname
order by 1,2,3,4,5
;

set feedback off

prompt ******************************************************************
prompt                 O B J E C T   C H A N G E S
prompt ******************************************************************

select rpad('PSACEMDLDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSACEMDLDEFN t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSACTIVITYDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSACTIVITYDEFN t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSAEAPPLDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSAEAPPLDEFN t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSAESECTDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSAESECTDEFN t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSARCHOBJDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSARCHOBJDEFN t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSARCHTEMPLATE',30),lastupdoprid who,lastupddttm when
,t.* from PSARCHTEMPLATE t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSBCDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSBCDEFN t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSBUSPROCDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSBUSPROCDEFN t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSCHNLDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSCHNLDEFN t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSCOLORDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSCOLORDEFN t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSCONTDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSCONTDEFN t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSDBFIELD',30),lastupdoprid who,lastupddttm when
,t.* from PSDBFIELD t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSDIAGREG',30),lastupdoprid who,lastupddttm when
,t.* from PSDIAGREG t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSDSSCHEMA',30),lastupdoprid who,lastupddttm when
,t.* from PSDSSCHEMA t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSFILEREDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSFILEREDEFN t where lastupddttm>sysdate-&&days and lastupddttm<sysdate+1 order by  lastupdoprid,lastupddttm;

select rpad('PSFLDDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSFLDDEFN t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSFMTDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSFMTDEFN t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSIBMSGFILE_ATT',30),lastupdoprid who,lastupddttm when
,t.* from PSIBMSGFILE_ATT t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSIBSCHEMAS_ATT',30),lastupdoprid who,lastupddttm when
,t.* from PSIBSCHEMAS_ATT t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSIBWNODETRXVW',30),lastupdoprid who,lastupddttm when
,t.* from PSIBWNODETRXVW t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSIBWNODTRXVW0',30),lastupdoprid who,lastupddttm when
,t.* from PSIBWNODTRXVW0 t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSIBWNODTRXVW1',30),lastupdoprid who,lastupddttm when
,t.* from PSIBWNODTRXVW1 t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSIBWRELATRXVW',30),lastupdoprid who,lastupddttm when
,t.* from PSIBWRELATRXVW t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSIBWRELAVW',30),lastupdoprid who,lastupddttm when
,t.* from PSIBWRELAVW t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSIBXML_ATT',30),lastupdoprid who,lastupddttm when
,t.* from PSIBXML_ATT t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSIMPDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSIMPDEFN t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSIODEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSIODEFN t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSJPUPDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSJPUPDEFN t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSMENUDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSMENUDEFN t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSMPDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSMPDEFN t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSMSGDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSMSGDEFN t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSMSGNODEDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSMSGNODEDEFN t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSNODETRX',30),lastupdoprid who,lastupddttm when
,t.* from PSNODETRX t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSNODETRXVW2',30),lastupdoprid who,lastupddttm when
,t.* from PSNODETRXVW2 t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSNODETRX_CVW',30),lastupdoprid who,lastupddttm when
,t.* from PSNODETRX_CVW t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSNODEVW',30),lastupdoprid who,lastupddttm when
,t.* from PSNODEVW t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSOPTMODEL',30),lastupdoprid who,lastupddttm when
,t.* from PSOPTMODEL t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSOPTPRBTYPE',30),lastupdoprid who,lastupddttm when
,t.* from PSOPTPRBTYPE t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSPACKAGEDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSPACKAGEDEFN t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSPCMPROG',30),lastupdoprid who,lastupddttm when
,t.* from PSPCMPROG t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSPERMLIST_RMT',30),lastupdoprid who,lastupddttm when
,t.* from PSPERMLIST_RMT t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSPMAGENTFILTER',30),lastupdoprid who,lastupddttm when
,t.* from PSPMAGENTFILTER t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSPMMONITORGBL',30),lastupdoprid who,lastupddttm when
,t.* from PSPMMONITORGBL t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSPMSYSDEFAULTS',30),lastupdoprid who,lastupddttm when
,t.* from PSPMSYSDEFAULTS t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSPMSYSDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSPMSYSDEFN t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSPNLDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSPNLDEFN t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSPNLGRPDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSPNLGRPDEFN t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSPRDMDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSPRDMDEFN t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSPROJECTDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSPROJECTDEFN t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSPRSMDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSPRSMDEFN t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSPSWDHINT',30),lastupdoprid who,lastupddttm when
,t.* from PSPSWDHINT t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSPURGEPERMLIST',30),lastupdoprid who,lastupddttm when
,t.* from PSPURGEPERMLIST t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSRECDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSRECDEFN t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSRECFIELD',30),lastupdoprid who,lastupddttm when
,t.* from PSRECFIELD t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSRECFIELDDB',30),lastupdoprid who,lastupddttm when
,t.* from PSRECFIELDDB t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSRECFIELD_TMP',30),lastupdoprid who,lastupddttm when
,t.* from PSRECFIELD_TMP t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSRELATCNTCT_VW',30),lastupdoprid who,lastupddttm when
,t.* from PSRELATCNTCT_VW t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSRELATCONTACT',30),lastupdoprid who,lastupddttm when
,t.* from PSRELATCONTACT t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSRELATIONPROP',30),lastupdoprid who,lastupddttm when
,t.* from PSRELATIONPROP t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSRELATIONSHIP',30),lastupdoprid who,lastupddttm when
,t.* from PSRELATIONSHIP t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSRELATIONTRX',30),lastupdoprid who,lastupddttm when
,t.* from PSRELATIONTRX t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSRELTRX_CVW',30),lastupdoprid who,lastupddttm when
,t.* from PSRELTRX_CVW t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSRELTRX_SRCH',30),lastupdoprid who,lastupddttm when
,t.* from PSRELTRX_SRCH t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSROLEDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSROLEDEFN t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSROLEDEFN_RMT',30),lastupdoprid who,lastupddttm when
,t.* from PSROLEDEFN_RMT t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSSQLDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSSQLDEFN t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSSTYLEDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSSTYLEDEFN t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSSTYLESHEET_VW',30),lastupdoprid who,lastupddttm when
,t.* from PSSTYLESHEET_VW t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSSTYLSHEETDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSSTYLSHEETDEFN t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSSUBDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSSUBDEFN t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSTOOLBARDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSTOOLBARDEFN t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSTYPECODEDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSTYPECODEDEFN t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSURLDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSURLDEFN t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSWSDLFILE_ATT',30),lastupdoprid who,lastupddttm when
,t.* from PSWSDLFILE_ATT t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSWSRPCPHDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSWSRPCPHDEFN t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSWSRPPLTDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSWSRPPLTDEFN t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSWSRPPRDDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSWSRPPRDDEFN t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSXLATITEM',30),lastupdoprid who,lastupddttm when,t.* from PSXLATITEM t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

prompt ******************************************************************
prompt                S E C U R I T Y   C H A N G E S
prompt ******************************************************************


select rpad('PSCLASSDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSCLASSDEFN t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSOPRDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSOPRDEFN t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

prompt ******************************************************************
prompt                E X P E C T E D   C H A N G E S
prompt ******************************************************************

select rpad('PSQRYDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSQRYDEFN t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSTREEDEFN',30),lastupdoprid who,lastupddttm when
,t.* from PSTREEDEFN t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;

select rpad('PSTREESTRCT',30),lastupdoprid who,lastupddttm when
,t.* from PSTREESTRCT t where lastupddttm>sysdate-&&days order by  lastupdoprid,lastupddttm;


spool off