Version 1

    This report will show any nodes with a next poll time more than 5 minutes stale...This is a key indicator of an Orion or SQL performance issue.

    Note this is based of the standard polling intervals.  If you use greater intervals you may need to adjust the interval to something larger than 5 minutes.

    In this section of the query simply replace the 5 with the interval you require.

    and (NextPoll < DATEADD(MI,-5,GETDATE()))


    This report also filters out any unmanaged nodes and any external nodes as their next poll time will be stale by default.