Domain User Report

[bd]

There is an old report that has never worked for me since upgrade to version 5. The report is all domain users with their pictures and OU, you can click on the username and it takes you to user details page. The pictures are small thumbnails, but now the pictures don't show, it only shows a red X. I will attach a screenshot. I'm pretty sure this is/was a canned report from prior versions, probably just needs to be updated.

Original source that doesn't work is:

Select Top (1000000) '<img src="smallthumb.aspx?user=' + tblADusers.Username +
'&domain=' + tblADusers.Userdomain + '&size=32"/>' As Picture,
tblADusers.Username,
tblADusers.Firstname,
tblADusers.Lastname,
tblADusers.Userdomain,
tblADusers.OU
From tblADusers

[Hemoco]

We tested this again and the only way we can reproduce this behavior is by putting quotes around the SQL statement, which is something you should not do.

[Hemoco]

Could you send a screenshot of this error to support@lansweeper.com, so we can try to reproduce this behavior.

[bd]

When I use that code you gave me the webserver gives me an error, see attached screenshot.

[Hemoco]

You should be using the SQL query below for this report.

Select Top 1000000 '<img src="thumbnail.aspx?user=' + tblADusers.Username +
'&domain=' + tblADusers.Userdomain + '&size=26" class="rimage"/>' As Picture,
tblADusers.Displayname,
tblADusers.Firstname,
tblADusers.Lastname,
tblADusers.Username,
tblADusers.Userdomain,
tblADusers.Department
From tblADusers
Order By tblADusers.Displayname

[bd]

Another note, if I make a copy of Thumbnail.aspx and name it smallthumb.aspx it works correctly, the problem is every time I update to a new version of Lansweeper it deletes the smallthumb.aspx. It I try to call Thumbnail.aspx directly from my report it doesn't work.