"is not null" in Where clause

aniqfakhrul / powerview.py

Just another Powerview alternative

MIT License

453 stars 50 forks source link

"is not null" in Where clause #86

Closed cmprmsd closed 4 months ago

cmprmsd commented 5 months ago

Hey there!

Is there a way to filter for non-null fields in the where clause?

Think of

Get-DomainUser -Select name,description -TableView -Where "description is not null"

description != null does not give an error, but I think it matches the string null

aniqfakhrul commented 5 months ago

The format should be something like "description not null" iirc. But the -Where function is quite buggy atm. You can try -LDAPFilter '(description=*)' as alternative.