Is there a way to tell what user has been selected in the Viewing Dashboard as field? I want an embedded VF page that will automatically refresh based on that field.
SELECT Id, Description, DeveloperName, RunningUserId, RunningUser.isActive, Title, Type FROM Dashboard
WHERE RunningUser.isActive = false OR Type = 'LoggedInUser' so:
I can see where we screwed up the deactivation of users and dashboard will fail to run (pain especially if it was scheduled)
I look for candidate for delete/demotion when we've run out of the 5 dynamic dashboards limit.