You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need MSAD info from backend SQL server

Received Response
7
Views
1
Comments
edited Aug 2, 2018 2:36AM in Essbase 1 comment

Summary

Need MSAD info from backend SQL server

Content

Hi All ,

I was working on an extract to get all the AD to ND group mappings from Shared service. Did not find anything suitable in EAS or Shared service.

So i took an export from the CSS_GROUP_MEMBERS from HSS database.

I can easily match the Native Ids with the identity IDs from the CSS_USERS table.

But I can not find a way to match the MSAD IDs with the actual IDs.

Any idea if there is any table on the DB side which might store the MSAD Identity to ID mapping -

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!