/* Find metaverse objects with n connectors*/
SELECT
* FROM dbo.mms_metaverse m
INNER JOIN (
SELECT mv_object_id
FROM dbo.mms_csmv_link
GROUP BY mv_object_id
HAVING ( COUNT(mv_object_id) = n )) c
ON
m.object_id = c.mv_object_id
/* Select all objects in CS */
select * from dbo.mms_connectorspace cs
join dbo.mms_management_agent ma
on cs.ma_id = ma.ma_id
where ma.ma_name = ‘Notes’
/* Select joined objects in CS */
select * from dbo.mms_connectorspace cs
join dbo.mms_management_agent ma
on cs.ma_id = ma.ma_id
join dbo.mms_csmv_link mv
on mv.cs_object_id = cs.object_id
where ma.ma_name = ‘Notes’
/* Select objects joined from two CS – get the CS ids from table mms_management_agent */
select distinct mc.mv_object_id, mv.firstName, mv.lastName, mv.mail
from dbo.mms_csmv_link mc
join dbo.mms_csmv_link m1 on mc.mv_object_id=m1.mv_object_id
join dbo.mms_connectorspace cs1 on cs1.object_id = m1.cs_object_id
join dbo.mms_csmv_link m2 on mc.mv_object_id=m2.mv_object_id
join dbo.mms_connectorspace cs2 on cs2.object_id = m2.cs_object_id
join dbo.mms_metaverse mv on mc.mv_object_id = mv.object_id
where cs1.ma_id=’9EF243BA-DB31-411C-BDAF-7DB5925995F9′
and cs2.ma_id=’6CDE8088-67D4-418C-957D-01351C276D87′
About this blog
This blog started out being about MIIS, but has extended to whatever I happen to be working on - particularly when I've had to struggle through incomplete documentation, blog and forum trawls, and good old trial and error to work through a problem. The posts reflect my own homegrown approach to problems I encountered and are entirely based on my own experiences - I will try to avoid theorising!Copyright Notice
All text in this blog is original and the copyright is owned by the author. You are welcome to use the code (without warranty) but please do not copy the articles without asking first.My social media policy
+ I will only accept facebook friend requests from people I know in person.
+ I will only accept linkedin requests from people I have worked with or had at least a few email exchanges with (remind me on the request if this is the case).
+ You are of course welcome to follow me on twitter (@miss_miis).RSS
AD ADAM ADFS Best Practice BPOS Cloud Conferences Email Template Excel Exchange 2003 Exchange 2007 Exchange 2010 FIM 2010 FIM 2010 R2 FIM Sync Service Groups ILM ILM "2" ILM 2007 Logs Lotus Notes MIIS 2003 MiisApp MPR newbie Novell Office 365 OpenLDAP Password Sync Performance Philosophising powershell Quest RCDC Reporting SAP Scripting Sets Sharepoint SQL Uncategorized Unify VB.NET VBScript Windows Server 2003 Windows Server 2008 Workflow
Popular Posts
- A GALSync powershell script
- Adding Exchange 2007 mailboxes to existing user accounts
- Exchange 2007 Cross-Forest Migration
- FIM Walkthroughs – Create the FIM MA
- FIM Walkthroughs – Planning and Installation
- Importing groups from AD to the FIM Portal using classic flow rules
- Password Sync from AD to BPOS
- Powershell Custom WF Activity
- Running Remote Powershell scripts from VB.NET
Pages
Archives
-
Blogroll
- Kim Cameron's Indentity Weblog
Close preview
Loading... - Jackson's Identity Management & Active Directory Reality Tour Travelblog
Close preview
Loading... - Tomek's DS World
Close preview
Loading... - IT Mum
Close preview
Loading... - 1dent1ty cHa0s
Close preview
Loading... - Clint Boessen
Close preview
Loading... - TechNet Flash Feed
Close preview
Loading... - You Had Me At EHLO
Close preview
Loading... - PuttyQ
Close preview
Loading... - Jorge 's Quest For Knowledge!
Close preview
Loading... - FIM / ILM Best Practices
Close preview
Loading... - IdM Crisis
Close preview
Loading... - ADdict
Close preview
Loading... - Anthony Ho
Close preview
Loading... - CShark
Close preview
Loading... - Darryl Russi's Blog
Close preview
Loading... - Gil's Blog
Close preview
Loading... - Identity Management Extensibility
Close preview
Loading... - Identity Underground
Close preview
Loading... - IdM for Real
Close preview
Loading... - Identity Trench
Close preview
Loading... - FIM 2010 Technet Wiki Articles
Close preview
Loading... - Identity Minded
Close preview
Loading...
- Kim Cameron's Indentity Weblog