SELECT
domain_ScheduleWindow.policyName as "Policy",
lookup_PolicyType.name as "Type",
domain_ScheduleWindow.scheduleName as "Schedule",
(CASE domain_ScheduleWindow.day
	WHEN 0 THEN 'Sunday'
	WHEN 1 THEN 'Monday'
	WHEN 2 THEN 'Tuesday'
	WHEN 3 THEN 'Wednesday'
	WHEN 4 THEN 'Thursday'
	WHEN 5 THEN 'Friday'
	WHEN 6 THEN 'Saturday'
END) AS "Weekday",

(CASE
	WHEN domain_ScheduleWindow.duration != 0 THEN 
		DATEFORMAT(UTCBigIntToNomTime(NomTimeToUTCBigInt(
		DATE(convert(CHAR(20),GETDATE(), 101))
		)+domain_ScheduleWindow.startOffset),'hh:nn:ss')
	ELSE '-'
END) as "Start Time",

(CASE
	WHEN domain_ScheduleWindow.duration > 864000000000  THEN 
		CAST(
		DATEDIFF(hour,
		DATEADD(day, 1, DATE(convert(CHAR(20),GETDATE(), 101))),
		UTCBigIntToNomTime(NomTimeToUTCBigInt(
			DATE(convert(CHAR(20),GETDATE(), 101))
			)+domain_ScheduleWindow.duration ))
		AS CHAR(20))
WHEN domain_ScheduleWindow.duration = 864000000000  THEN '24'
WHEN domain_ScheduleWindow.duration < 864000000000  THEN 
	CAST(
		DATEDIFF(hour, DATE(convert(CHAR(20),GETDATE(), 101)),
			UTCBigIntToNomTime(NomTimeToUTCBigInt(
				DATE(convert(CHAR(20),GETDATE(), 101)))+domain_ScheduleWindow.duration )
		) 
		AS CHAR(20))
ELSE  '0'
END) as "Duration, hrs"

FROM
domain_ScheduleWindow, domain_Policy, domain_Schedule, lookup_PolicyType, nb_Policy

WHERE domain_Policy.masterServerId = domain_Schedule.masterServerId 
AND domain_Policy.name =  domain_Schedule.policyName
AND domain_Policy.policyDomainName = domain_Schedule.policyDomainName
AND domain_Policy.versionNo =  domain_Schedule.policyVersionNo
AND domain_ScheduleWindow.masterServerId = domain_Schedule.masterServerId 
AND domain_ScheduleWindow.policyName =  domain_Schedule.policyName
AND domain_ScheduleWindow.policyVersionNo =  domain_Schedule.policyVersionNo
AND domain_ScheduleWindow.scheduleName = domain_Schedule.name
AND domain_Policy.name = nb_Policy.name 
AND domain_Policy.masterServerId = nb_Policy.masterServerId  
AND domain_Policy.versionNo = nb_Policy.versionNo  
AND domain_Policy.policyDomainName = nb_Policy.policyDomainName  
AND lookup_PolicyType.id = domain_Policy.type 

AND domain_Policy.status = 0
AND domain_Policy.active = 1

ORDER BY "Policy", "Schedule", "Day"