→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
bd
Engaged Sweeper III
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
5 REPLIES 5
Hemoco
Lansweeper Alumni
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
Lansweeper Alumni
Could you send a screenshot of this error to support@lansweeper.com, so we can try to reproduce this behavior.
bd
Engaged Sweeper III
When I use that code you gave me the webserver gives me an error, see attached screenshot.
Hemoco
Lansweeper Alumni
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
Engaged Sweeper III
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.