Reading Trace Logs with Splunk Add-on for SQL Server

Hello fellow Splunkers! In this blog post, we will outline how to utilize the Splunk Add-on for Microsoft SQL Server to ingest the binary trace log data that is generated by SQL Server. 

In order to accomplish this objective, we must first establish a connection to the SQL Server instance using DB Connect. This of course involves creating an "Identity" that can authenticate to the database instance, and then creating a "Connection" via that Identity. This connection needs to be facilitated by a database driver, and one pitfall to watch out for here is to make sure to choose the...

No Content Server Explorer for Mac OS? No Problem!

After years of owning a PC and taking my environment setup for granted, I landed with a Mac OS that has proven to be a bit of a challenge when it comes to spinning up the 11g JSK. Among the drawbacks is the lack of a Content Server Explorer (CS-Explorer) as the JSK stores it as an executable.

The lack of a Mac installer for the explorer within the JSK is not drastic. Technically, miracles can happen - or close enough - when you have an Intel processor and the help of a third-party tool. However, today I have decided to take a completely different route. Come to think of it, the...

Troubleshooting Tips for Splunk DB Connect 3

Hello, fellow Splunkers! In this post, we'll take a look at a few of the pitfalls to be aware of when using the quite powerful, but sometimes hard to troubleshoot, DB Connect (DBX) 3.1.1 application from Splunkbase. So let's jump right in, shall we?

NULL values for Timestamp

If a database table that you're importing (either rising column or batch mode) contains a column representing a timestamp, most likely you'll want to utilize that column as the timestamp of the event (database record) within Splunk, instead of using the index time as the timestamp. However, be...

Using Splunk to Predict the Weather

Planning a camping trip can take a lot of time. You have to figure out how many tents you need, what kind of tents, how much food to pack, what tools you need to bring, what clothes you need to wear, etc. A lot of the plans can be based off of one thing, the weather. Going to a rain forest? Pack a heavy rain jacket, a couple of tarps, and waterproof everything. Going to the desert? Pack a sun hat, shorts, and containers for water. Unfortunately, unless you know you’re going to a place with extreme weather, you might not be able to perfectly predict the weather.

This is where Splunk...

Splunking Drupal

Drupal developers rely on various logging systems to troubleshoot and investigate Drupal exceptions and errors. We can use frontend Apache/Nginx access and error logs along with native PHP logs. But, unquestionably, the Drupal database logging module is at the core of these logging frameworks because it captures all triggers to internal Drupal hooks, events, and activities occurring on the Drupal site. Drupal's database logging framework is the bucket that captures not only the operations of the different modules (core...

Making Manual Labor a 'lil less Manual

The Big Hurt

Who the heck wants to do manual labor when your finger nails are as well-manicured as ours are, eh? The WebCenter Sites Practice at Function1 is in full swing in the WCS 12c upgrade cycle, with a few clients in the process. As it were, the upgrade itself can be "sort of easy" to nearly impossible depending on the approach taken and feature(s) of your particular implementation. If the upgrade gods are shining their light down on you, you only need to go from to 12c. However, there's a good chance that that isn't you, OR that that god is dead OR doesn't exist...

Meet the Slack App for Splunk

We're excited to announce the release of our new Slack App for Splunk! The Slack App for Splunk helps to gain insight into your company’s Slack environment.

The app seamlessly monitors your team's Slack activity by leveraging the Slack App for Splunk’s modular inputs. The messages generated in your public Slack channels are collected and indexed into Splunk, ready for reporting!

The Slack App for Splunk also provides prebuilt dashboards for Slack monitoring. The app effortlessly track metrics including: where and how often your users are logging in and what channels are being...

Enhance your WCS Dashboard Widgets with D3.js

As far back as I can remember, WebCenter Sites' Contributor UI dashboard widgets have been simple HTML tables full of text. Behold, D3.js, a JavaScript library that helps "bring your data to life" and easily create animated graphics. 

A good use case for this is the two dashboard widgets that come with Function1's LingoTek inside WebCenter Sites product (pictured below), which simply show some numbers about recent activity between WCS and Lingotek.



WebCenter Sites Dojo Tips & Tricks

WebCenter Sites allows you to customize the UI in many ways. Much of the UI is rendered using Dojo, but very little of WCS's Dojo APIs are documented. Here are a few simple Dojo code snippets that may be of use to you:

Display Info, Warning, or Error messages

The WebCenter Sites developer guide describes how to display an "info" message (the green message pictured above), but you can also display warning (yellow) and error (red) messages:

var view = SitesApp.getActiveView(); // the active view (AKA the current tab)"OK Message.");            // display...

Wellness at Function1

In 2014, Function1 launched a Wellness Program with the goal of promoting a healthy workplace through fitness and wellness challenges.  We have run a number of challenges over the years, ranging from step challenges using FitBit devices to meeting personal goals.  The average length of the challenges has been 3 months and participation has ranged from 40% to 60%, depending on the challenge.  We have also incentivized participation through rewarding winning participants and/or teams with gift cards.

In order to gain insight and tips on improving Function1’s wellness strategy,...

Stay In Touch