Is there any way We can find the Last active column data from Manage Users console of QuickSight via API. I don't want to use cloudtrail logs as it will have data of last 90 days only

From the console we can fetch the data of every user and check which user has logged in to QuickSight. But it is a difficult task to check for every user manually.
Is there any way We can find the Last active column data from Manage Users console of QuickSight via API. I don’t want to use cloudtrail logs as it will have data of last 90 days only.

The only way I know of now would be to do it through CloudTrail.

You can set it up though, with either s3 lifecycle policies or by adding where clauses to views to only capture the past 90 days.

You can also add a filter in quicksight.