Get Incidents Containing a Specific Keyword from SCSM

SQL query in this post will get all incidents containing “print” keyword, along with analyst comments from Service Manager operational database. Comments are not available in data warehouse by default.

SQL Blocking – Troubleshooting In Transaction User Interactions

This Post Explains How To Troubleshoot and Fix Applications causing SQL Blocking doing User Interactions inside SQL Transactions.