Welcome to Dirteam.com/ActiveDir.org Blogs Sign in | Join | Help

Today I was playing with "ServerManagerCMD.EXE" Windows Server 2008 R2. When I executed it I saw the following informational message:

"Servermanagercmd.exe is deprecated, and is not guaranteed to be supported in future releases of Windows. We recommend that you use the Windows PowerShell cmdlets that are available for Server Manager."

 

It was created in Windows Server 2008 and it is already deprecated! J

It is not really a surprise, because Microsoft is going all the way with PowerShell and more and more products are becoming PowerShell-enabled. Also see this post on how to use snap-ins/modules.

 

So instead of….

ServerManagerCmd.exe

Installs and removes roles, role services and features. Also displays the list of all roles, role services, and features available, and shows which are installed on this computer. For additional information about the roles, roles services, and features that you can specify using this tool, refer to the Help for Server Manager.

-query [<query.xml>] [-logPath <log.txt>]

-install <name>

[-resultPath <result.xml> [-restart] | -whatIf] [-logPath <log.txt>]

[-allSubFeatures]

-remove <name>

[-resultPath <result.xml> [-restart] | -whatIf] [-logPath <log.txt>]

-inputPath <answer.xml>

[-resultPath <result.xml> [-restart] | -whatIf] [-logPath <log.txt>]

-help | -?

-version

Switch Parameters:

-query [<query.xml>]

Display a list of all roles, role services, and features available, and shows which are installed on this computer. (Short form: -q) If <query.xml> is specified, the information is also saved to a query.xml file with additional information.

-inputPath <answer.xml>

Installs or removes the roles, role services, and features specified in an XML answer file, the path and name of which is represent by <answer.xml>. (ShortForm: -ip)

-install <name>

Installs the role, role service, or feature on the computer that is specified by the <name> parameter. Multiple roles, role services or features must be separated by spaces. (ShortForm: -i)

-allSubFeatures

Used with the -install parameter to install all subordinate role services and features along with the role, role service, or feature named with the -install parameter. (Short form: -a)

-remove <name>

Removes the role, role service, or feature from the computer that is specified by the <name> parameter. Multiple roles, role services or features must be separated by spaces. (ShortForm: -r)

-resultPath <result.xml>

Saves the result of the ServerManagerCmd.exe operation to a <result.xml> file, in XML format. (Short form: -rp)

-restart

Restarts the computer automatically, if restarting is necessary to complete the operation.

-whatIf

Display the operations to be performed on the current computer that are specified in the answer.xml file. (Short form: -w)

-logPath <log.txt>

Specify the non-default location for the log file. (Short form: -l)

-help

Display help information. (Short form: -?)

-version

Display the version of the Server Manager command that is running, Microsoft trademark information, and the operating system.

(Short form: -v)

 

Examples:

ServerManagerCmd.exe -query

ServerManagerCmd.exe -install Web-Server -resultPath installResult.xml

ServerManagerCmd.exe -inputPath install.xml -whatIf

 

You should start using….

For Server Manager with PowerShell you should do the following:

  • Start PowerShell (e.g. from the command-line type POWERSHELL)
  • Import the Server Manager Module with: Import-Module ServerManager
  • You will get the following cmdlets to list/add/remove features AND roles:
    • Get-WindowsFeature --> lists available features and roles and which features and roles are installed at that moment
    • Add-WindowsFeature --> installs a feature or role
    • Remove-WindowsFeature --> removes a feature or role

 

Also check out: http://technet.microsoft.com/en-us/library/dd378896(WS.10).aspx

 

Cheers,

Jorge

--------------------------------------------------------------------------------------------------
* This posting is provided "AS IS" with no warranties and confers no rights!
* Always test before implementing!
--------------------------------------------------------------------------------------------------
############### Jorge's Quest For Knowledge ###############
######## http://blogs.dirteam.com/blogs/jorge/default.aspx #########
--------------------------------------------------------------------------------------------------

This is the way to determine which PowerShell Snap-Ins and Modules are available in Windows Server 2008 R2…

 

PS C:\> Get-PSSnapin

Name : Microsoft.PowerShell.Diagnostics

PSVersion : 2.0

Description : This Windows PowerShell snap-in contains Windows Eventing and Performance Counter cmdlets.

 

Name : Microsoft.WSMan.Management

PSVersion : 2.0

Description : This Windows PowerShell snap-in contains cmdlets (such as Get-WSManInstance and Set-WSManInstance) that are used by the Windows PowerShell host to manage WSMan operations.

 

Name : Microsoft.PowerShell.Core

PSVersion : 2.0

Description : This Windows PowerShell snap-in contains cmdlets used to manage components of Windows PowerShell.

 

Name : Microsoft.PowerShell.Utility

PSVersion : 2.0

Description : This Windows PowerShell snap-in contains utility Cmdlets used to manipulate data.

 

Name : Microsoft.PowerShell.Host

PSVersion : 2.0

Description : This Windows PowerShell snap-in contains cmdlets (such as Start-Transcript and Stop-Transcript) that are provided for use with the Windows PowerShell console host.

 

Name : Microsoft.PowerShell.Management

PSVersion : 2.0

Description : This Windows PowerShell snap-in contains management cmdlets used to manage Windows components.

 

Name : Microsoft.PowerShell.Security

PSVersion : 2.0

Description : This Windows PowerShell snap-in contains cmdlets to manage Windows PowerShell security.

 

….Loading the Snap-In is done by: Add-PSSnapin <String Name>
(e.g. Add-PSSnapin Microsoft.PowerShell.Security)

 

PS C:\> Get-Module -ListAvailable

ModuleType Name ExportedCommands
----------------------- -------------------------
Manifest ActiveDirectory {}
Manifest ADRMS {}
Manifest AppLocker {}
Manifest BestPractices {}
Manifest BitsTransfer {}
Manifest GroupPolicy {}
Manifest PSDiagnostics {}
Manifest ServerManager {}
Manifest TroubleshootingPack {}
Manifest WebAdministration {}

 

….Loading the Module is done by: Import-Module <ModuleType Name>
(e.g. Import-Module ActiveDirectory)

 

Cheers,

Jorge

--------------------------------------------------------------------------------------------------
* This posting is provided "AS IS" with no warranties and confers no rights!
* Always test before implementing!
--------------------------------------------------------------------------------------------------
############### Jorge's Quest For Knowledge ###############
######## http://blogs.dirteam.com/blogs/jorge/default.aspx #########
--------------------------------------------------------------------------------------------------

To provision IM-enabled AD accounts this is what you can do in your provisioning code for the AD MA… (example code snippet from my test/demo environment)

 

If mventry("im").Value.ToLower = "yes" Then
Dim strSIPDomain As String
Dim strSIPHomeServer As String
strSIPDomain = AD_DS_Production_USERS_MA_Params("sipdomain")
strSIPHomeServer = AD_DS_Production_USERS_MA_Params("siphomeserver")
AD_DS_Production_USERS_CsEntry("msRTCSIP-PrimaryUserAddress").Value = "sip:" & Replace(mventry("displayName").Value, " ", ".") & strSIPDomain
AD_DS_Production_USERS_CsEntry("msRTCSIP-PrimaryHomeServer").Value = strSIPHomeServer
AD_DS_Production_USERS_CsEntry("proxyAddresses").Values.Add("sip:" & Replace(mventry("displayName").Value, " ", ".") & strSIPDomain)
AD_DS_Production_USERS_CsEntry("msRTCSIP-OptionFlags").Value = "256"
AD_DS_Production_USERS_CsEntry("msRTCSIP-ArchivingEnabled").Value = "0"
AD_DS_Production_USERS_CsEntry("msRTCSIP-UserEnabled").BooleanValue = True
End If

 

Sipdomain and siphomeserver are values stored as parameters in an XML file. Another thing to note is that "msRTCSIP-PrimaryHomeServer" needs a DN to an OCS pool, but it is NOT a reference attribute. It is a string attribute!

 

Cheers,

Jorge

--------------------------------------------------------------------------------------------------
* This posting is provided "AS IS" with no warranties and confers no rights!
* Always test before implementing!
--------------------------------------------------------------------------------------------------
############### Jorge's Quest For Knowledge ###############
######## http://blogs.dirteam.com/blogs/jorge/default.aspx #########
--------------------------------------------------------------------------------------------------

I found the following once in a presentation. It gives you an idea of "Today's IT Infrastructure". ;-)

Looks complex!

 

 

Cheers,

Jorge

----------------------------------------------------------------------------------------

Technorati Tags:

--------
* This posting is provided "AS IS" with no warranties and confers no rights!
* Always test before implementing!
------------------------------------------------------------------------------------------------

Are you having issues with Hyper-V VMs and experiencing similar issues as explained here? The solution to these issues is to fix the permissions of the Hyper-V, but do you know exactly what permissions are needed or what's missing? Stop thinking!

Use the script attached to this post or as shown below. How does it work?

The script is used as a drop-target. A what? A drop-target! Select all the corresponding Hyper-V VM folders and files and drop it on the icon of the script. At that point the script will figure out the correct permissions that are needed to use the VM in Hyper-V.

Let's talk credits. Credits should go to me for posting this stuff while being watched! J

Credits for the script go to a person that:

  • Is British
  • Used to be an MVP for Directory Services
  • Loves scripting, especially "batch" (he wanted to create a spell checker in batch)
  • Now loves PowerShell
  • Would like to sell that to the world as "PoSH"
  • Now walks the grounds of the "Dark Side" managing DS Stuff
  • Appeared in some cool video a few months back wearing weird stuff

I think you now know who he is. If you don't you'll figure it out some way! J Trust me!

------------------------------------------

:: fix HyperV ACLs.CMD / Dean Wells (DeanWe), Microsoft / October 2008

:: Script adds a suitable ACE (NT Virtual Machines\Virtual Machines or VM-specific) to any number of files supplied as arguments

:: (drag and drop works best) permitting them to be used by the Windows HyperVisor without rendering permissions errors. Special

:: case logic is included to handle symlinks and the permissioning differences required between VHDs and XML configuration files.

@echo off

set issuingAUTHORITY=NT Virtual Machine

set groupPRINCIPAL=Virtual Machines

set EXITcommand=pause

set FAILED=0

set FAILEDfile="%TEMP%\%~n0.$$$"

del %FAILEDfile% 1>nul 2>&1

title Hyper-V ACL fixerupper ...

if "%~1"=="" (

    echo/

    echo #ERROR - nothing to do!

    goto :END

)

echo/

:LOOP

:: Restore default environment for each iteration

set icaclsSUFFIX=

set SECURITYprincipal=%groupPRINCIPAL%

set shortSECURITYprincipal=Group ACE

set PERMISSION=RW

set FILEtype=%~x1

:: Assume the absence of an extension indicates a folder [it's not pretty but it'll do in this context]

if "%FILEtype%"=="" (

    set FILEtype=folder

    set icaclsSUFFIX=/t

)

:: Determine file type [VHDs require "RW" while the XML configuration files and their symlinks require "F"]

:: For VHDs, we assume many VMs _may_ require access to the file so we add the "NT Virtual Machine\Virtual Machines" ACE

:: For XML configuration files and their symlinks, we treat those as private and add the VM-specific ACE

echo "%~a1" | find /i "l" 1>nul 2>&1

if not errorlevel 1 (

    set icaclsSUFFIX=/l

    set FILEtype=symlink

    set SECURITYprincipal=%~n1

    set shortSECURITYprincipal=VM ACE

    set PERMISSION=F

) else (

    if /i "%FILEtype%"==".xml" (

        set PERMISSION=F

        set SECURITYprincipal=%~n1

        set shortSECURITYprincipal=VM ACE

    )

)

set HYPERVfile=%~n1 [%FILEtype% / %shortSECURITYprincipal%:%PERMISSION%] ..............................................

set HYPERVfile=%HYPERVfile:~0,67%

set /p=+ %HYPERVfile% <nul

icacls "%~1" /grant "%issuingAUTHORITY%\%securityPRINCIPAL%":%PERMISSION% %icaclsSUFFIX% 1>nul 2>&1

if errorlevel 1 (

    icacls "%~1" /grant "%issuingAUTHORITY%\%groupPRINCIPAL%":%PERMISSION% %icaclsSUFFIX% 1>nul 2>&1

    if errorlevel 1 (

        set FAILED=1

        echo #FAILED!

        echo %~n1 [%FILEtype% / %shortSECURITYprincipal%:%PERMISSION%] >>%FAILEDfile%

    ) else (

        echo SUCCESS!

    )

) else (

    echo SUCCESS!

)

shift

if not "%~1"=="" goto :LOOP

echo/

if not "%FAILED%"=="1" (

    color 2E

    echo The command completed successfully.

    set EXITcommand=ping -n 6 localhost

) else (

    color 4E

    echo #ERROR - the following Hyper-V fileSleep was/were not permissioned correctly:

    echo/

    type %FAILEDfile%

)

:END

%EXITcommand% 1>nul 2>&1

------------------------------------------

Cheers,

Jorge

--------------------------------------------------------------------------------------------------
* This posting is provided "AS IS" with no warranties and confers no rights!
* Always test before implementing!
--------------------------------------------------------------------------------------------------
############### Jorge's Quest For Knowledge ###############
######## http://blogs.dirteam.com/blogs/jorge/default.aspx #########
--------------------------------------------------------------------------------------------------

If you have exported a Hyper-V VM to a folder and then try to import it again on another computer for example, you might get the following error:

 

[Window Title]
Hyper-V Manager

[Main Instruction]
A server error occurred while attempting to import the virtual machine.

[Content]
Import failed.

[Expanded Information]
Import failed. Unable to save the virtual machine under location 'E:\VMStore\_HYPER-V_EXPORTS\OCG_ILM2DEMO-Server\'. Error: General access denied error (0x80070005)

Cake Hide details [Close]

 

I solved this by giving the Network Service account modify permissions to the folder and its subfolders that contained the VM Export. Worked like a charm for me.

 

Cheers,

Jorge

--------------------------------------------------------------------------------------------------
* This posting is provided "AS IS" with no warranties and confers no rights!
* Always test before implementing!
--------------------------------------------------------------------------------------------------
############### Jorge's Quest For Knowledge ###############
######## http://blogs.dirteam.com/blogs/jorge/default.aspx #########
--------------------------------------------------------------------------------------------------

 

The following AD Forest Recovery Guides are available:

 

Cheers,

Jorge

--------------------------------------------------------------------------------------------------
* This posting is provided "AS IS" with no warranties and confers no rights!
* Always test before implementing!
--------------------------------------------------------------------------------------------------
############### Jorge's Quest For Knowledge ###############
######## http://blogs.dirteam.com/blogs/jorge/default.aspx #########
--------------------------------------------------------------------------------------------------

Get those docs here

 

Cheers,

Jorge

--------------------------------------------------------------------------------------------------
* This posting is provided "AS IS" with no warranties and confers no rights!
* Always test before implementing!
--------------------------------------------------------------------------------------------------
############### Jorge's Quest For Knowledge ###############
######## http://blogs.dirteam.com/blogs/jorge/default.aspx #########
--------------------------------------------------------------------------------------------------

The Microsoft Active Directory Management Gateway Service lets information technology professionals manage Active Directory Directory Service and Active Directory Lightweight Directory Service instances that are running on the same server. The Active Directory Management Gateway Service is available as part of Windows Server 2008 R2 and available as a separate download for some previous versions of Windows Server 2008 and Windows Server 2003.

Information technology professionals can use Active Directory Module for Windows PowerShell or Microsoft Active Directory Administrative Center (ADAC) to manage Active Directory Management Gateway Service instances on servers that are running Windows Server 2008 Service Pack 1 (SP1) and later versions and Windows Server 2003 Service Pack 2 (SP2) and later versions.

The Active Directory Management Gateway Service provides the same functionality as Active Directory Web Services on Windows 7. After you install the Active Directory Management Gateway Service, the service runs as the Windows Server R2 Active Directory Web Services service

 

For more info see KB article: The Active Directory Management Gateway Service is now available

 

It looks like it is not yet available for download. Don't worry, it will be soon, I guess, RGHT? J

 

Cheers,

Jorge

--------------------------------------------------------------------------------------------------
* This posting is provided "AS IS" with no warranties and confers no rights!
* Always test before implementing!
--------------------------------------------------------------------------------------------------
############### Jorge's Quest For Knowledge ###############
######## http://blogs.dirteam.com/blogs/jorge/default.aspx #########
--------------------------------------------------------------------------------------------------

The Read-Only Domain Controller (RODC) Branch Office Guide is now live on TechNet and the Download Center!

  • TechNet: http://technet.microsoft.com/en-us/library/dd734758(WS.10).aspx
  • Download Center: http://go.microsoft.com/fwlink/?LinkId=153714

 

The guide covers the major considerations around deploying RODC's in Branch Office scenarios. Specifically, the topics include:

  • Branch Office Environment Characteristics
  • Deciding Which Type of Domain Controller Meets the Needs of a Branch Office Location
  • Updates to Windows Server 2003 Branch Office Guide Recommendations
  • Planning/Deploying/Administering RODCs in Branch Offices
  • Monitoring Your Branch Office Environment

 

Cheers,

Jorge

--------------------------------------------------------------------------------------------------
* This posting is provided "AS IS" with no warranties and confers no rights!
* Always test before implementing!
--------------------------------------------------------------------------------------------------
############### Jorge's Quest For Knowledge ###############
######## http://blogs.dirteam.com/blogs/jorge/default.aspx #########
--------------------------------------------------------------------------------------------------

At the moment Microsoft does not support ILM 2007 FP1 in ANY virtual environment.

 

I have not seen an official statement yet on some Microsoft page, but I have read here that ILM 2007 FP1 now is supported to run on Hyper-V. If you want to run it on VMWare, check out these KB articles from Microsoft about that:

 

Cheers,

Jorge

--------------------------------------------------------------------------------------------------
* This posting is provided "AS IS" with no warranties and confers no rights!
* Always test before implementing!
--------------------------------------------------------------------------------------------------
############### Jorge's Quest For Knowledge ###############
######## http://blogs.dirteam.com/blogs/jorge/default.aspx #########
--------------------------------------------------------------------------------------------------

Reading the Dutch magazine called Quest; I saw the following funny quotes about "The Boss":

 

The biggest mistake a boss can make is by not saying: well done!
(John Ashcroft, American Politician [1942])

By working 8 hours a day, you might become the boss. And suddenly you must work 12 hours a day.
(Robert Frost, American Poet [1874-1963])

Never blame the boss for anything. He's got enough problems already.
(Donald Rumsfeld, Minister of Defense with the George Bush administration [1932])

Nothing is worse than a nervous boss. Especially if you are the one that made him nervous.
(Sidney Cross, American Artist [1921-1969])

If everybody says "you're right!", you are either very smart or the boss.
(André Birabeau, French Play Writer [1890-1974])

If you want to move ahead from a career perspective, you do not need to be the boss' son. Marrying his daughter is enough.
(Orlando Aloysius Battista, Canadian Writer [1917-1995])

 

Cheers,

Jorge

--------------------------------------------------------------------------------------------------
* This posting is provided "AS IS" with no warranties and confers no rights!
* Always test before implementing!
--------------------------------------------------------------------------------------------------
############### Jorge's Quest For Knowledge ###############
######## http://blogs.dirteam.com/blogs/jorge/default.aspx #########
--------------------------------------------------------------------------------------------------

At the moment ILM 2007 FP1 officially supports:

  • SQL Server 2000 SP3a (and higher) Standard or Enterprise (x86/x64)
  • SQL Server 2005 SP1 (and higher) Standard or Enterprise (x86/x64)

 

I have not seen an official statement yet on some Microsoft page, but I have read here that SQL Server 2008 it supported by ILM Sync Engine, ILM Certificate Management, but also as a connected data source. For another MSFT employee I heard that SQL Server 2008 will most likely work with ILM 2007 FP1 RTM, but tests were validated with builds 3.3.11xx.x

 

Cheers,

Jorge

--------------------------------------------------------------------------------------------------
* This posting is provided "AS IS" with no warranties and confers no rights!
* Always test before implementing!
--------------------------------------------------------------------------------------------------
############### Jorge's Quest For Knowledge ###############
######## http://blogs.dirteam.com/blogs/jorge/default.aspx #########
--------------------------------------------------------------------------------------------------

When using ILM 2007 Sync Engine and you would like to have high availability you need to think about the all components of the solution. In the case of ILM 2007 Sync Engine those would be:

  • Windows Server
  • ILM 2007 Sync Engine
  • SQL Server
  • ILM Datastore

 

Windows Server and SQL Server can be made high available through Microsoft Clustering Services.

ILM Datastore can be made high available by putting it on a SAN/NAS/Shared Storage/Whatever, as long as you use a redundant set of disks, or in other words some RAID configuration such as RAID1 (mirroring), RAID5 (disk striping with parity) or RAID10 (mirroring and striping).

OK, but how about the ILM 2007 Sync Engine? For ILM 2007 Sync Engine you have following possibilities:

  • Operational Instance: the ILM instance which is actually running by importing, exporting and synching data between connected data sources (ILM server license needed)
  • HOT Standby Instance: the ILM instance which is NOT running (service = stopped and disabled), but for which its Windows Server is up and running (additional ILM server license needed). For a guide on how to implement this go here.
  • COLD Standby Instance: the ILM instance which is NOT running (service = stopped and disabled), but for which its Windows Server is ALSO NOT up and running (NO additional ILM server license needed)

 

So, when the Operational Instance dies for whatever reason, use need to use the available standby instance (for the COLD standby instance you need to start the server first of course) and activate it by using the MIISACTIVATE tool with the Encryption Keys created by the first ILM instance that was installed for the solution. If you are using password synchronization (PCNS) you need to reconfigure the PCNS object in AD to target the new ILM instance. As you can see that is a manual process. Can you automate it? That depends if you are using something that can automatically switch over to the standby instance.

Is ILM 2007 Sync Engine cluster-aware? Nope, it is not!

Can you install the Operational Instance of ILM 2007 Sync Engine on a Cluster (e.g. the active node) and is it supported by MSFT? Yes, it can be installed on the active cluster node and that is also supported by MSFT.

Can you install the Standby Instance of ILM 2007 Sync Engine on a Cluster (e.g. the passive node) and is it supported by MSFT? Yes, it can be installed on the passive cluster node and that is also supported by MSFT.

 

Even on a cluster you need to manually switch to the standby instance on the passive node by activating it if the operational instance on the active node fails or becomes unavailable.

Can this be automated, so that when the active cluster node dies, ILM automatically switches over to the passive node and would that be supported by MSFT? Yes it is possible to automatically failover ILM by using the script which can be found here. But, is this supported? Unfortunately, it is NOT supported by MSFT! Also take this post into account.

 

Cheers,

Jorge

--------------------------------------------------------------------------------------------------
* This posting is provided "AS IS" with no warranties and confers no rights!
* Always test before implementing!
--------------------------------------------------------------------------------------------------
############### Jorge's Quest For Knowledge ###############
######## http://blogs.dirteam.com/blogs/jorge/default.aspx #########
--------------------------------------------------------------------------------------------------

Based upon my post about "Multiple Authoritative Sources for Group Memberships and how about precedence in ILM", a technology partner and I were setting up and test/demo environment. The idea was as follows.

The MGMT app is authoritative for groups and group memberships, which then flow into AD. Group Membership is established on business logic like for example:

  • Everyone with "JobTitle=Admin" and "Department=ICT" becomes a member of the group "R1Grp_EMPLOYEES_JOB_ICT_ADMIN"
  • Everyone with "employeeType=EMPLOYEES" becomes a member of the group "R1Grp_EMPLOYEES"
  • Etc.

 

However, in AD it must be possible to adjust/establish group memberships that do not follow the business logic. For example, a contractor is added to the group "R1Grp_EMPLOYEES". That new group membership flows (import) from AD to the MV through the "ADDS-Group-IMP" MA. From the MV it flows (export) to the SQL Database (multi-valued table) through the "MGMT-Group-EXP" MA.

 

When a group membership is established in the MGMT APP the following flags should be set in the SQL multiple valued tabled: MGMT=YES & IDM=NO (as properties of that specific group membership)

When a group membership is established in the MGMT APP the following flags should be set in the SQL multiple valued tabled: MGMT=NO & IDM=YES (as properties of that specific group membership)

This way the MGMT APP can check on eventual business conflicts by checking the flags and report on it!

So as a test we wanted to test this by adding a contractor person to the "R1Grp_EMPLOYEES" group. Initially the group "R1Grp_EMPLOYEES" contained 32 employee persons and after the change an extra contractor person was added to it.

What was the expect end result?

  • 32 employee group memberships with the flags MGMT=YES & IDM=NO
  • 1 contractor group membership with the flags MGMT=NO & IDM=YES

 

So I imported the group membership from AD into ILM and exported it to the SQL database.

What was the REAL end result?

  • 32 employee group memberships with the flags MGMT=NO & IDM=YES
  • 1 contractor group membership with the flags MGMT=NO & IDM=YES

 

What the heck?!?! Why are the flags of ALL group memberships for the group "R1Grp_EMPLOYEES" changed as if they were exported? I expect only one INSERT into the table and not 33 INSERTS.

The way to find out is to use SQL Server Profiler and check what's happening under the hood! So let's do this.

Before exporting to ILM I checked the ILM statistics. See picture below.

 

After exporting I checked the SQL Server Profiler Trace and saw the following…

Let's take a look at this trace

  • Yellow marked text: Delete all existing group memberships for the group "R1Grp_EMPLOYEES"
  • Green marked text: Add the new group membership for the new member (the one established in AD)
  • Blue marked text: Add the new group membership for the previously existing members (the ones established in MGMT APP)

 

I wonder WHY ILM works this way…Anyone from the Product Group care to explain? Please do so!

 

Cheers,

Jorge

--------------------------------------------------------------------------------------------------
* This posting is provided "AS IS" with no warranties and confers no rights!
* Always test before implementing!
--------------------------------------------------------------------------------------------------
############### Jorge's Quest For Knowledge ###############
######## http://blogs.dirteam.com/blogs/jorge/default.aspx #########
--------------------------------------------------------------------------------------------------

More Posts Next page »