Deployment and Imaging Group

 View Only
  • 1.  Raw SQL or Query Builder for Filters

    Posted Nov 30, 2017 10:50 PM

    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_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.

  • 2.  RE: Raw SQL or Query Builder for Filters
    Best Answer

    Posted Dec 01, 2017 04:48 PM

    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.

  • 3.  RE: Raw SQL or Query Builder for Filters

    Posted Dec 07, 2017 02:40 PM

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