Where is the User and the Security Roles stored in the Data Lake?
Audit and Monitoring Setting have Publish Auditing and Monitoring data to Data Lake checked.
Auditing and Monitoring data is sent to schemas starting with AM_ respective of their type
This data is in two encoded columns of before and after (depending on how you configured).
It likely is not the data that you want thought. It is a Audit / change transaction for each entity. I presume you are seeking a current list of all Roles, that is not in Data Lake. Suggest a ER if desired.
You could export and import them to data lake, possibly API pull them, but currently nothing in Security does that now.
What is the requirement?
List of security roles and Names
I'm assuming, it would be feasible to retrieve the user and security roles information from Syteline tables such as UserNames and GroupNames.
I think we need more detail about what exactly you are trying to accomplish in order to assist.
However, a list of all Security Roles in IFS can be queried using the IFS API; see master data types and master data nodes. If you need that data in the Data Lake, you might be able to create a Data Lake flow in ION to ingest that data into the Data Lake as Kevin alluded to.
</code></pre> <pre class="curl microlight"><code class="language-bash">/usermgt/v2/admin/masterdatatypes/
</code></pre> <pre class="curl microlight"><code class="language-bash">/usermgt/v2/admin/masterdatatypes/{masterdatatypeguid}/masterdatanodes
how about in Infor OS > CSD
