Anyone know how to get a report of all the objects in the Repository owned by a users. I have a report of users that are no longer valid so I want to see if these users have any owned objects.

This message has been edited. Last edited by: TexasStingray,

There have been many posts, but I am not sure if any of them have the definitive solution.

But you could search for UOA_USERS or UOA_GROUPS or the like

Here are a few to get you started.

BIP User Profiel

SELECT TOP 1000 [BIP_USER_PROFILE_ID]
      ,[BIP_USER_PROFILE_PROPERTIES]
      ,[BIP_USER_PROFILE_UOA_ID]
  FROM [WebFocus].[dbo].[BIP_USER_PROFILE]  

Groups and Users

 SELECT 
       usrs.DESCRIPTION
	  ,  usrs.NAME
      , usrs.EMAIL
	      , grps.NAME
	,      grps.DESCRIPTION
		, usrs.PROPERTIES   
  
  FROM webfocus.dbo.UOA_USERS usrs
  inner join WebFocus.dbo.UOA_GROUPSUSERS gub
    on usrs.ID = gub.USERID
  inner join webfocus.dbo.UOA_GROUPS grps
	on  gub.GROUPID = grps.ID
  
  Order by usrs.DESCRIPTION , grps.NAME, grps.DESCRIPTION 

Item Types

SELECT distinct ITEMTYPE = 
       case OBJTYPE when 102	then 'Rpt Object FEX'		
                    when 103	then 'Stylesheet'			
					when 106	then 'Help HTM'				
					when 107	then 'CSS'					
					when 109	then 'FEX'					
					when 110	then 'HTML'					
					when 113	then 'RC Schedule in WF8'	
					when 117	then 'URL'					
					when 4		then 'OTHER'				
					when 0		then 'Static web component' 
					when 301	then 'User Entry'			
					when 115	then 'RC Dist List'			
					when 118	then 'RC Library output'	
		end
  FROM [WebFocus].[dbo].[WF_REPOSOBJ]  

Objects

SELECT Distinct nlsobj.OBJDESC
		, repobj.CREATEDBY
		, repobj.OBJNAME
		,repobj.OBJTYPE
		,repobj.PRT_PATH
		,prpobj.PROPERTY
		,prpobj.PROPVALUE
      --,[SUMMARY]
      --,[WF_LNG]
      --,[OBJ_HANDLE]
  FROM WebFocus.dbo.WF_NLSOBJ nlsobj
  inner join WebFocus.dbo.WF_ITEM itm
	on nlsobj.OBJ_HANDLE = itm.HANDLE
  inner join WebFocus.dbo.WF_REPOSOBJ repobj
    on itm.HANDLE = repobj.HANDLE
  inner join WebFocus.dbo.WF_OBJPROPS prpobj
    on itm.HANDLE = prpobj.OBJ_HANDLE
    where 1=1
      --and itm.DATATYPE = 'png'
      and nlsobj.OBJDESC IS NOT NULL
      and repobj.CREATEDBY IS NOT NULL