SQL Query Datasource (T-SQL)
I have a T-SQL query for showing disk IO stats (from 'sys.dm_io_virtual_file_stats'). I'd like to present this table data to a widget on a dashboard. What is the best/most efficient way of doing this? This is something I've not explored before (T-SQL specifically), but have done similar with custom PowerShell/WMI/Groovy so the principle knowledge is good. ThanksCan LM run a SQL Query against a specific Server/Database and alert based on the results?
Hi, I had a request for this today, but I've never done anything like this, so I'm not sure If it's possible or how to do it. The original request was to run a certain query and create an alert if it returns any results. I'm assuming that normally this table is blank, and if there's anything in it, that means something is broken, behind, etc, so they want to know. I'm guessing we could either treat it like an Eventsource where any results just makes a stand alone alert every time it runs. Or I could have them modify the query to return a Count of results and then maybe set it up like a Datasource with thresholds based on the Count that is returned. So that brings me to: Is something like this possible? Does anyone have a tutorial or example on how I'd set something like this up? I have a lot of experience using LM with the stuff it comes with, but I have little experience creating new source from scratch or doing scripting or anything like that. Thanks!Missing JDBC connection string
Hello, I have recently seen a few of these tickets com across the board and was wondering if anyone would be able to give me a quick breakdown as to what this actually is and what the benefits would be to add this into the instance. SQL Server Troubleshooter-MSSQLSERVER Missing JDBC connection string. Manually add one to mssql.mssqlserver.mssql_url or check login informations exitCode A Microsoft SQL server has configuration problems or a logon error. MSSQLSERVER Missing JDBC connection string. Manually add one to mssql.mssqlserver.mssql_url or check login informations Thanks in Advance!
