Find All Workstations and Servers Which Are Part of a Windows Workgroup
Get a complete list of all computers that are part of a Windows workgroup. If you have an active directory domain, this also allows you to verify whether any computers are missing from that domain and should be included. To get a list of all workstations and servers already in an active directory domain, you can use the computer part of a domain report.
Computer Part of Workgroup Query
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tsysOS.OSname,
tblAssets.Description,
tblComputersystem.Lastchanged,
tsysOS.Image As icon,
tblAssetCustom.State
From tblAssets
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssetCustom.State = 1 And tblComputersystem.PartOfDomain = 0
Order By tblAssets.AssetName
