dbo.QER_FTEntitlementSourceWho

1create   function dbo.QER_FTEntitlementSourceWho(
2											@ObjectKeyToInspect varchar(138)
3											)
4	returns @erg table (
5						UID_Person varchar(38) collate database_default
6						)
7 as
8begin
9
10	if @ObjectKeyToInspect like '<Key><T>ADSAccount</T>%'
11	 begin
12	  insert into @erg(uid_person)
13	  select /*distinct */ xx.UID_Person
14	   from dbo.GEN_FTEOE3FC1F72D986050366C6F0 (@ObjectKeyToInspect) as xx
15
16	   goto EndLabel
17
18	 end -- ADSAccount
19
20	if @ObjectKeyToInspect like '<Key><T>ADSAccountInADSGroup</T>%'
21	 begin
22	  insert into @erg(uid_person)
23	  select /*distinct */ xx.UID_Person
24	   from dbo.GEN_FTEOCBE1F5EFEA131E8729A6FF (@ObjectKeyToInspect) as xx
25
26	   goto EndLabel
27
28	 end -- ADSAccountInADSGroup
29
30	if @ObjectKeyToInspect like '<Key><T>ADSContact</T>%'
31	 begin
32	  insert into @erg(uid_person)
33	  select /*distinct */ xx.UID_Person
34	   from dbo.GEN_FTEO232AA5350399AF5B5E7FC8 (@ObjectKeyToInspect) as xx
35
36	   goto EndLabel
37
38	 end -- ADSContact
39
40	if @ObjectKeyToInspect like '<Key><T>ADSContactInADSGroup</T>%'
41	 begin
42	  insert into @erg(uid_person)
43	  select /*distinct */ xx.UID_Person
44	   from dbo.GEN_FTEOC7B20A6BD971728008EA89 (@ObjectKeyToInspect) as xx
45
46	   goto EndLabel
47
48	 end -- ADSContactInADSGroup
49
50	if @ObjectKeyToInspect like '<Key><T>ADSContainer</T>%'
51	 begin
52	  insert into @erg(uid_person)
53	  select /*distinct */ xx.UID_Person
54	   from dbo.GEN_FTEO9EF81AB6EE40C7C1070D2B (@ObjectKeyToInspect) as xx
55
56	   goto EndLabel
57
58	 end -- ADSContainer
59
60	if @ObjectKeyToInspect like '<Key><T>ADSDomain</T>%'
61	 begin
62	  insert into @erg(uid_person)
63	  select /*distinct */ xx.UID_Person
64	   from dbo.GEN_FTEO23E9A1A9473A3635194231 (@ObjectKeyToInspect) as xx
65
66	   goto EndLabel
67
68	 end -- ADSDomain
69
70	if @ObjectKeyToInspect like '<Key><T>ADSGroup</T>%'
71	 begin
72	  insert into @erg(uid_person)
73	  select /*distinct */ xx.UID_Person
74	   from dbo.GEN_FTEO6FE29BD24EE8070A0F58FF (@ObjectKeyToInspect) as xx
75
76	   goto EndLabel
77
78	 end -- ADSGroup
79
80	if @ObjectKeyToInspect like '<Key><T>DepartmentHasADSGroup</T>%'