Detecting PeopleTools Changes

From TekiWiki

Jump to: navigation, search

This whole wiki has now moved to http://www.springboardsolutions.com/wiki

Go to this page Detecting PeopleTools Changes

(Created page with "<pre>")
 
Line 1: Line 1:
<pre>
<pre>
 +
@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
 +
</pre>

Latest revision as of 17:49, 24 April 2014

Retrieved from "http://www.homemarketeer.com/wiki/index.php?title=Detecting_PeopleTools_Changes"
Personal tools