→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

Showing results for 
Show  only  | Search instead for 
Did you mean: 
Engaged Sweeper
The AssetIDs in tblVMwareguest do not match the AssetIDs in tblAssets (the Lansweeper Database Dictionary would lead me to believe it should be). Is this a problem specific to my installation? Is there a fix?

Because of this I'm not able to build reports using the information in tblVMwareGuest because I cannot link it to any of my assets.

Lansweeper Alumni
The table tblVMwareguests stores guest information as found when scanning the host. As such the asset this links to is correctly the VMware hosts. If the guests in question have been scanned separately as well, they can be linked to the host in a report using tblVMWareguestnetwork:

tblassets -> tblvmwareguest -> tblvmwareguestnetwork -> tblassetmacaddress -> tblassets(1)

I've added an example of a report below that uses this logic.

Select Distinct Top 1000000 tblAssets.AssetID,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress As [Host IP],
tblAssets1.AssetID As [Guest Asset ID],
tblVmwareGuest.Name As [Guest Name],
tblAssets1.AssetName As [Guest AssetName],
tblAssets1.IPAddress As [Guest IP],
Case When (tblAssets1.AssetName Is Null) Then 'Not Scanned' Else 'Scanned'
End As [Scan Status]
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblVmwareGuest On tblAssets.AssetID = tblVmwareGuest.AssetID
Inner Join tblVmwareGuestNetwork On tblVmwareGuest.GuestID =
Left Join tblAssetMacAddress On tblAssetMacAddress.Mac =
Left Join tblAssets tblAssets1 On tblAssets1.AssetID =
Order By tblAssets.AssetName
Engaged Sweeper
Upon further review I see that the AssetIDs in tblVMwareguest are matching the AssetIDs of my VMware HOSTS in tblAssets... not the GUESTS.

Was this the intended design? Assuming correct terminology has been used in the dictionary I think the AssetID of each VMware "GUEST" should match the AssetID of the "GUEST" in tblAssets... not of the VMware "HOST" on which the "GUEST" resides.
Lansweeper Employee
Lansweeper Employee
tblVmwareGuest should be linked to tblAssets on AssetID. The ID's therefore should match.

Maybe the host got deleted from the database?

If you share the report I'll take a look at it. However, I suspect that it will be fine.