We’re currently experiencing a high volume of support requests, which may result in longer response times — Thank you for your patience and understanding.
Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
DevonFury
Engaged Sweeper
I just have another quick question:

Does anyone know if Lansweeper has a mechnaism to deal with duplicate or renamed computers? In other words, if Lansweeper polls a computer named ComputerA and later the name is changed to ComputerB, does Lansweeper see these as two different computers? Or is there a mechanism or something I can do to handle those situations?

Thanks
6 REPLIES 6
DevonFury
Engaged Sweeper
What results are you expecting to get? I copied and pasted the statement from you post into my SQLExpress box and it ran fine.
jcorso11
Engaged Sweeper
not erroring, just not giving the results correctly.

DevonFury
Engaged Sweeper
What error are you getting?
jcorso11
Engaged Sweeper
I need to do this as well. I just did this, but its not working....

Please help.

SELECT
tblNetwork.MACaddress,
tblNetwork.Computername,
tblNetwork.DHCPenabled
FROM
tblNetwork
DevonFury
Engaged Sweeper
Thanks
Hemoco
Lansweeper Alumni
The "unique key" is the computername.
You can find cases like this if you create a report for duplicate mac addresses

Archive

This board contains archived posts from the retired Lansweeper Forum and Insiders Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now