Citrix: Client XenStore Data (Built-in)

[Esben_D]

The report below gives back a list of Citrix guests with a XenStore data.

The report will only list assets when the following criteria are met:

• You have Lansweeper 7.0 or higher.
  
• There is Citrix guest XenStore data scanned.
  
• The assets must be active.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysIPLocations.IPLocation,
  tblCitrixHost.Name As Host,
  tblCitrixPool.Name As Pool,
  tblCitrixGuestExtraInfoTypes.Name,
  tblCitrixGuestExtraInfo.[Key],
  tblCitrixGuestExtraInfo.Value,
  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
  Inner Join tblCitrixGuestExtraInfo On tblCitrixGuestExtraInfo.GuestId =
    tblCitrixGuest.GuestId
  Inner Join tblCitrixGuestExtraInfoTypes On
    tblCitrixGuestExtraInfoTypes.InfoTypeId = tblCitrixGuestExtraInfo.InfoTypeId
Where tblCitrixGuestExtraInfoTypes.Name = 'XenStore data' And
  tblState.Statename = 'Active'
Order By Pool,
  Host,
  tblAssets.AssetName