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?