Thank you for reaching out to Microsoft Q&A forum
Based on your descriptions and attached images I have developed several preliminary thoughts regarding the potential cause of this behavior.
Kindly note that these are my observations based on personal knowledge and available resources. As a forum moderator, my testing environment is not fully adequate to simulate the problem and provide completely accurate solutions. However, you may find them helpful as a new insight.
Initially, regarding your concern: Is AD attempting to send the results back to the SharePoint farm via a URL? If so, which URL?...
Based on my research in this DOCUMENT, in SharePoint Server SE, User Profile “synchronization” (when using SharePoint Active Directory Import / AD Import) is not a round‑trip process where Active Directory “posts results back” to your farm through a web application URL.
Instead, the SharePoint User Profile Service Application is configured to use AD Import and then creates a synchronization connection to Active Directory Domain Services (AD DS). So, that connection defines what objects to import and includes the credentials SharePoint uses to interact with AD DS. In other words, the import is initiated from SharePoint to AD DS, and the data is written into the SharePoint profile databases, there is no dependency on the public URL/DNS of your content web applications for AD to “send back” imported profile data.
From my observation, given your lab-style database‑attach upgrade setup (SE farm running side‑by‑side with production, HOSTS override for the content URL, and DNS still pointing the production web apps to the old farm), that DNS mismatch would not typically explain “no profiles appearing” if AD Import is correctly configured, because AD Import relies on the UPA sync connection and its AD DS scope/credentials, not the content web app URL.
That said, if you’re seeing zero imported profiles, the highest-value validation is to re-check the AD Import synchronization connection scope (selected OUs/containers) and how SharePoint resolves eligible objects
For example, Microsoft documents a case where an “active” user is not imported when AD metadata (like LastKnownParent) effectively places the user outside the selected OU scope, even though the user appears to be in scope.
Below are my suggestions about this situation:
The first step I recommend is to create a support ticket with Microsoft’s Support team directly. Advanced configuration tasks of this nature require specialists who have access to the appropriate diagnostic tools and can provide real‑time guidance throughout the troubleshooting process to ensure accuracy and prevent errors. You can submit a support request using the link below:
Link support: https://support.serviceshub.microsoft.com/supportforbusiness/onboarding?origin=/supportforbusiness/create
In the meantime, you may refer to the two methods outlined below to determine whether they help address the situation:
Option 1: Prove the AD Import timer job is actually running.
In SharePoint AD Import, profiles are brought in by the “User Profile Active Directory Import Job” timer job (it imports directly into the Profile DB), and AD Import is not a bidirectional “AD sends data back to SharePoint URL” process.
If Full Sync flips to Idle with 0 profiles, focus on whether that timer job ran and what it logged. In ULS, filter/search for UserProfileADImportJob and Category = User Profiles (these are the common identifiers used to narrow down AD Import runs).
When sharing logs publicly, you typically only need the exception block + stack trace around the job run (redact domain/usernames/OU paths, keep exception type + call stack).
Option 2: Assume the job runs, then validate “imports zero” causes: scope/filter and the LastKnownParent edge case.
AD Import only imports what your Synchronization Connection is scoped to (OU/container selection + simple LDAP filter). Mis-scope or an over-restrictive filter can result in 0 imported objects even when “Populate Containers” works.
Additionally, I have found the relevant information may help you getting more insight:
https://sharepoint.stackexchange.com/questions/315040/sharepoint-2019-ad-sync-not-working
Note: Microsoft is providing this information as a convenience to you. These sites are not controlled by Microsoft, and Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please ensure that you fully understand the risks before using any suggestions from the above link.
Hope my answer will help you.
Regards
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.