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