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

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Cam
Engaged Sweeper II
When you click on a VMware ESXi host currently towards the bottom it shows a report like the picture that I have attached

I have written the following report to grab VMware Guest details which I want to show from all of my VMware ESXi's that are being scanned, however, how do I make the green up/down dot show and how do I make the VMware Guest name a link to the object if it exists in Lansweeper as shown in the picture?

Select Top 1000000 tblVmwareGuest.Name As Guest,
Ceiling(tblVmwareGuest.Memory / 1024) As [Memory (GB)],
tblVmwareGuest.CpuCount,
tblVmwareGuest.IsRunning As State,
tblVmwareGuest.lastchanged,
Case When tblVmwareGuest.IsRunning = 'poweredOff' Then 'red'
End As foregroundcolor,
tblAssets.AssetName As [ESXi Name]
From tblVmwareGuest
Inner Join tblAssets On tblAssets.AssetID = tblVmwareGuest.AssetID
Where tblVmwareGuest.Name Not Like 'hmcvm%'
Order By Guest


Thanks,
Cam
1 REPLY 1
RDBraswell
Engaged Sweeper II
I am trying to figure out something similar.... I cant believe there hasn't been a response.