→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
crk112
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.

Thanks.
3 REPLIES 3
Bruce_B
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,
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
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.
Esben_D
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.