Computer Part of Workgroup

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

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

Run This Report in 3 Easy Steps

Download-Install-Lansweeper

1. Download & Install Lansweeper

Save-and-Run-the-Report

3. Run the Report

Download Lansweeper to Run this Report

Harness the Power of Reporting