Clean Salesforce org is a key for successful implementation. You know the pain when you’ve created so many list views.
Recently one of my clients had the same issue; let me show you how I handled it. It is pretty simple to identify how to find and delete such list views.
Before going ahead, if you haven’t read my previous articles, please do so now. It will help you shape your Salesforce skills with the latest release features.
- Create Dynamic Forms in Salesforce with Clicks
- How to Set Assignment Expiration on Permission Sets and Permission Set Groups
Use Case
Andy is working as a Salesforce Administrator at Appiuss Softwares. His VP of Client Success has to identify the Case list views which he is not Viewed in the last 60 days.
Pre-requisite
Before going ahead, let’s take a minute pause here to understand the ListView object. It represents a list view. A list view specifies a set of records for an object, based on specific criteria.
Solution
- Run the following through VP of Client user’s account.
- Click on Setup | Developer Console
- Navigate to Query Grid and select Query Editor
- Run the following query
select id, name , LastReferencedDate, LastViewedDate, SobjectType from listview where LastViewedDate!=LAST_N_DAYS:60 and SobjectType='Case'
- You have the list view Ids. Have a meeting with your VP of Client Sucess and decide if you want to delete or keep it.

You are Done!!!
I would love to hear about your experience with Unused List View deletion. How do you work on unused list views?
Right now for this article. It helped me to solve my problem. Thank you.
Is there a way to find users who have not logged In to Salesforce in the last 60 days
Use below query
select id, name, LastReferencedDate, LastViewedDate from User where IsActive = true and LastViewedDate!=LAST_N_DAYS:60
I wish this could be this simple. But, unfortunately it’s not.
Lastviewieddate is a ‘logged in user’ specific field. In your use case, if a admin run this query, he/she will see the listviews whichever viewed by him/her.
So, you can’t find all the listviews viewed by ALL users. Not possible. Please check, i am curious to know if there’s a solution for this.
It’s actually a great and useful piece of info. I’m happy that you just shared this useful info with us. Please stay informed like this. Thank you for sharing