hi all 

i have a sccm db i need to get all system hardware info where sql server is installed

result set should be

sql version

 system processor info 

can u help on this 

• Edited by ashwin08 21 hours 25 minutes ago

You can use a query based on v_GS_installed_Software and v_GS_Computer_System SQL views, something like:

select
*
from
v_GS_installed_Software  vIS
join
v_GS_Computer_System vSC
on
vIS.ResourceID=vSC.ResourceID
where
vIS.ProductName0 like '%SQL Server%'

Ofcourse the Hardware inventory has to be enabled and collected first.

• Edited by dekac99 20 hours 51 minutes ago

I would just create a collection for my SQL servers and used the hardware report out-of-the-box.  You will want to look for %SQL%Database%engine% as to not allow every branded piece of SQL software add to your collection.