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