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