→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
‎04-02-2013 06:06 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tblVmwareGuest.Name,
tblVmwareGuest.Memory,
tblVmwareGuest.IsRunning As [Guest Status],
Case tblVmwareGuest.ToolsRunningStatus When '3' Then 'Running'
When '2' Then 'Not Running' End As [Tools Running Status],
Case tblVmwareGuest.ToolsStatus When '1' Then 'Not Installed'
When '3' Then 'Current' When '4' Then 'Out Of Date' End As [Tools Status]
From tblAssets
Inner Join tblVmwareGuest On tblAssets.AssetID = tblVmwareGuest.AssetID
Order By tblAssets.AssetName
Solved! Go to Solution.
‎04-03-2013 06:20 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tblVmwareGuest.Name,
tblVmwareGuest.Memory,
tblVmwareGuest.IsRunning As [Guest Status],
Case tblVmwareGuest.ToolsRunningStatus When '3' Then 'Running'
When '2' Then 'Not Running' End As [Tools Running Status],
Case tblVmwareGuest.ToolsStatus When '1' Then 'Not Installed'
When '3' Then 'Current' When '4' Then 'Out Of Date' End As [Tools Status],
tsysOS.OSname,
tblOperatingsystem.Caption As FullOSname,
tblAssets1.SP
From tblAssets
Inner Join tblVmwareGuest On tblAssets.AssetID = tblVmwareGuest.AssetID
Inner Join tblVmwareGuestNetwork On tblVmwareGuest.GuestID =
tblVmwareGuestNetwork.GuestID
Inner Join tblAssetMacAddress On tblAssetMacAddress.Mac =
tblVmwareGuestNetwork.MacAddress
Inner Join tblAssets tblAssets1 On tblAssets1.AssetID =
tblAssetMacAddress.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets1.OScode
Inner Join tblOperatingsystem On tblOperatingsystem.AssetID =
tblAssets1.AssetID
Order By tblAssets.AssetName
‎04-08-2013 02:09 PM
‎04-03-2013 06:20 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tblVmwareGuest.Name,
tblVmwareGuest.Memory,
tblVmwareGuest.IsRunning As [Guest Status],
Case tblVmwareGuest.ToolsRunningStatus When '3' Then 'Running'
When '2' Then 'Not Running' End As [Tools Running Status],
Case tblVmwareGuest.ToolsStatus When '1' Then 'Not Installed'
When '3' Then 'Current' When '4' Then 'Out Of Date' End As [Tools Status],
tsysOS.OSname,
tblOperatingsystem.Caption As FullOSname,
tblAssets1.SP
From tblAssets
Inner Join tblVmwareGuest On tblAssets.AssetID = tblVmwareGuest.AssetID
Inner Join tblVmwareGuestNetwork On tblVmwareGuest.GuestID =
tblVmwareGuestNetwork.GuestID
Inner Join tblAssetMacAddress On tblAssetMacAddress.Mac =
tblVmwareGuestNetwork.MacAddress
Inner Join tblAssets tblAssets1 On tblAssets1.AssetID =
tblAssetMacAddress.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets1.OScode
Inner Join tblOperatingsystem On tblOperatingsystem.AssetID =
tblAssets1.AssetID
Order By tblAssets.AssetName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now