Bus: C bus available (Built-in)

[Daniel_B]

List of computers having a C-bus interface


Meets all the following criteria:
- Active asset
- Windows asset
- C-bus interface available

Sorted on:
- Asset name

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetUnique,
  tblAssets.Domain,
  tsysOS.OSname,
  tsysOS.Image As icon,
  tblBus.DeviceID,
  tblBus.Lastchanged
From tblAssets
  Inner Join tblBus On tblAssets.AssetID = tblBus.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblBus.BusType = 9 And tblAssetCustom.State = 1
Order By tblAssets.AssetName