You can download the T-SQL source code from the book in a single archive file here.
Chapter 3: Deployment
Chapter 4: Execution
Chapter 6: Execution Logging
Chapter 7: Enterprise Management and Administration
To address the limitations of the built-in SSIS catalog reports, I have created an SSIS catalog dashboard for easy reporting using SSRS.
I also recorded a brief video introduction to the SSIS catalog a few years ago.