Extract Data from Active Directory

This topic provides step-by-step instructions for running the stand-alone AppDNA AD and ConfigMgr Data Extraction Tool to extract data from Active Directory (AD) for loading into AppDNA.

This topic assumes that you have received the ADConfigMgrExportTool.zip package from the AppDNA administrator and that you have stored it in a suitable location in your file system.


The AppDNA AD and ConfigMgr Data Extraction tool does not work on Microsoft Windows Server 2012 R2. The tool requires the installation of Visual C++ Redistributable for Visual Studio 2015. To work around this issue, download Visual C++ Redistributable for Visual Studio 2015 from: https://www.microsoft.com/en-us/download/details.aspx?id=48145

  1. In Windows Explorer, locate the ADConfigMgrExportTool.zip package.

  2. Right-click the ADConfigMgrExportTool.zip package, and from the shortcut menu, choose Extract All.

  3. In the Extract Compressed (Zipped) Folders dialog box, select a suitable location, and then click Extract.

  4. When the extraction is complete, in Windows Explorer navigate to the folder that contains the extracted files.

  5. Double-click the ADSCCMExportTool.exe file.

    This starts the wizard.

  6. In the Source Selection step in the wizard, choose Active Directory (AD), and then click Next.

  7. In the Active Directory Connection Details step, enter the details as follows:

    Option Description
    Domain controller Enter the name of the Active Directory domain or leave blank to automatically use the domain to which your machine is connected. If you want to extract data from multiple domains (for example, all of the domains that belong to a forest), you need to run through the wizard for each domain.
    Username Leave blank to use the credentials of the logged on Windows user, or specify a user name to use to connect to Active Directory.
    Password If you entered a user name, specify its password here.
  8. Click Next.

  9. In the Organizational Units (OUs) step, select the OUs that you want to extract for loading into AppDNA. Typically you want to select the OUs to which applications have been deployed through AD, or that contain the users and devices to which applications have been deployed through Configuration Manager.

    By default, when you select an OU, the wizard automatically selects any sub-OUs. To change this behavior, clear the Automatically select nested OUs check box.

  10. Click Next.

  11. Check the details in the Summary step, and then click Next.

  12. In the Save As dialog box, enter a suitable name and location for the extracted data, and then click Save.

    Note: Ensure the file has an .sgz filename extension.

    The wizard then starts extracting the data and displays information that provides an indication of the progress. Depending on how much data you are extracting, this process can take a considerable amount of time (several hours, for example).

  13. When the Progress step shows that the operation is complete, click Finish.

  14. If you want to extract data from another domain, repeat steps 5 to 13 for the next domain.

You now need to send the (.sgz) file or files containing the extracted data to the AppDNA administrator for loading into AppDNA.

Extract Data from Active Directory