Hello All,
Just wanted to check If we can extract list of users in SMAX along with the group name in excel sheet in single shot, may use API like below, but getting below error. Can anyone suggest on this please.
Cybersecurity
DevOps Cloud (ADM)
IT Operations Cloud
If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it!  Learn more
Hello All,
Just wanted to check If we can extract list of users in SMAX along with the group name in excel sheet in single shot, may use API like below, but getting below error. Can anyone suggest on this please.
Hello,
You cannot extract more than 10K records using the EMS API. For larger volumes, please use the OData API.
Additionally, the Group membership is a MANY2MANY relationship, OData API also supports this use case.
Note that Excel has an OData connector, you can configure Excel to trigger the calls and update the data. For more details, please consult the documentation:
https://docs.microfocus.com/doc/SMAX/24.3/UseODataForBIIntegration
This page also shows how to use Power BI to integrate with OData. The setup is very similar for Excel as well.
https://docs.microfocus.com/doc/SMAX/24.3/IntUserSMAXAUTHTOKENAccessOData
Best regards,
Brindusa