300

Please add this feature. It exists for reports created using "Report Writer". Not sure why it can't be done for web-based reports in 5 years.

Also as a general question: Is there any communication that goes out to those who up voted an idea, when the feature is added in SolarWinds?

I was also looking for a component monitor in "Appinsight for SQL" template specifically for AlwaysOn. Our DBA team is looking for that feature.

Is this feature going to be added ever? I can't believe that almost in 5 years, the status of this request is still "OPEN FOR VOTING". Anyone has any suggestion on what needs to be done to get traction on this request? We do need this feature as well.

Hi Michael Halpin First, thank you so much for putting this great learning material. It's is very helpful. I am just curious to know if you are planning to add section 4, 5 and 6? Specifically 4 is what I would be very interested in.

How can I create a view (dashboard) where I can list specific nodes and alerts that node can trigger. I can see this working in node details page for one single node, but I want to do this for a group of nodes. I think there must be a way to do this which I don't know yet. If someone has created a view/dashboard like this,…

That's great. Thank you so much for taking extra efforts to help me out. I am trying this on my side and will post the result here soon. One more question: how did you turn on the debug log?

I did vote it up. Just have to wait now

Thank you for your suggestion Raul. I'll check that out.

Thank you for your response akash1309. Yes I am able to run the powershell script directly on the host machine and it does fetch expected result without any problems. I’ll check other points as soon as I can access solarwinds again. Regards, Pramod Patki

Thank you yaquaholic I'll start from there

Sorry for delay in response. This is the SQL I was using: IF OBJECT_ID('tempdb.dbo.hold_sql_services', 'U') IS NOT NULL DROP TABLE tempdb.dbo.hold_sql_services; IF OBJECT_ID('tempdb.dbo.hold_sql_status', 'U') IS NOT NULL DROP TABLE tempdb.dbo.hold_sql_status; CREATE TABLE tempdb.dbo.hold_sql_services ( SQL_ServiceName…

This is what I am using: USE [master]; DECLARE @DBCount int SET @DBCount = 0; DECLARE @Version int SET @Version = SUBSTRING( CONVERT(varchar, SERVERPROPERTY('ProductVersion')) , 0 , CHARINDEX('.', CONVERT(varchar,SERVERPROPERTY('ProductVersion'))) ); DECLARE @InstanceName nvarchar(128) SET @InstanceName = @@SERVERNAME;…

I would love to use out of the box solution too, if there is one. Please let us know if you find something.

Hi mikkokok, Did you resolve the problem you were having? I am facing the same issue and would greatly appreciate if you can share the steps you had to take to fix it.

Thank you so much dan jagnow​ Making that change worked and I can see the result now. I can't believe I didn't notice that

Thank you for your reply, mesverrum. I'll try it out. Also, I just found about the field "Count Statistic as Difference" which is for "Changes the statistic to be the difference in query values between polling cycles. I think I need something like this. This field and CHECKSUM function from SQL might be helpful here. I am…

Thank you for your response jeilers. I am trying to use "Windows Power Shell monitor" and when I try to test the component, I am getting "NaN" as output all the time. Regardless of what SQL I use. As I am not a all familiar with Power shell, I might be making some basic(stupid) mistake, but I am unable to find it. This is…

Thank you mbussey. I have not tested in yet due to some other roadblock but I think this will work for me. I'll update here when I test and use it.

Thank you for your reply jrouviere The script is: $Error.Clear(); function Get-ODBC-Data{ param( [string]$query=$("SELECT [name] as DBName, CONVERT(int, is_auto_update_stats_on) AS is_auto_update_stats_on FROM sys.databases"), [string]$username='dbusername', [string]$password='dbpassword' ) $conn = New-Object…

Hi s.elmrabet​ When I click on the link it just takes me to HOW CAN WE HELP YOU page of Success Center. I am looking for troubleshooting documents for Web Based Reports and Report Scheduler. Can you please tell me what I am missing here to access the link or re-share the link if it has changed. Thank you.

Great thanks mesverrum​ Just minor correction for anyone who might come to this thread: the table name is apm_componentsetting

I use the "SQL Server User Experience Monitor" and put the SQL in the monitor. Then After assigned node to this monitoring template, we have created custom property 'emailids' at template level. I don't know how it's setup at back end (it was done before I joined in) but we can provide email ids separated by simple comma…

Works like a charm! Thank you so much.

Thank you for your reply yaquaholic "but you will need to get your powershell script to retrieve the information from the database first to populate the variable:" This is not exactly what I want as the DBName is the custom property I have created which will have one/more strings. (DB names but not from Nodes table.) A…

This is really helpful. I have a related question: Is it possible to create a SWQL/SQL that will list "All Alerts this node can trigger" for a group of nodes? I see on node details page, there is a section that shows exactly this. But I can't find SWQL/SQL that is used at back end for it (so i could reuse it and pull same…

I got it. I had to change the Write-Host statements to: Write-Host ("Statistic.{0}: {1}" -f $rowCount, $row.col2); Write-Host ("Message.{0}: Value of col2 for {1} is {2}" -f $rowCount, $row.col1, $row.col2); Sorry to bother all here.

The issue was found to be the missing SQL Powershell extension. It needed to be installed and was installed not on the CPM servers. As this was not a quick thing to be done for me, I instead used ODBC connection and it worked out for me after fixing all the issues.

I did some research and found that I should import a module "sqlps" to solve this. So, when I used (as suggested in microsoft forum): Import-Module "sqlps" -DisableNameChecking I get error: Output: ============================================== Message.xxxx 1 Errors: ==============================================…

I did enclose my Power Shell code in the do{}while like: $Error.Clear(); $loop_count = 0; do { $loop_count++; $result = Invoke-Sqlcmd -Query "BIG SQL QUERY" -ServerInstance "DB_Hostname" } while($result.count -gt 0) Write-Host "Statistic.xxxx" $result[0]; Write-Host "Message.xxxx” $loop_count; exit 0 And now at least I get…