Skip to content

Instantly share code, notes, and snippets.

@omniphx
Created March 10, 2015 12:58
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save omniphx/26f1340de4893d98413b to your computer and use it in GitHub Desktop.
Save omniphx/26f1340de4893d98413b to your computer and use it in GitHub Desktop.
Records owned by User
Id userId = '005i000000XXXXX'; //Input userId
Map<String, Schema.SObjectType> sobjects = Schema.getGlobalDescribe();
system.debug('sobjects: ' + sobjects);
Map<Schema.SObjectType, Integer> ownerMap = new Map<Schema.SObjectType, Integer>();
for(Schema.SObjectType sobj : sobjects.values())
{
Set<String> objectFields = sobj.getDescribe().fields.getMap().keySet();
Boolean queryable = sobj.getDescribe().isQueryable();
if(objectFields.contains('ownerid') && queryable) {
Sobject[] results = Database.query('SELECT Id FROM '+sobj+' WHERE OwnerId = :userId Limit 1000');
if(!results.isEmpty()){
ownerMap.put(sobj, results.size());
}
}
}
for(Schema.SObjectType item : ownerMap.keySet()){
system.debug(item+': ' + ownerMap.get(item));
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment