SCCM - MSSQL Find Possible Broken Packages

I know one of the biggest things people come across as an SCCM administrator is trying to quickly identify sites where packages are broken. This query gives a basic rundown of identifying potential pain points in your package distribution:

use SMS_000

go

Select R.PackageID,

      s1.Name,

      R.SiteCode,

      R.ServerNALPath,

      s1.SourceVersion as "ActualSourceVersion",

      R.SourceVersion as "SiteSourceVersion",

      R.State,

      R.SummaryDate,

      R.InstallStatus

      from dbo.v_PackageStatusDistPointsSumm as r

            full join dbo.v_Package

                  as s1 on s1.PackageID = r.PackageID

      where R.State <> 0

GO