Skip to content

Missing primary user values for clients

Problem: Primary User values are empty in vScope for SCCM/MECM clients.
Goal: Confirm the data exists and that the SCCM probe can read it.

  1. Check the table with the vScope credential

    SELECT TOP 5 * FROM [CM_<site>].[dbo].[v_UsersPrimaryMachines];

    Expected: rows with Primary User data. If empty or permission denied, continue.

  2. Check with a higher-privilege account
    Run the same query with an elevated SQL login.

  3. Verify SCCM configuration (User-Device Affinity)
    Ensure user-device affinity is enabled and populated in SCCM so v_UsersPrimaryMachines contains data. Microsoft guide: https://learn.microsoft.com/mem/configmgr/apps/deploy-use/link-users-and-devices-with-user-device-affinity

  4. Target the right site DB
    Point the connector to a Primary Site DB (CM_<site>), not just the CAS, since primary sites often hold more complete client data.

  5. Rerun SCCM discovery in vScope
    After adjustments, rerun the SCCM discovery and re-check Tables/Properties for Primary User values.