Report for Users Missing Employee Photo

[David_Elliott]

My techs use the Users: All user pictures canned report on a daily basis to find out what a person looks like before they visit them.

My list has about 2400 users. I've got pictures for about 2000 of them so far.

Can I create a custom report that lists the employees missing a picture/using the "no image" image?

[Susan_A · Accepted solution]

Just an FYI for everyone: recent Lansweeper releases now scan user pictures from Active Directory. You can build a report based on tblADusers.Picture.

[blighter]

You could do this pretty easily in PowerShell

import-module activedirectory

Get-ADUser -Properties * | Select-Object -Property Name,SamAccountName,thumbnailphoto | Sort-Object -Property Name | ConvertTo-CSV

This will feedback data in CSV format like:

"Name","SamAccountName","thumbnailphoto"
"Bloggs, J","JBloggs","System.Byte[]" <-- has photo
"Smith, J","JSmith" <-- no photo

[Hemoco]

blighter wrote:
You could do this pretty easily in PowerShell

import-module activedirectory

Get-ADUser -Properties * | Select-Object -Property Name,SamAccountName,thumbnailphoto | Sort-Object -Property Name | ConvertTo-CSV

This will feedback data in CSV format like:

"Name","SamAccountName","thumbnailphoto"
"Bloggs, J","JBloggs","System.Byte[]" <-- has photo
"Smith, J","JSmith" <-- no photo

These aren't the user images used by Lansweeper though. At the moment, user pictures must be manually placed in the Program Files (x86)/Lansweeper/Website/userpictures folder.

[Hemoco]

Such a report is not possible unfortunately. The database doesn't store information on user pictures. The report "Users: All user pictures" looks at a user's name and domain to construct an expected image source.