Hello, we are in process of implementing HAMPro so am new to this; wondering if/how others handle Lenovo models as they have their model Number listed in win32_computersystem|model whereas every other manufacture has their model Name.
I asked for our SQL query to be amended to include logic; IF Lenovo > get model name from win32_computersustemproduct|version Else win32_computersystem|model
IIf(
v_GS_COMPUTER_SYSTEM.Manufacturer0 = 'lenovo',
v_GS_COMPUTER_SYSTEM_PRODUCT.Version0,
v_GS_COMPUTER_SYSTEM.Model0
) AS model,
Question then, is what do we do with the model Number? it appears other manufactures may/may not include model number in either of these tables?
Not sure how this affects normalization, so curious what other are doing?
