dynamic 365 查询管理员id和管理员业务部门

declare @ADMINID uniqueidentifier --管理员ID
declare @AdminBuID uniqueidentifier --管理员业务部门
declare @organizationid uniqueidentifier
---获得管理员与部门信息
select top (1) @ADMINID=su.SystemUserId,@AdminBuID=su.BusinessUnitId 
from 
 SystemUser su
join 
 SystemUserRoles sr on su.SystemUserid = sr.SystemUserid
join 
 [Role] r on r.roleid = sr.roleid
where 
 r.name ='系统管理员' order by su.CreatedOn asc
--获得组织
select @organizationid = id from Organization where databasename='HXCRM_MSCRM'


SELECT @organizationid

SELECT @AdminID as OwnerId
SELECT @AdminBuID as OwningBusinessUnit