Our Databerg Report highlighted that globally 52% of stored data is dark, whose value is unknown. With the plethora of unstructured data within your organization, do you know where Personally Identifiable Information (PII) is stored? Do you know if ...
Data Insight Query Language (DQL) was introduced in version 4.0 of Data Insight and has a powerful SQL like interface that allows you to execute custom queries/reports against the data being monitored. DQL is documented in detail under the Data Insig...
Hello Paul,
'format user AS csv' served no purpose in the original query as intent was to query the user table only. "Format as CSV" is applicable for multi-valued columns like custom attributes in this case.
By default a multi-valued column in out...
Hello Phil,
Unfortunately, there is no command-line available today. While this may be acheivable using hacks in configuration but I'll not recommend it. Can you provide more information on the use-case and accordingly raise an enhancement request f...
Custom attributes are multi-valued columns. Please consider such columns as CSV if you want to create one output / file. Example below:
From user
get name, principal_name, login, Home_directory, Department
If Home_Directory not in ('nowhere')
for...
Hi Phil,
This would require multiple DQL queries and SQL post-processing. In case you are using 5.0, post-processing can be utilized from UI. Otherwise, you would need to write the SQL query outside DI.
Regarding wild characters, DQL doesn't suppor...
Hi Phil,
Please find the query below that may help:
select m.login,m.domain,ro.name from matrixuser m, rba r, role ro where m.matrixuser_id= r.principal_id and r.role_id=ro.role_id and r.object_type=1
Regards,
Rishi
