CREATE VIEW sys.dm_audit_actions AS
--	SELECT * FROM OpenRowset(TABLE DM_AUDIT_ACTIONS) dm
	SELECT REVERSE(CONVERT(char(4), CONVERT(BINARY(4), [action_id]))) as [action_id],
		[action_name] as [name],
		(SELECT spt.name
			from master.dbo.spt_values spt where spt.type='EOD' AND spt.number = CONVERT(smallint, dm.class_id)) as [class_desc],
		[covering_action_name],
		(SELECT spt.name
			from master.dbo.spt_values spt where spt.type='EOD' AND spt.number = CONVERT(smallint, dm.parent_class_id)) as [parent_class_desc],
		[covering_parent_action_name],
		[configuration_level],
		[containing_group_name],
		[action_in_log]
	FROM OpenRowset(TABLE DM_AUDIT_ACTIONS) dm