Guys, we are trying to create some advanced queries in both the Win32/Rest console for systems with virtual tributes that are not set or empty. IN LDAP syntax, this might look as follows
&(objectCategory=computer)(!(VA-RolePrimary=*))
However, this returns fine in a tool like LDP but never via the DRA consoles. I exported a few queries from the Win32_Consoles and it seems that for VAs, the system sues some parsing of the query or the like and the raw LDAP send to AD LDS is stored elsewhere,
So, how to query for attributes with no value set via the console?
by: Darragh O. | over a year ago | Reporting
Comments
If any VA has no initial value set there will be no record of it in ADAM. Once you add a value a new record is created in ADAM. If you remove the value the record remains but the value is <not set>. So if you use Advance query it return objects as long as you initially set the VA and if you remove the value you will find the VA <not set> since the record is there in ADAM. In Advance query you fill in the "Where" section and for Virtual Attributes you need to use "Build VA Query" option.
I simply use powershell to do this. If you are interested I can send you the powershell script. The script allows you to specify a VA and it will connect to ADAM and generate a text file.
ugo.corti@microfocus.com
I can powershell and other solution's but this is a request from my helpdesk staff. I think it really makes sense for the product to have this functionality.
Closing this request as Ugo provided a way to generate the information requested.