List all local accounts

[greyclear]

POssible to generate a report of all local accounts? Psexec against the machines running net user works but slow and not very pretty

[greyclear]

Thanks. I apologize for not replying back sooner I got tied up with other things. This worked just fine

[Susan_A · Accepted solution]

User accounts are scanned by default. Please use the report below for the information you are after. Instructions for running reports can be found here. If you are interested in building or modifying reports, we would recommend:

• Reviewing some SQL tutorials, as the Lansweeper report builder uses standard SQL queries. This seems like a good tutorial.
  
• Updating to Lansweeper 5.2, if you haven't already. Lansweeper 5.2 includes a database dictionary, which is linked at the top of the report builder.

Select Top 1000000 tsysOS.Image As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.IPAddress,
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblUsers.Name,
  tblUsers.Fullname,
  tblUsers.Accounttype,
  tblUsers.Disabled,
  tblUsers.Lockout,
  tblUsers.PasswordChangeable,
  tblUsers.PasswordExpires,
  tblUsers.PasswordRequired,
  tblUsers.SID,
  tblUsers.Status,
  tblUsers.BuildInAdmin,
  tblUsers.Lastchanged
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Inner Join tblUsers On tblAssets.AssetID = tblUsers.AssetID
Where tblAssetCustom.State = 1
Order By tblAssets.Domain,
  tblAssets.AssetName,
  tblUsers.Name