My current client has 6 Prod Org, now they want to track license detail of all the org and their usage. Like they want to track which user has which Org access, license information,profile and permission set.
Currently we have created two custom object which has master-detail relationship in one org, where Master object will store user information and detail object will store org information like Org name, profile etc.
Currently we are manually uploading data in all these object, but in future we want to automatically upload all these details, like whenever a new user is created or deactivate in any Org it should automatically update in my custom object.
How can I achieve this? Is there any alternative approach of doing this apart from creating custom object?