Computer model overview - change brand

[woookash]

Hi,

I have a request (not a problem):

At some point, it looks like Dell changed his brand description on certain desktops (Optiplex 740):

Some of them are registered with "Dell Inc" while most of them are "Dell Inc."

That very single dot gives inconsistent results in our reporting: we have 63 "Dell Inc." optiplex 740s and 135 "Dell Inc" optiplex 740s..

It would be great to be able to tell lansweeper both brands are just one, permanently.

ps: lansweeper is a great product, I was happy when I realized it made in belgium \o/

[woookash]

Hi,

Thanks 🙂

At the end, I've ended up updating bios on the concerned computers: seems that Dell only made that mistake in a few version of the Optiplex 740 bios.

[Hemoco]

The computer model overview is automatically generated based on scanned WMI info and cannot currently be manually manipulated. In Lansweeper version 5.0 the vendor and model fields will likely be turned into custom fields, allowing you to override these scanned records. Lansweeper 5.0 is currently in development, but we do not yet have a release date for it.

What you can do for now is create your own custom report with the information you are after. The report below for instance lists all "OptiPlex 740" machines by Dell.

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputersystem.Model, tblComputersystem.Manufacturer
From tblComputers Inner Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername
Where tblComputersystem.Model = 'OptiPlex 740' And
tblComputersystem.Manufacturer Like '%dell%'
Order By tblComputers.ComputerUnique

To use the specified report, do the following:
• Open the Lansweeper configuration console and select Reports & Alerts\Report Builder. Hit the “New” button.
• Copy the SQL code provided and paste it at the bottom of the newly created report, replacing the default SQL code.
• Click somewhere near tblComputers so the new code applies.
• Give the report a “View name” and a “Report name” and hit the “Save” button.
• Double-click on the report in the report list to see its results and export options.