SELECT item.Name AS 'Name',
	   CAST(state as xml).query('data(/item/scheduling[1]/enabled[1])') as Enabled,
	   CAST(state as xml).query('data(/item/registeredSchedules[1]/registeredSchedule[1]/schedule[1]/trigger/@type)') as 'Compliance Schedule',
	   CAST(state as xml).query('data(/item/registeredSchedules[1]/registeredSchedule[1]/schedule[1]/trigger/@at)') as 'Compliance check time',
	   CAST(state as xml).query('data(/item/registeredSchedules[1]/registeredSchedule[1]/schedule[1]/trigger/@frequency)') as 'Compliance Frequency',
	   CAST(state as xml).query('data(/item/registeredSchedules[1]/registeredSchedule[1]/schedule[1]/trigger/@weekdays)') as 'Compliance Week Days',
	   
	   CAST(state as xml).query('data(/item/registeredSchedules[1]/registeredSchedule[2]/schedule[1]/trigger/@type)') as 'Remediation Schedule',
	   CAST(state as xml).query('data(/item/registeredSchedules[1]/registeredSchedule[2]/schedule[1]/trigger/@at)') as 'Remediation check time',
	   CAST(state as xml).query('data(/item/registeredSchedules[1]/registeredSchedule[2]/schedule[1]/trigger/@frequency)') as 'Remediation Frequency',
	   CAST(state as xml).query('data(/item/registeredSchedules[1]/registeredSchedule[2]/schedule[1]/trigger/@weekdays)') as 'Remediation Week Days'
	   
 from dbo.Item
 
where (CAST(state as xml).exist('data(/item/report[1])') = 0
And
CAST(state as xml).exist('data(/item/registeredSchedules[1]/registeredSchedule[1]/schedule[1]/trigger/@type)') = 1)

order by Name asc