Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
paprita
Champion Sweeper
I found a very strange (for me) situation as follow (you can find just one PC but there are other 3 PC with the same situation):
- the db looks like good (db.jpg in attach);
- in the lsmanage.exe you can find 4 lines from the same record (if you go with the mouse you are able to click just on the first line of 4)(client.jpg in attach);
- in web general list you can find 4 lines from the same record and you are able to click on each of them (web_gen.jpg in attach);
- I use follow report:
Select dbo.tblComputers.Computername As Computer,
dbo.tblOperatingsystem.Description,
dbo.web30ProcessorCapacity.[total Proc Capacity], dbo.web30memory.Memory,
dbo.tblComputersystem.Manufacturer, dbo.tblComputersystem.Model,
dbo.tblComputers.Lastseen
From dbo.tblComputers Inner Join
dbo.web30ProcessorCapacity On (dbo.tblComputers.Computername =
dbo.web30ProcessorCapacity.Computername) Inner Join
dbo.web30memory On (dbo.tblComputers.Computername = dbo.web30memory.Computer)
Inner Join
dbo.tblComputersystem On (dbo.tblComputers.Computername =
dbo.tblComputersystem.Computername) Inner Join
dbo.tblOperatingsystem On (dbo.tblComputers.Computername =
dbo.tblOperatingsystem.Computername)
Where (dbo.web30ProcessorCapacity.[total Proc Capacity] < XXXX) Or
(dbo.web30memory.Memory < YYY)


where XXXX and YYY are determinated numbers.

- if you go on Report Builder (Beta) you can find 32 lines from the same record (report_builder.jpg in attach);
- if you go on report list on web you can find 32 lines from the same record (report_web.jpg in attach).

What do you think about this?
1 REPLY 1
Hemoco
Lansweeper Alumni
Could you check if they have duplicate values in tables : tblComputersystem or tblOperatingsystem

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