report - pc with no location

[shockley]

We are new to lansweeper, we have uploaded several maps and Assigned assets to them. but the canned report to show computers with no location still shows them with no location. am i missing something?

[shockley]

thanks I'll give it a shot

[Bruce_B]

In Lansweeper version 6.0.0.65 there is no built-in report dealing with Location maps. The only report dealing with locations lists computers that don't have their AD location filled in: "Active directory: Computer has no location filled in". I've added a report below that will list all assets and their location maps.

Do note that there are multiple "location" values within Lansweeper:

• IP Location, based on the IP Ranges set up under Configuration\Asset Groups
  
• tblAssetcustom.location, this is scanned via SNMP or manually filled in
  
• tblADComputers.location, this is scanned out of AD for domain Windows computers.
  
• Location maps, which are manually created and maintained.

Select Top 1000000 tblAssets.AssetName As Asset,
  tblAssets.Domain,
  tsysAssetTypes.AssetTypename As AssetType,
  tblAssets.Username,
  tblAssets.Userdomain,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tsysIPLocations.IPLocation,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  Coalesce(tsysOS.OSname, tblLinuxSystem.OSRelease, tblMacOSInfo.SystemVersion)
  As OS,
  tblAssets.SP,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tsysAssetRelationTypes.Name As Relation,
  tblAssets1.AssetID,
  tblAssets1.AssetName
From tblAssets
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblAssetRelations On tblAssetRelations.ChildAssetID =
    tblAssets.AssetID
  Inner Join tsysAssetRelationTypes On tsysAssetRelationTypes.RelationTypeID =
    tblAssetRelations.Type
  Inner Join tblAssets tblAssets1 On tblAssets1.AssetID =
    tblAssetRelations.ParentAssetID
  Inner Join tblAssetCustom On tblAssetCustom.AssetID = tblAssets.AssetID
  Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Inner Join tsysIPLocations On tsysIPLocations.LocationID =
    tblAssets.LocationID
  Inner Join tblState On tblState.State = tblAssetCustom.State
  Left Join tblLinuxSystem On tblAssets.AssetID = tblLinuxSystem.AssetID
  Left Join tblMacOSInfo On tblAssets.AssetID = tblMacOSInfo.AssetID
Where tsysAssetRelationTypes.Name = 'is located in' And tblState.Statename =
  'Active'
Order By tblAssets.IPNumeric,
  tblAssets.Domain,
  Asset