You can translate the question and the replies:

creating a base view off of a working script in VQL Shell

I have the following code that is working to produce a result but I am not 100% sure how to turn it into a baseview that I can join against another existing view. ``` select * from (select * from hcc_dv_dev.bv_ctigeneral_s3_ldap_matrix_regionsector)a RIGHT JOIN (SELECT GETSESSION('user') as user_name FROM dual()) b ON (a.samaccountname = b.user_name) ``` Is there any easy way to accomplish this? can someone show me a real example of the VQL script versus pointing me to the general documentation? Thanks, Adam
user
10-03-2021 08:50:15 -0500
code

1 Answer

I figured this out with following code... it was actually more simple than I thought. ``` CREATE VIEW bv_ldap_user_permissions AS select * from (select * from hcc_dv_dev.bv_ctigeneral_s3_ldap_matrix_regionsector)a RIGHT JOIN (SELECT GETSESSION('user') as user_name FROM dual()) b ON (a.samaccountname = b.user_name) ```
user
10-03-2021 10:04:35 -0500
You must sign in to add an answer. If you do not have an account, you can register here