tblVMwareGuest assetid mismatch

[crk112]

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.

Thanks.

[Bruce_B]

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,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress As [Host IP],
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  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 =
    tblVmwareGuestNetwork.GuestID
  Left Join tblAssetMacAddress On tblAssetMacAddress.Mac =
    tblVmwareGuestNetwork.MacAddress
  Left Join tblAssets tblAssets1 On tblAssets1.AssetID =
    tblAssetMacAddress.AssetID
Order By tblAssets.AssetName

[crk112]

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.

[Esben_D]

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.