08-27-2018 04:56 PM - last edited on 04-02-2024 12:39 PM by Mercedes_O
Is there a technique for searching for blank fields in the List View? By that I mean when you list assets and there are search fields at the top of each column, is there any thing you can enter in the search field to find emtpy data fields?
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