Creating a view detailing users that have been assigned to spaces

[klorn_pallier]

I'm wondering if it is possible to create a view detailing what users that have been assigned to what space? I've tried find this data in the SYS and DWC GLOBAL sources without success. Can anybody help please?

[Cocquerel]

Using DWC-CLI command line tool, you can get the space definition including members in JSON format, see https://help.sap.com/docs/SAP_DATA_WAREHOUSE_CLOUD/9f804b8efa8043539289f42f372c4862/5eac5b71e2d34c32...

Such command line tool can be called from HANA using SDI File Adapter and JSON response be parsed via SQL Script and display as table output of a table function in DWC Open SQL. In the following blog, I have described a similar solution where I'm calling XS command line tool from HANA : https://blogs.sap.com/2021/12/13/manage-xs-advanced-via-sql/