SQL Report for Usergroup / Workview Permissions

[Edward_Washing3]

Hello,

Using the diagnostic console, of course, I have found the " hsi.rmusergobject table. "

But there are Object Types I cant figure out a link for. '

What items in Workview are linked to a rmobjecttype with values  29,53,15, and 82 mean?

Current SQL:

set transaction isolation level read uncommitted

select wvo.*,

case
when wvo.rmobjecttype in (3) then 'Class'
when wvo.rmobjecttype in (1) then 'Application'
When wvo.rmobjecttype in (9) then 'Filter Bar'
When wvo.rmobjecttype in (0) then 'Class Action'
When wvo.rmobjecttype in (10) then 'Filter on Filter Bar' -- Gotta figure out how to link this key to filter ID
When wvo.rmobjecttype in (19) then 'View' -- Gotta figure out how to link this key to filter ID
When wvo.rmobjecttype in (15) then '*Unknown - Added with Class ' --15 was added then I added usergroup to class

else rtrim(wvo.rmobjecttype)
end[wv_object_type],

case
when wvo.rmobjecttype in (3) then (select '('+rtrim(cl.classid)+') '+ rtrim(cl.classname) from hsi.rmclass cl where wvo.rmobjectkey = cl.classid)

when wvo.rmobjecttype in (1) then (select '('+rtrim(app.rmapplicationid)+') '+ rtrim(app.rmapplicationname) from hsi.rmapplication app where wvo.rmobjectkey = app.rmapplicationid)

When wvo.rmobjecttype in (9) then (select '('+rtrim(fb.filterbarid)+') '+ rtrim(fb.filterbartitle) from hsi.rmfilterbar fb where fb.filterbarid = wvo.rmobjectkey )

When wvo.rmobjecttype in (0) then (select '('+ rtrim(ac.actionid) + ') '+ rtrim(ac.rmactionname) from hsi.rmaction ac where ac.actionid = wvo.rmobjectkey)

When wvo.rmobjecttype in (10) then
(select '('+rtrim(fbi.filterbarid)+') '+rtrim(fb.filterbartitle) + ' >> '+ '('+rtrim(fbi.filterid)+') '+ rtrim(fbi.filterbaritemname)
from hsi.rmfilterbaritem fbi join hsi.rmfilterbar fb on fbi.filterbarid = fb.filterbarid where filterbaritemid = wvo.rmobjectkey)

When wvo.rmobjecttype in (19) then (select '('+rtrim(rv.viewid)+') '+rtrim( rv.rmtitle )from hsi.rmview rv where wvo.rmobjectkey = rv.viewid)

When wvo.rmobjecttype in (15) then '*Unknown - Added with Class ' -- Gotta figure out how to link this key to filter ID

else '--'
end[wv_object_descr],

ug.usergroupname
from hsi.rmusergobject wvo
left join hsi.usergroup ug on ug.usergroupnum = wvo.usergroupnum
--where wvo.usergroupnum = 178
order by ug.usergroupname

[Larissa_Armand]

I've been working on the same thing, would love to find out if we can get more information. 

I have the same question about 15. 

I do have the following: 

0	Action
1	Application
3	Class
8	Filter
9	Filter Bar
10	Filter Bar Item
15	?
16	ScreenAction
19	View
29	DocFolder
32	FilterBariTemSubFilter
33	Calendar
34	CalendarXFilter
35	FilterBarAction
36	FilterBarItemAction
59	OutlookTaskPaneSection
73	ClassXFolder
82	ClassDirectCreate
94	MobileApp
104	Keyword mapping & module associations

[Edward_Washing3]

I've been working on the same thing, would love to find out if we can get more information. I have the same question about 15. I do have the following: 0 Action 1 Application 3 Class 8 Filter 9 Filter Bar 10 Filter Bar Item 15 ? 16 ScreenAction 19 View 29 DocFolder 32 FilterBariTemSubFilter 33 Calendar 34 CalendarXFilter 35 FilterBarAction 36 FilterBarItemAction 59 OutlookTaskPaneSection 73 ClassXFolder 82 ClassDirectCreate 94 MobileApp 104 Keyword mapping & module associations

Your list is way more populated than mine. 

Great information. 

I didn't mention it before, but we are running version 17. 

[Larissa_Armand]

Oh, I think that would change things if you are on version 17. We are on 18 and my understanding is there were changes made between 17 and 18 for how WV info is stored in the database.