Query – Add-Ons assigned to users.

Quety:  Add-Ons assigned to users – SAPB1

Con estos query podrán saber que usuarios tienen add-ons instalados y asignados en SAPB1.

select T0.USER_CODE,T1.AddOnId,T1.AName,T1.EName,T1.[NameSpace],T0.AddOnType,T0.EnableFlag,T1.AddOnVer

from ARI1 T0 inner join [SBO-COMMON].[dbo].[SARI] T1 on T1.AddOnId=T0.AddOnID

— ===========================================================================================

select T0.USER_CODE,T1.AddOnId,T1.AName,T1.EName,T1.[NameSpace],T0.AddOnType,T0.EnableFlag,T1.AddOnVer

from [SBO-COMMON].[dbo].[SARI] T1 left join ARI1 T0 on T1.AddOnId=T0.AddOnID

Saludos.

edd