SCCM Sql Query to list "currently live" computers
Posted on 2011-05-11
Is there a way of listing all the "live" computers in SCCM Sql. When I do the below I get duplicate serial numbers where computers were reimaged.
select a.MachineID, b.SerialNumber00 As BIOSSN, e.SerialNumber00 As EncSN, a.*
from Computer_System_DATA as a
left join System_Enclosure_Data As e On a.machineID = e.MachineID
left join PC_BIOS_Data As b On a.MachineID = b.MachineID
Any idea what where clause I could add to get this listing only computers which are currently alive ?