Double entry

[dkrnetadmin]

Something weird......

We noticed in the web console 2 entries for 1 server. I launched the GUI and see the 2 entries but i can only select one.

Weird.....

[lhawk]

My duplicates were from Software reports, when I selected a specific application. The info that displayed had some dup's, but when I ran a report in the report explorer I didn't have the same issue. My problem I think is resolved. Cheers

[lhawk]

LanSweeper, was there ever a resolution to this duplicate computer entry thing? We have had LS running for a little over a month and I am starting to see some multiple entries in reports. Also these multiples seem to go away for no particular reason. I ran the same computer report 15min apart and get different results. It is getting furstrating to have to clean up the reports before I publish them. Thanks for the help.

[Hemoco]

lhawk wrote:
LanSweeper, was there ever a resolution to this duplicate computer entry thing? We have had LS running for a little over a month and I am starting to see some multiple entries in reports. Also these multiples seem to go away for no particular reason. I ran the same computer report 15min apart and get different results. It is getting furstrating to have to clean up the reports before I publish them. Thanks for the help.

Are these duplicates from reports you created or from standard reports?

[Hemoco]

No problem

[wim_dh]

Do you mind if I mail it to you? I don't like to post this extract on this forum.

[Hemoco]

Wim, could you post a table extract (in excel) of the double entries in tables tblOperatingsystem and tblComputersystem please.

[wim_dh]

I have the same problem. On a total of about 900 PC's, I saw that there were 12 double entries. I've noticed this, because the counter for the operating systems on the dashboard exceeded the total amount of computers. After some investigation, I've discovered that there were no double entries in tblComputers but there were in tblOperatingsystem. By querying this table with

SELECT Computername
FROM tblOperatingsystem
GROUP BY Computername
HAVING (COUNT(Computername) > 1)

I've got a result of 12. The double Computername entries in the table have different osid's. The same for tblComputersystem (4 double entries)
I'm working with the most recent SP of Lansweeper. What are my options to resolve this?

[dkrnetadmin]

It no longer appears twice. And the workstation that appeared 9 times only shows up 3 times. Is this normal behavior? It seems to be cleaning itself of duplicate entries.

[Hemoco]

dkrnetadmin wrote:
It no longer appears twice. And the workstation that appeared 9 times only shows up 3 times. Is this normal behavior? It seems to be cleaning itself of duplicate entries.

No, this is not normal behaviour, and so far you seem to be the only one with this problem.

Do your other clients with this problem also have the "System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_tblsyslastscan'." error?