Finding Stale Assets by Last Synchronization Timestamp

Original Slack Thread

Hello all! One question, how can I get a list of all the assets that were not recently synchronized? Say, all assets that were not synchronized for 3 days? Is there a filter for this on the UI?

<@U03BEML16LB> might be able to speak to this!

by last synchronized you mean the UI timestamp we show meaning the last time this entity was ingested by ingestion? unfortunately there’s no specific filter right now for you to find those entities. however, you can always reference the entities generated in your ingestion runs and find which ingestion source hasn’t run in the last X days and that may allow you to find what you’re looking for!

What I am doing instead is running this query:

  search(input: {type: DATASET, start: 0, count: 500, query: "*"}) {
    total
    count
    start
    searchResults{
      entity {
        ... on Dataset {
          name
          lastIngested
          platform {
            name
          }
        }
        
      }  
  }
	}
}```
and using the lastIngested timestamp to get a list of all the stale entities (since we run the ingestions everyday)

nice! sounds like a solid workaround