All Apps and Add-ons

SOLVED - SQL Hosts dashboard in App for Microsoft SQL Server

MaverickT
Communicator

I was playing with App for Microsoft SQL Server and came around with issue of not displaying hosts in SQL Hosts dashboard. After hour or two of researching (guess what, there is powershell log in splunk log folder) I found the reason for this behavior.

In default input configuration for TA-SQLServer there is small error for the [powershell://HostInformation] stanza.

Correct configuration should be:

[powershell://HostInformation]
script = & "$SplunkHome\etc\apps\TA-SQLServer\bin\Invoke-MonitoredScript.ps1" -Command ".\hostinfo.ps1"
schedule = 30 */15 * ? * *
index = mssql
sourcetype = MSSQL:Host:Information
source = Powershell

So basically there is one (*) missing between */15 and ?. If you correct this configuration and deploy it on your SQL server's forwarders you are good to go. Hope this solves you few headaches.

0 Karma

sonila
Path Finder

schedule = 30 */15 * ? * *
all schedule are in this format

0 Karma

halkelley
Path Finder

aren't there just 5 parameters? (minute hour day month day-of-week)?

0 Karma
Get Updates on the Splunk Community!

Announcing Scheduled Export GA for Dashboard Studio

We're excited to announce the general availability of Scheduled Export for Dashboard Studio. Starting in ...

Extending Observability Content to Splunk Cloud

Watch Now!   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to leverage ...

More Control Over Your Monitoring Costs with Archived Metrics GA in US-AWS!

What if there was a way you could keep all the metrics data you need while saving on storage costs?This is now ...