SCCM database views

BIOS\wmi problems with  computer model name:

Version like ThinPad T540p or Lenovo product can be found:
v_GS_COMPUTER_SYSTEM_PRODUCT

Sample query to display also computer name from v_R_System view:
SELECT csp.ResourceID, csp.Version0, rs.Name0
  FROM [CM_KR1].[dbo].[v_GS_COMPUTER_SYSTEM_PRODUCT] csp inner join [CM_KR1].[dbo].[v_R_System]  rs on
  csp.ResourceID = rs.ResourceID

or WQL query for SCCM console:

select csp.Version, csp.ResourceID, rs.Name
from  SMS_R_System as rs inner join SMS_G_System_COMPUTER_SYSTEM_PRODUCT as csp
on csp.ResourceID = rs.ResourceId
where csp.Version = 'Lenovo Product'

hjhj