All Apps and Add-ons

How do I pull SharePoint logs into Splunk ?

raj_mpl
Path Finder

Hello Everyone ,

Found some of the question and answer pairs related to pulling SharePoint logs into Splunk and the visualizations which are dated back 2010-12 … Can any one please help in figuring out the following?

1)What are the basic steps that need to be done to pull SharePoint logs into the Splunk environment?
2)What type of log files are important to ingest ?
3)Any guidance related to dashboard things would be highly appreciated

Thank you all.

0 Karma

mswenson
Engager

This is the info that I am pulling into Splunk from SharePoint 2019

  • perfmon
  • IIS logs
  • ULS logs

I am storing the IIS and ULS logs in a sharepoint index. I built out a correlation search dashboard so I don't have to use the Merge-SPLogFile cmdlet for PowerShell.

Here are the inputs.conf, props.conf and transforms.conf

IIS

[monitor://L:\inetpub\logs\LogFiles**.log]
index = sharepoint
sourcetype = iis
ignoreOlderThan = 1d

ULS

[monitor://L:\Diagnosticslog]
index = sharepoint
whitelist = .*-\d+-\d+.log$
sourcetype = MSSharePoint:2019:ULSAudit
ignoreOlderThan = 1d

PROPS.CONF

[MSSharePoint:2019:ULSAudit]
SHOULD_LINEMERGE = false
CHECK_FOR_HEADER = false
LINE_BREAKER = ([\r\n]+)\d{2}/\d{2}/\d{4}\s\d{2}:\d{2}:\d{2}.\d{2}\s
TRANSFORMS-ulscomment = uls_remove_comments
SEDCMD-cleanup = s/(...([^*]+).*?...)//g

TRANSFORMS.CONF

[uls_remove_comments]
REGEX = ^Timestamp
DEST_KEY = queue
FORMAT = nullQueue

0 Karma

raj_mpl
Path Finder

Anyone ???

0 Karma

kmower
Communicator

I agree, that Splunk Add-On only goes to 2012 and the world has moved on. It would be nice to be able to get SP 2016 logs into Splunk.

0 Karma

bullbo
Engager

It would be really beneficial to a lot of people to provide support for the on prem version SharePoint 2016 as not everyone is willing/ready to use the cloud version.

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

[Puzzles] Solve, Learn, Repeat: Classic British Rock Bands

This puzzle series (first published here) is based on extracting information from statements about well-known ...

New to the Community? Join Us for an Exclusive Post .conf26 Welcome Session (Plus a ...

Keep the .conf26 Energy Going: Welcome to the Splunk Community! Whether we scanned your badge at the Community ...

Accelerate Splunk App Development with AI

  Learn how to automate the repetitive parts of your build cycle.   Register to Attend   Join our Tech Talk ...