
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-11-2013 09:15 PM
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
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
Solved! Go to Solution.
Labels:
- Labels:
-
General Discussion
1 ACCEPTED SOLUTION

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-11-2013 09:28 PM
Please refer to this forum thread for information on why this is happening.
2 REPLIES 2

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-11-2013 09:38 PM
got it thanks

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-11-2013 09:28 PM
Please refer to this forum thread for information on why this is happening.
