CrowdStrike Update Causes BSOD Issues Globally – Audit Available 🛡️ Learn more

TRY NOW

Computer Part of Workgroup

Hardware Operating System

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

Show

Hide

NO CREDIT CARD REQUIRED

Ready to get started?
You’ll be up and running in no time.

Explore all our features, free for 14 days.