cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
trt
Engaged Sweeper
Users: All users pictures report does not display pictures:

This image displays in the user info:
URL - http://servername/smallthumb.aspx?user=UserName&domain=DomainName&size=160

This image displays in the report:
URL - http://servername/images/smallthumb.aspx?user=UserName&domain=DomainName&size=160

Looks like /images needs to be removed from URL.
4 REPLIES 4
trt
Engaged Sweeper
I have updated script to the one you provided. It displays pictures fine now.
Hemoco
Lansweeper Alumni
This is the code from the installer

CREATE VIEW dbo.web40repuserpictures
AS
Select Top 1000000 '<img src="smallthumb.aspx?user=' + tblADusers.Username + '&domain=' + tblADusers.Userdomain + '&size=32"/>' As Picture, tblADusers.Displayname, tblADusers.Firstname, tblADusers.Lastname, tblADusers.Username, tblADusers.Userdomain, tblADusers.Department From tblADusers Order By tblADusers.Displayname
GO


Anyone else with the same problem?
trt
Engaged Sweeper
I have checked "Users: All users pictures" report by editing it in Report builder, it has "size=160" in it.

Here is a script from there:

Select Top 1000000 'smallthumb.aspx?user=UserName&domain=DomainName&size=160' As icon, tblADusers.Displayname, tblADusers.Firstname, tblADusers.Lastname, tblADusers.Username, tblADusers.Userdomain, tblADusers.Department From tblADusers Order By tblADusers.Displayname

"UserName" And "DomainName" have correct names in there.
Hemoco
Lansweeper Alumni
Can you verify the url, it should end on "&size=32"