Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
SFDC TechSFDC Tech 

Formula to find if an inactive user owns any records

Is there a formula in to find if an Inactive user owns any records ?or is there a way to find the number of records owned by inactive users?

Please advise!!


Thanks!
Bhanu MaheshBhanu Mahesh
Hi SFDC Tech,
1.
You create a formula field of type Checkbox on the object and formula will be 'Owner.IsActive'. It returns true if Owner is Active otherwise false.
Then create a report on the object with this checkbox = false as filter.
This report will give you the number of records which are owned by inactive users.

2.
Run a query in developer console which will give you the count of records which are owned by inactive users.

For Ex:
Select count() FROM Contact WHERE Owner.isActive = false

Regards,
Bhanu Mahesh