Ku pamięci – Historyczne migracje w bazie danych ADMT

  • Article

Szybka notka z pola walki z ADMT. Zeby wyciagnac dane na temat przeszlych migracji z Active Directory Migration Toolkit mozna uzyc Management Studio i ponizszego zapytania SQL:

 use admt
SELECT sourceObject.SamName as 'SourceSAMAccountName'
  , sourceDomain.DnsName as 'SourceDomain'
  , '' + sourceDomain.[sid] + '-' + convert(nvarchar,sourceObject.[rid]) as 'SourceSID'
  , targetObject.samname as 'targetSAMAccountName'
  , targetDomain.dnsname as 'TargetDomain'
  , '' + targetDomain.[sid] + '-' + convert(nvarchar,targetObject.[rid]) as 'TargetSID'
  , sourceObject.[Type] as objectType
  
  FROM [ADMT].[dbo].[MigratedObjects]
  join dbo.[Objects] as sourceObject on [MigratedObjects].[SourceObjectId] = sourceObject.ObjectId
  join dbo.[Domains] as sourceDomain on sourceObject.DomainId = sourceDomain.DomainId
  join dbo.[Objects] as targetObject on [MigratedObjects].[targetObjectId] = targetObject.ObjectId
  join dbo.[Domains] as targetDomain on targetObject.DomainId = targetDomain.DomainId