Btw, for some other vendors, such as HP, hardware_model is more user friendly.
One idea to overcome this, was to provide a table within the query resolving Lenovo's models to its brand names, however I'm not sure, how to do this. Is this possible with a WITH statement?