AD users without picture

[bandersen]

We're using the AD attribute thumbnailPhoto. Was wondering if you can run a report of users that don't have this attribute filled in.

[Susan_A · Accepted solution]

The thumbnailPhoto attribute in AD corresponds with the Picture field in the tblADusers table of the Lansweeper database. You can use the sample report below to list users without a photo. Instructions for adding reports to your Lansweeper installation can be found here.

Select Top 1000000 *
From tblADusers
Where tblADusers.Picture Is Null