SCCM – Hardware and Client Version SQL Query
If you are looking for a SQL query to pull back hardware inventory information and the SCCM client version, then you can use the below to pull all this information together.
SELECT S.Name0 as Name, S.Client_Version0 as [Cient Version], OS.Caption0 as [Operating System], CS.Manufacturer0 as Manufacturer, CS.Model0 as Model, PB.SMBIOSBIOSVersion0 as BIOS, PR.Name0 as CPU, SUM(PM.Capacity0) as Memory, SUM(LD.Size0)as [Disc Size], SUM(LD.FreeSpace0) as [Disc Free] FROM v_R_System S join v_GS_OPERATING_SYSTEM OS on S.ResourceID = OS.ResourceID join v_GS_PHYSICAL_MEMORY PM on S.ResourceID = PM.ResourceID join v_GS_COMPUTER_SYSTEM CS on S.ResourceID = CS.ResourceID join v_GS_LOGICAL_DISK LD on S.ResourceID = LD.ResourceID join v_GS_PC_BIOS PB on S.ResourceID = PB.ResourceID join v_GS_PROCESSOR PR on S.ResourceID = PR.ResourceID WHERE LD.DeviceID0 = 'C:' GROUP BY S.ResourceID, S.Name0, S.Client_Version0, OS.Caption0, CS.Manufacturer0, CS.Model0, PB.SMBIOSBIOSVersion0, PR.Name0
These may also help you...
- How to Mass Unfollow on Instagram Online
- Windows Server 2008 R2 Evaluation Product Keys
- How to Mass Unfollow Everyone on Twitter
If you have any questions or feedback about this post, or if you would like us to create any queries for you, please go ahead and leave us a message below in the comments section and we will get back to you as quick as we can.