Wednesday, 8 May 2013

To get Component interface information

Use below SQL to get CI assigned permission list

SELECT * FROM PSAUTHBUSCOMP WHERE BCNAME='CI Name'


To get object migrated from which project

SELECT A.OBJECTVALUE1,A.PROJECTNAME,B.LASTUPDDTTM,B.LASTUPDOPRID FROM PSPROJECTITEM A,PSPROJECTDEFN B WHERE A.OBJECTVALUE1='Object Name' AND B.PROJECTNAME=A.PROJECTNAME

No comments:

Post a Comment