List of Active Guest users

[EStarshinov]

Help please -
I need List all Guest users on all assets who have Disabled = 'False'.

[ne1986]

It's a rather old post, but this did the trick for me:

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblUsers.Name,
  tblUsers.Disabled
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblUsers On tblAssets.AssetID = tblUsers.AssetID
Where tblUsers.Name = 'Guest' And tblUsers.Disabled = 'False' And
  tblAssetCustom.State = 1