blocked_process.value('(/blocked-process-report/blocking-process/process/@waitresource)[1]','varchar(100)') AS blocking_waitresource, blocked_process.value('(/blocked ...
and populates several of the tables (those shown in purple on the supplied model). You should read this schema file carefully and be sure you understand the various data requirements.