Currently i am running this report of 95th percentile utlization for last 7 days.
Can someone please suggest to set the @StartDate and @EndDate in business hour for last 7 days
SET @StartDate = FLOOR(CAST(DATEADD(WEEK, -1, GETDATE()) AS FLOAT));
SET @EndDate = CAST(GETDATE() AS FLOAT);
dbo.GETInBps95th(InterfaceID, @StartDate, @EndDate) / Interfaces.InterfaceSpeed * 100 AS PercentIN