cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Esben_D
Lansweeper Employee
Lansweeper Employee
The report below gives back a list of Citrix guest summary.

The report will only list assets when the following criteria are met:
  • You have Lansweeper 7.0 or higher.
  • There is Citrix guest data scanned.
  • The assets must be active.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysIPLocations.IPLocation,
tblCitrixHost.Name As Host,
tblCitrixPool.Name As Pool,
tblCitrixGuest.CpuCount,
tblCitrixGuest.LastUpdated,
tblCitrixGuest.Live,
(tblCitrixGuest.Memory) / 1024 / 1024 As MemoryMB,
tblCitrixGuest.State,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblCitrixGuest
Inner Join tblAssets On tblAssets.AssetID = tblCitrixGuest.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Inner Join tblCitrixHost On tblCitrixGuest.HostId = tblCitrixHost.HostId
Inner Join tblCitrixPool On tblCitrixPool.PoolId = tblCitrixHost.PoolId
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblState.Statename = 'Active'
Order By Pool,
Host,
tblAssets.AssetName
0 REPLIES 0

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now