Skip to content
Josiah Pewterbaugh
  • Twitter
  • GitHub
  • LinkedIn
Night Mode
Text Size

IT Professional

SQL

Query to find all hardware models – including Lenovo

Posted on Published April 22, 2020April 22, 2020 by Josiah Pewterbaugh

I needed to find all the hardware models in our environment. Lenovo stores their model name in ‘version’ instead of ‘model’ like other vendors. I ran the following SQL code on our SCCM/MECM database to get the data I needed. This code can be converted to a report in SSRS or used in PowerShell. If […]

© 2023 Josiah Pewterbaugh

Perfection is the enemy of progress!