Wednesday, September 8, 2010

Query to find all the laptops in an SMS environment

select v_r_system.Name0
from v_R_System
inner join v_GS_SYSTEM_ENCLOSURE on v_GS_SYSTEM_ENCLOSURE.ResourceId = v_R_System.ResourceId
where v_GS_SYSTEM_ENCLOSURE.ChassisTypes0 in ('8','9','10','11','12','14','18','21')


The query lists laptops based on the chassis info from one of the SQL view in SMS DB.


Post a Comment

Subscribe to Post Comments [Atom]

Links to this post:

Create a Link

<< Home