Загрузка данных

select(@Host as Актив, host.Fqdn as Имя, host.IpAddress as "Сетевой адрес", host.@vulners.Status as "Статус уязвимости", Host.OsName as "Наименование ОС", Host.OsVersion as "Версия ОС", Host.@AuditTime as "Дата и время последнего аудита", Host.@Vulners.CVEs as Уязвимость, Host.@Vulners.SeverityRating as "Уровень опасности уявзимости", Host.@Vulners.IssueTime as "Дата публикации паспорта уязвимости", Host.@Vulners.Description as "Описание уязвимости", Host.@Vulners.VulnerableEntity.Name as "Название уязвимой сущности", Host.@Vulners.VulnerableEntity.Version as "Версия уязвимой сущности", Host.@Vulners.Patch as Патч, Host.@Vulners.HowToFix as "Как исправить") | filter(host.@vulners.Status = "new") | filter(Host.@AuditTime >= now() - 8d) | sort(Host.@Vulners.SeverityRating ASC) | filter(Host.@Vulners.SeverityRating != "None") | sort(Host.@Vulners.SeverityRating DESC) | limit(0)