Hi All,

I'm trying to create a custom collection that only includes the computer name, the computer type (which I only want laptops), and is in a specific OU.  It seems simple enough, and my query works PERFECT in SQL Query Analyzer, but when I plug it into the Custom SQL in Altiris, it returns every record of everything, i.e. software, user names, computer names, everything!

Here is the query:

SELECT     
Inv_OU_Membership.[Distinguished Name],
Inv_AeX_HW_Serial_Number.[Computer Type],
Inv_AeX_AC_Identification.[Name], 
Inv_AeX_AC_Identification.[_ResourceGuid]

From Inv_AeX_AC_Identification  
     
left join Inv_AeX_HW_Serial_Number     
on Inv_AeX_AC_Identification.[_ResourceGuid]=Inv_AeX_HW_Serial_Number.[_ResourceGuid]   
left join Inv_OU_Membership   
on Inv_AeX_AC_Identification.[_ResourceGuid]=Inv_OU_Membership.[_ResourceGuid]     
where    
(Inv_AeX_HW_Serial_Number.[Computer Type] LIKE 'Portable' or    
Inv_AeX_HW_Serial_Number.[Computer Type] LIKE 'Notebook' or    
Inv_AeX_HW_Serial_Number.[Computer Type] LIKE 'Laptop')    
and (( Inv_OU_Membership.[Distinguished Name] = 'OU=TEMECULA,OU=WEST COAST,OU=NORTH AMERICA,OU=ENTERPRISE,DC=CORP,DC=MILLIPORE,DC=COM'))

Can someone help me figure out what I can be doing wrong ?  I really appreciate it!  

Thanks,

-Nick