Device, primary user and model

A simple query that will present the following information based on what ConfigMgr has inventoried

Computer-name
Primary User(Domain\username)
Manufacturer
Model

SQL;

select umr.MachineResourceName as 'Device name', umr.UniqueUserName as 'Username',
CASE
when CAST(umsr.SourceID as varchar(20)) = '1' then 'Software Catalog'
when CAST(umsr.SourceID as varchar(20)) = '2' then 'Administrator'
when CAST(umsr.SourceID as varchar(20)) = '3' then 'User'
when CAST(umsr.SourceID as varchar(20)) = '4' then 'Usage agent'
when CAST(umsr.SourceID as varchar(20)) = '5' then 'Device Management'
when CAST(umsr.SourceID as varchar(20)) = '6' then 'OSD'
when CAST(umsr.SourceID as varchar(20)) = '7' then 'Fast Install'
else CAST(umsr.SourceID as varchar(20)) END as 'Source',
cs.Manufacturer0 AS 'Manufacturer',
CASE
when cs.Manufacturer0 = 'Lenovo' Then hwdata.Version0
else cs.Model0
END as Model
from v_UserMachineRelationship as umr
inner join v_UserMachineSourceRelation as umsr on umr.RelationshipResourceID = umsr.RelationshipResourceID
inner JOIN v_GS_COMPUTER_SYSTEM AS cs ON umr.MachineResourceID = cs.ResourceID
left join v_GS_COMPUTER_SYSTEM_PRODUCT as hwdata on umr.MachineResourceID = hwdata.resourceid