help with ad reports that list computername$ as a user

[karon]

in the canned report for ad users that have no title (and quite a few other reports as well)

Select Top 1000000 tblADusers.Userdomain,
tblADusers.Displayname,
tblADusers.Title,
'usersm.png' As icon,
tblADusers.Lastchanged
From tblADusers
Where (tblADusers.Title Like '') Or
(tblADusers.Title Is Null)

the results have a whole slew of computernames followed by a $ (ie computer1$) as the username
I have tried every not like statement I can figure out on how to get rid of those entries, but no luck

[karon]

got it thanks

[Hemoco · Accepted solution]

Please refer to this forum thread for information on why this is happening.