public void OnGet() { LastRun = queries.GetLastRun(); Reports = queries.GetAuditReports(LastRun.RunID); Subscriptions = Reports.Select(r => r.SubscriptionID).Distinct(); WebApps = Reports.Where(r => r.Type == AppService); SqlServers = Reports.Where(r => r.Type == SqlType); RedisCaches = Reports.Where(r => r.Type == RedisType); }