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'

4 comments:

  1. These articles are exactly what I need. It is very nice of you to share your understanding. I have learned interesting things. I have a liking for your posts. Please, upload more and more posts.pop website pop price guide app

    ReplyDelete
  2. I really appreciate for this great information, This type of message always inspiring and I prefer to read quality content. so happy to find good place to many here in the post. the writing is just great. thanks for the post.shopify best currency converter , sale discount app on Shopify , Create Discount master , best apps to boost sales on shopify

    ReplyDelete
  3. 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
  4. เพื่อให้ทางเพื่อน สมาชิก ของเว็บไซต์ vk betflix สล็อตออนไลน์ โบนัสไม่อั้น เว็บพนัน ออนไลน์ ที่ให้บริการ เกมสล็อต pg slot โดยตรง ได้เข้ามา เลือกเล่น betflix

    ReplyDelete