Wednesday, March 23, 2016

MIM metaverse SQL query - manager contributing MA

This is a sequel (no pun intended) to my old post, FIM metaverse SQL query - employeeID contributing MA.  Since 'manager' is a reference attribute, you need a slightly different query than for scalar attributes.

set transaction isolation level read uncommitted

SELECT TOP 1000
       mv.object_type
       ,mv.accountName
       ,mv.domain
       ,l.attribute_name
       ,ma_mgr.ma_name as [manager MA]
FROM [FIMSynchronizationService].[dbo].[mms_mv_link] l
join [FIMSynchronizationService].dbo.mms_metaverse mv
on l.object_id = mv.object_id

left join [FIMSynchronizationService].[dbo].[mms_lineage_cross_reference] cr_mgr
on cr_mgr.lineage_id = l.lineage_id
left join [FIMSynchronizationService].[dbo].[mms_management_agent] ma_mgr
on ma_mgr.ma_id = cr_mgr.ma_id

where object_type = 'person'
and l.attribute_name = 'manager'

2 comments:

  1. My entire working career up until that point had only been the safe route with a large corporation. You know the life. The daily grind. The BS you put up with because you figure this is the ONLY way. I even went on to get a psychology degree because the jobs I had been looking at required it. When I finished my degree I found that the amount of education I had was once again not enough. pakistani lawn suits with chiffon dupatta , 2 piece suit online shopping in pakistan

    ReplyDelete
  2. This comment has been removed by the author.

    ReplyDelete