tscrip

Yes. I originally had it set to HTML and it did not work.

I attempted to convert my query to SWQL, but it still doesn't seem to work. Does this look correct to you guys? I do have a Recipient and SMTP Server specified, but I remove them for this screenshot.

I changed the SQL query to: ${SQL: SELECT Title AS Title FROM ReportDefinitions JOIN ReportJobDefinitions ON ReportDefinitions.ReportID=ReportJobDefinitions.ReportID JOIN ReportJobs ON ReportJobDefinitions.ReportJobID=ReportJobs.ReportJobID WHERE ReportJobs.Name = 'Every Monday Morning at 8:00 AM'} and I still get the body…

I attempted removing the space between SQL: and Select. That still did not fix the issue.

I am on NPM 11.5.1. The report was generated via the win32 "Report Writer" application. When I browse to the Report, it looks great. The issue is in the Scheduled Report Email that I have sent out. It just shows SQL code. I will look into SWQL. Thanks for the help.

Is there somewhere you need to enable this on the Server? I have this exact issue. I have tried rebuilding Performance Counters, but that does not seem to fix the issue. I have tried all of the solutions in the following articles, but now I am out of ideas: Restore Missing SQL Server Performance Counters | SQL Server…

I am fairly new to Solarwinds. Does this SQL query replace the need for an application monitor that monitors the disks?

I know this is a pretty old post, but I was interested if you found a solution. We are looking to do something similar. We currently keep our contact/support information for each system in a separate SQL DB, so the ability to query this via direct SQL query or possibly Web Service would be very beneficial.