Raw SQL or Query Builder for Filters

[Gh0st]

I'm trying to create a filter that identifies all of our Laptops. We use Lenovo's so any item in 

Inv_AeX_HW_Baseboard Part Number

will reflect what we are trying to find.

I can run directly from the SQL server the following code to pull what I need

SELECT [dbo].[Inv_AeX_AC_Identification].[_ResourceGuid]
	,[dbo].[Inv_AeX_AC_Identification].[Name]
	,[dbo].[Inv_HW_Baseboard].[Part Number]
  FROM [Symantec_CMDB].[dbo].[Inv_AeX_AC_Identification] 
  INNER JOIN [Symantec_CMDB].[dbo].[Inv_HW_Baseboard]
  ON [Part Number] = [Part Number]
  WHERE [Part Number] Like '20%';

but in Raw SQL editor of the filter it returns colums for just the Inv_AeX_AC_Idtification table but they seems from spot checking they are what I am looking for. 

I am going to use this to validate our HD encryption or software only installs and I can't afford for a desktop to recieve this. So seeing the Part number Column is important as a visual inspection.

[m.taylor]

To view columns of your choice you need to create a report instead of a filter. A filter only accepts the GUID column in the Select portion of the query and then displays other predetermined columns that someone at Symantec decided on.

[Gh0st]

Yep found that out, the report confirms that the query was right and the filter just returns the matches with all the data.