‎08-27-2018 04:56 PM
‎09-07-2023 02:35 PM
I fully agree.
Absolutely annoying not to have that option.
‎11-09-2023 09:11 AM - edited ‎11-09-2023 09:14 AM
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
‎02-04-2021 01:50 PM
‎11-27-2020 12:19 PM
‎08-27-2018 05:43 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now