Report "All servers" not showing all servers

[Fossy777]

Hi there,

I already checked the Report:

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetUnique,
  tblAssets.Domain,
  tsysOS.OSname,
  tblAssets.Description,
  tblComputersystem.Lastchanged,
  tsysOS.Image As icon
From tblComputersystem
  Inner Join tblAssets On tblComputersystem.AssetID = tblAssets.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblComputersystem.Domainrole > 1
Order By tblAssets.AssetName

I accidently deleted a row I was wondering if it could cause it (don´t remember what it was) but it did not help - anyway it still shows the same Count of Servers but I have more, on quick look sais me one 2008 R2 is missing the list and multiple 2003 R2, all of them running on XenServer.

What could that be?

Greetings, Jochen

[Hemoco]

Problem resolved through email. The tblDomainRoles database table, which stores domain role data, was cleared for some reason. Restoring it resolved the issue.

[Fossy777]

I sent you the mail...

[Fossy777]

The errorlog I sent you a few days ago for another Problem. But this one there already existted, so you can search it for anything suspective regarding this error (but I guess there is nothing in as far as i remember the Content).

The query gives me an error: Column Names in each view or function must be unique. Column Name "CFGname" in view or function "..." is specified more than once.

I think it makes no sense to provide you with the screenshot as Long as the query does not work.

[Hemoco]

Fossy777 wrote:
The errorlog I sent you a few days ago for another Problem.

Please resend the information as part of a separate ticket, as this makes it easier for us to track your support requests.

Fossy777 wrote:
The query gives me an error: Column Names in each view or function must be unique. Column Name "CFGname" in view or function "..." is specified more than once.

The error explains the problem. There are two columns of the same name. We created the query in SQL Compact, which automatically assigns unique column names, but most likely you are running the report in SQL Server. The report below is SQL Server compatible.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tblAssets.IPNumeric,
tblAssets.Scanserver,
tblAssets.OScode,
tblAssets.SP,
tblAssets.Assettype,
tblAssets.Mac,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAssets.Lasttriggered,
tblAssets.LastScheduled,
tblAssets.LastActiveScan,
tblAssets.LastIPScan,
tblAssets.LastLsPush,
tblAssets.LastSaved,
tblAssets.ServiceVersion,
tblAssets.LsPushVersion,
tblerrors.CFGname As CFGname1,
tblerrors.ErrorText,
tblerrors.Lastchanged,
tblerrors.ErrorType,
subquery.Domainrole,
TsysLastscan.CFGcode,
TsysWaittime.CFGname,
TsysLastscan.Lasttime,
TsysLastscan.Scantime,
TsysWaittime.Waitdays,
TsysWaittime.Trackchanges
From tblAssets
Left Join tblerrors On tblAssets.AssetID = tblerrors.AssetID
Left Join (Select tblComputersystem.AssetID,
tblComputersystem.Domainrole
From tblComputersystem) subquery On subquery.AssetID = tblAssets.AssetID
Left Join TsysLastscan On tblAssets.AssetID = TsysLastscan.AssetID
Inner Join TsysWaittime On TsysWaittime.CFGCode = TsysLastscan.CFGcode
Where tblAssets.AssetName = 'YourComputer'
Order By TsysWaittime.CFGname

[Hemoco]

If a server is not included in the report, it has no domain role value. Please contact support@lansweeper.com and provide us with the following so we can figure out why:
- Screenshot of the Lansweeper webpage of one problem machine.
- The Errorlog.txt file located in Program Files (x86)\Lansweeper\Service on your Lansweeper server.
- Output of the report below. Replace YourComputer with the name of the problem machine.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tblAssets.IPNumeric,
tblAssets.Scanserver,
tblAssets.OScode,
tblAssets.SP,
tblAssets.Assettype,
tblAssets.Mac,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAssets.Lasttriggered,
tblAssets.LastScheduled,
tblAssets.LastActiveScan,
tblAssets.LastIPScan,
tblAssets.LastLsPush,
tblAssets.LastSaved,
tblAssets.ServiceVersion,
tblAssets.LsPushVersion,
tblErrors.CFGname,
tblErrors.ErrorText,
tblErrors.Lastchanged,
tblErrors.ErrorType,
subquery.Domainrole,
TsysLastscan.CFGcode,
TsysWaittime.CFGname,
TsysLastscan.Lasttime,
TsysLastscan.Scantime,
TsysWaittime.Waitdays,
TsysWaittime.Trackchanges
From tblAssets
Left Join tblErrors On tblAssets.AssetID = tblErrors.AssetID
Left Join (Select tblComputersystem.AssetID,
tblComputersystem.Domainrole
From tblComputersystem) subquery On subquery.AssetID = tblAssets.AssetID
Left Join TsysLastscan On tblAssets.AssetID = TsysLastscan.AssetID
Inner Join TsysWaittime On TsysWaittime.CFGCode = TsysLastscan.CFGcode
Where tblAssets.AssetName = 'YourComputer'
Order By tblErrors.CFGname

[Fossy777]

in this Report These Servers also are not listed regardless I recently rescanned one of the missing ones...

[Hemoco]

You can run the report below to see what their domain role is.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tsysOS.OSname,
tblAssets.Description,
tblComputersystem.Lastchanged,
tsysOS.Image As icon,
tblComputersystem.Domainrole
From tblComputersystem
Inner Join tblAssets On tblComputersystem.AssetID = tblAssets.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Order By tblAssets.AssetName

[Fossy777]

Yes they were successfully scanned ("Scanned by ba-management01 at 2013-03-25 09:37:01"). If I search them in LanSweeper I get all Information about them.

can I see this "Tag" Domain Role anywhere in the Website or properties of the Server?

[Hemoco]

Have the missing machines been successfully scanned? The report identifies servers based on the Domain Role value in the Win32_ComputerSystem WMI class.