SOLVED SQL Query to get all hardware model type

[tata789]

hello
please can someone help me I am using SCCM 1710 and SQL 2014 for reporting
I am looking SQL query to get all Hardware type list
model type
Hardware name like DELL, HP lenovo
Bios Ver
etc...

thank you for your help
Arun

 

[Prajwal Desai]

Check this - https://gallery.technet.microsoft.com/Configuration-Manager-Most-071cfd38

 

[tata789]

Hello
this is for SQL 2014 and higher version ? on post his writing foe SQL 2012, I hope it will be same
thank you for your help
thank you
Arun

 

[Edy]

Select
comp.Name0 as [Machine Name],
comp.Manufacturer0 as [Manufacturer],
comp.Model0 as [Model],
bios.SerialNumber0 as [Serial Number],
comp.UserName0 as [User Name],
vrs.Last_Logon_Timestamp0 as [Last Logon Timestamp],
ops.Caption0 as [Operating System],
prod.Version0 as [Version],
vrs.AD_Site_Name0 as [Site]
from
v_GS_COMPUTER_SYSTEM comp inner join
v_GS_OPERATING_SYSTEM ops on ops.ResourceID=comp.ResourceID inner join
v_GS_PC_BIOS bios on bios.ResourceID=comp.ResourceID inner join
v_GS_COMPUTER_SYSTEM_PRODUCT prod on comp.ResourceID=prod.ResourceID inner join
v_R_System vrs on comp.ResourceID=vrs.ResourceID inner join
v_FullCollectionMembership on vrs.ResourceID=v_FullCollectionMembership.ResourceID inner join
v_Collection on v_FullCollectionMembership.CollectionID=v_Collection.CollectionID
where v_Collection.CollectionID='CollectionID'

 

[tata789]

thank you all for your help