14 Replies Latest reply on Jul 23, 2014 11:26 AM by JonnyB

    Returned List is Blank

    Rookie

      I have a LANDesk report that lists software installed to a computer, but does not return certain programs (base image items, driver packages, etc.). I added an additional "NOT LIKE" to the query the other day and now the report comes back as blank, but lists rows as if it is working. Running the report against different computers returns a different amount of rows, so it appears to be filtering correctly, but the list items are blank. The computer name entered is also supposed to be at the top as a banner but it is not displaying either. Here is a screenshot of the results followed by the query.

      Capture0019.jpg

       

      SELECT DISTINCT
          A0.DEVICENAME AS DeviceName,
          A2.TITLE AS SuiteName,
          A2.VERSION AS appVersion,
          A2.PUBLISHER AS Publisher
      FROM
          Computer A0
          INNER JOIN productcomputer A1 ON A0.Computer_Idn = A1.Computer_Idn
          inner join product a2 on a1.product_idn = a2.product_idn
          LEFT OUTER JOIN SCOPECOMPUTER ON A0.COMPUTER_IDN = SCOPECOMPUTER.COMPUTER_IDN 
      WHERE A0.DEVICENAME IS NOT NULL
          AND A0.DEVICENAME LIKE ?
        AND A2.TITLE NOT LIKE 'Microsoft Office%'
        AND A2.TITLE NOT LIKE 'Microsoft Expression%'
        AND A2.TITLE NOT LIKE '%ForeFront%'
        AND A2.TITLE NOT LIKE 'Microsoft Operations%'
        AND A2.TITLE NOT LIKE '%Silverlight%'
        AND A2.TITLE NOT LIKE 'Microsoft%Visual%Redistributable%'
        AND A2.TITLE NOT LIKE 'LANDesk%'
        AND A2.TITLE NOT LIKE '%Network ScanGear%'
        AND A2.TITLE NOT LIKE '%Java%'
        AND A2.TITLE NOT LIKE 'WIDS%'
        AND A2.TITLE NOT LIKE '%SnapPlayer%'
        AND A2.TITLE NOT LIKE 'Windows Mobile%'
        AND A2.TITLE NOT LIKE 'Microsoft .NET%'
        AND A2.TITLE NOT LIKE 'Microsoft Project%'
        AND A2.TITLE NOT LIKE 'Sassafras%'
        AND A2.TITLE NOT LIKE 'Adobe AIR%'
        AND A2.TITLE NOT LIKE 'Adobe Flash%'
        AND A2.TITLE NOT LIKE 'Microsoft Visio%'
        AND A2.TITLE NOT LIKE '%FireFox%'
        AND A2.TITLE NOT LIKE '%Chrome%'
        AND A2.TITLE NOT LIKE '%Google Update%'
        AND A2.TITLE NOT LIKE 'Adobe Reader%'
        AND A2.TITLE NOT LIKE 'Microsoft%Windows%'
        AND A2.TITLE NOT LIKE 'Internet Explorer'
        AND A2.TITLE NOT LIKE 'swMSM'
        AND A2.PUBLISHER NOT LIKE 'Apple%'
        AND A2.PUBLISHER NOT LIKE 'Hewlett-Packard'
        AND A2.PUBLISHER NOT LIKE '%Canon%'
        AND A2.PUBLISHER NOT LIKE '%NVIDIA%'
        AND A2.PUBLISHER NOT LIKE '%Intel%'
        AND A2.PUBLISHER NOT LIKE '%AMD%'
        AND A2.PUBLISHER NOT LIKE '%Broadcom%'
        AND A2.PUBLISHER NOT LIKE 'ATI'
        AND A2.PUBLISHER NOT LIKE 'ATI Technologies'
        AND A2.PUBLISHER NOT LIKE 'Advanced Micro Devices, Inc.'
        AND A2.PUBLISHER NOT LIKE 'Hewlett-Packard Company'
        AND A2.PUBLISHER NOT LIKE 'Hewlett-Packard Co.'
        AND A2.PUBLISHER NOT LIKE 'Hewlett-Packard'
      ORDER BY
          A0.DEVICENAME, A2.TITLE