Hi,
When I run the "Hardware 03A - Primary computer users" report or another report I created and need to give me the Primary users of the devices, some users are missing in the report even though they appear in the console.
For example, this is the query of the report I created:
SELECT
CS.Manufacturer0,
CS.Model0,
CS.Name0,
CS.UserName0,
BIOS.SerialNumber0
FROM
dbo.v_R_System_Valid RV
Inner join dbo.v_GS_COMPUTER_SYSTEM CS on RV.ResourceID = CS.ResourceID
Inner JOIN dbo.v_GS_PC_BIOS BIOS on RV.ResourceID = BIOS.ResourceID
Inner join dbo.v_FullCollectionMembership FCM on RV.ResourceID = FCM.ResourceID
inner join dbo.v_Collection Coll on Coll.CollectionID = FCM.CollectionID
Where
fcm.CollectionID in (@CollectionID)
In a report, the primary user is missing about a third of the devices. In the SCCM console the primary user appears correctly.
What could be the cause of this and how to fix it?
Thanks for the help