Tuesday, February 17, 2015

SCCM Computer Model SQL report

This is a sample report for HP Elitebook 8440p model. You can replace the expected model value. 

select distinct 
a.Name0 as 'Host Name', 
a.UserName0 as 'UserName', 
c.Caption0 as 'OS Detail', 
a.Model0 as 'Model' 
from v_GS_COMPUTER_SYSTEM a
inner join v_GS_OPERATING_SYSTEM c on c.ResourceID=a.ResourceID
where a.Model0 like 'HP EliteBook 8440p%'