Learn how your company can work directly with me or one of my peers.
The benefit is not just having an experienced engineer helping you manage the health of your environment. Through Premier Field Engineering, your company will have access to a wealth of knowledge from all of PFE and a channel into the product group to answer the most complex questions.
/*Count dirty aggregations in last X days*/
DECLARE @Days AS int
SET @Days = 1 --number of days to go back
SELECT Count(*) AS [Failed],
DS.DatasetDefaultName AS [Dataset],
CASE SDAH.AggregationTypeId
WHEN 0 THEN 'Raw' WHEN 20 THEN 'Hourly' WHEN 30 THEN 'Daily' ELSE 'Unknown'
END AS [Type]
FROM Dataset AS DS INNER JOIN
StandardDatasetAggregationHistory AS SDAH ON SDAH.DatasetId = DS.DatasetId
WHERE SDAH.DirtyInd <> 0 AND SDAH.AggregationDateTime > DATEADD(DD, -@Days, getdate())
GROUP BY DS.DatasetDefaultName, SDAH.AggregationTypeId
ORDER BY [Failed] DESC, [Dataset] ASC, [Type] ASC