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.
    kizi unblocked
    Jogos online
    friv school Games to play

    ReplyDelete
  4. 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