‎09-07-2023 02:35 PM
I fully agree.
Absolutely annoying not to have that option.
3 weeks ago - last edited 3 weeks ago
You can use operator 'having' in query to detect empty values and show this counter for filtering:
Select Top 1000000 tblADObjects1.domain,
tblADObjects1.sAMAccountName,
tblADGroups.Name,
tblADGroups.Description,
tblADGroups.LastChanged
From tblADGroups
Left Join tblADMembership On tblADGroups.adobjectid =
tblADMembership.parentadobjectid
Left Join tblADObjects On
tblADObjects.ADObjectID = tblADMembership.ChildAdObjectID
Inner Join tblADObjects tblADObjects1 On tblADObjects1.ADObjectID =
tblADGroups.ADObjectID
Group By tblADGroups.Name,
tblADGroups.Description,
tblADGroups.LastChanged,
tblADObjects1.domain,
tblADObjects1.sAMAccountName
Having Count(tblADObjects.ADObjectID) = 0
‎11-02-2023 02:51 PM - edited ‎11-02-2023 02:51 PM
how about we enhance the column searches with logic .. IF THIS THAN NOT OR AND etc.. so if column A = WHATEVER AND COLUMN C NOTEQUAL WHATEVER..
sometimes it would be easier to just do that then creating whole new SQL Report.
‎09-07-2023 04:07 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now