"Installed Software Usage by Manufacturer"  report has bad manufacturer data

Version 1

    Details

    The OOTB "Installed Software Usage by Manufacturer" report has bad manufacturer names in the parameter drop down pick list. How does this list get populated? How do we clean it up. Example of bad data is "Costco Wholesale". 


    Resolution

    The Manufacturer list drop down is generated by querying the Manufacturer field from the Manufacturer table.  If you wish to remove items from this list you can do it through SQL with a statement similar to below:


    DELETE FROM Manufacturer
    WHERE Manufacturer = 'Costco Wholesale'

    Same list can be modified from inside the Admin UI (Configure Application) and altering the values of the Manufacturer of Manufacturer used in HardwareProfile PickList.