I am using metadata API to retrieve the LastModifiedBy of an Object. But, it returns me only one User.
I wanted to know if we can track, the Users whoever modified the Object. Is it possible by any means?
Starting with Winter'16 the SetupAuditTrail object has now been exposed via the Salesforce API's and within Apex via SOQL. Its pretty much a mirror of the CSV download, accept for the Delegate User (though since this is documented, this could be a bug or something i'm missing). The following is a sample query from my latest blog where i dig into it a little further...
List<SetupAuditTrail> stuffDoneByConsultants =
[SELECT Id,
Action,
CreatedBy.Name,
CreatedDate,
Display,
Section
FROM SetupAuditTrail
WHERE CreatedBy.Email LIKE '%xyzconsulting.com%'];
I think you're looking for the Setup Audit Trail. This setup screen should display the last 20 metadata modifications, the last 6 months can be downloaded as csv.
Setup > Security Controls > View Setup Audit Trail
Update: Apparently this data is not exposed/supported by the Metadata API (or any other). There is an idea on the IdeaExchange on which you can vote: Make Audit Setup Trail History available via the API
Yes we can track all changes to salesforce through Audit Trial. There are some tools available in appexchange like AutoRABIT where we can track changes to all metadata memebers with given date and time. By using advanced search options we can search by date,metadata type,modified user,component name etc.
Thanks,
Niranjan.