→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
bandersen
Engaged Sweeper II
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.
1 ACCEPTED SOLUTION
Susan_A
Lansweeper Alumni
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

View solution in original post

1 REPLY 1
Susan_A
Lansweeper Alumni
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