Splunk Webinar: Maschinendaten anreichern mit Informationen
-
Upload
georg-knon -
Category
Software
-
view
899 -
download
0
Transcript of Splunk Webinar: Maschinendaten anreichern mit Informationen
1
Copyright © 2014 Splunk Inc.
Maschinendaten anreichern mit Informationen
Philipp DriegerSales Engineer
2
Splunk WebinarMaschinendaten anreichern mit Information
Ihr Ansprechpartner:Philipp DriegerSales Engineer
3
DisclaimerDuring the course of this presentation, we may make forward looking statements regarding future events
or the expected performance of the company. We caution you that such statements reflect our current expectations and estimates based on factors currently known to us and that actual events or results
could differ materially. For important factors that may cause actual results to differ from those contained in our forward-looking statements, please review our filings with the SEC. The forward-looking
statements made in the this presentation are being made as of the time and date of its live presentation. If reviewed after its live presentation, this presentation may not contain current or accurate information.
We do not assume any obligation to update any forward looking statements we may make.
In addition, any information about our roadmap outlines our general product direction and is subject to change at any time without notice. It is for informational purposes only and shall not, be incorporated
into any contract or other commitment. Splunk undertakes no obligation either to develop the features or functionality described or to include any such feature or functionality in a future release.
4
Agenda
Splunk für MaschinendatenMethoden zur Anreicherung
Live: CSV | KVStore | Script | DBX | ODBCQ&A
5
Make machine data accessible, usable and valuable to everyone.
6
Das beschleunigte Wachstum von DatenVolume | Velocity | Variety | Variability
GPS,RFID,
Hypervisor,Web Servers,
Email, Messaging,Clickstreams, Mobile,
Telephony, IVR, Databases,Sensors, Telematics, Storage,
Servers, Security Devices, Desktops
Machinendaten umfassen den am schellsten wachsenden, komplexesten und wertvollsten Bereich von Big Data
6
7
Machinendaten enthalten wertvolle InformationenOrder ID
Customer’s Tweet
Time Waiting On Hold
Product ID
Company’s Twitter ID
Order ID
Customer ID
Twitter ID
Customer ID
Customer ID
Sources
Order Processing
Care IVR
Middleware Error
8
Industry Leading Platform For Machine Data
Machine Data: Any Location, Type, Volume
Online Services Web
Services
ServersSecurity GPS
Location
StorageDesktops
Networks
Packaged Applications
CustomApplicationsMessaging
TelecomsOnline
Shopping Cart
Web Clickstreams
Databases
Energy Meters
Call Detail Records
Smartphones and Devices
RFID
On-Premises
Private Cloud
Public Cloud
Platform Support (Apps / API / SDKs)
Enterprise Scalability
Universal Indexing
Answer Any Question
DeveloperPlatform
Report and
analyze
Custom dashboards
Monitor and alert
Ad hoc search
Universal Machine Data
Platform
9
Industry Leading Platform For Machine Data
Machine Data: Any Location, Type, Volume
Online Services Web
Services
ServersSecurity GPS
Location
StorageDesktops
Networks
Packaged Applications
CustomApplicationsMessaging
TelecomsOnline
Shopping Cart
Web Clickstreams
Databases
Energy Meters
Call Detail Records
Smartphones and Devices
RFID
On-Premises
Private Cloud
Public Cloud
Platform Support (Apps / API / SDKs)
Enterprise Scalability
Universal Indexing
Answer Any Question
DeveloperPlatform
Report and
analyze
Custom dashboards
Monitor and alert
Ad hoc search
Any amount, any location, any source
Schema-on-the-fly
Universal indexing
No back-end RDBMS
No need to filter
data
Schema on the Fly
10
Methoden zur Anreicherung
11
Anreicherung von Events in Splunk
Erweiterung der raw events um zusätzliche Felder, welche aus externen Datenquellen stammen.
LDAP, AD
WatchLists
CRM/ERP
CMDB
Externe Datenquellen
Insight OUT
Data IN
…
12
Anreicherung mit LookupsDurch Lookups können in Splunk Maschinendaten mit zusätzlichen Informationen angereichert werden.
Es wird dabei ein Mapping von Feldwerten in Events auf Feldwerte einer externen Datenquelle realisiert und neue Werte den Eventdaten zugefügt.
Beispiel: Lookup von HTTP Status Codes in einem CSV File mit der entsprechenden Beschreibung des Codes.
13
Mehrwerte durch LookupsDarstellung von Maschinendaten in der Sprache der FachabteilungenDifferenziertere Analysen und Aufteilungen von Auswertungen – z.B. Monitoring von Manager User Accounts, HR, Finance, ITVerlinkung von Maschinendaten zu geschäftsrelevanten Prozessen. Z.B. Anreicherung von Bestelldaten mit Artikellisten inklusive Beschreibung, Verfügbarkeit, Preis etc.
Integration von SAP BestandsdatenCRM DatenProduktinfosPreislistenWHOISGeolocationZip codes
14
Übersicht: Methoden für Lookups in Splunk
ODBC driver (MS Excel,
Tableau, …)
CSV FileLookup
Script(Python, Perl,
shell, …)
DB Connect(DB2, Oracle, MySQL, …)
KVStore(Key Value
Store)
15
Übersicht: Methoden für Lookups in Splunk
CSV File KVStore Script DB Connect ODBC
Indexer / Search Head Search Head ONLY Indexer / Search Head Indexer / Search Head Indexer / Search Head
Statisch Dynamisch Dynamisch Dynamisch Dynamisch
DEMO DEMO DEMO DEMO OVERVIEW
16
Demo #1CSV Lookup
17
CSV LookupSetup Lookup Table Files
18
CSV LookupSetup Lookup Definitions
19
CSV LookupAnd: Look IT up
20
CSV LookupRessourcen
Dokumentation: http://docs.splunk.com/Documentation/Splunk/latest/Knowledge/AddfieldsfromexternaldatasourcesEinführung zur Einrichtung von Lookups mit Beispiel HTTP codes: http://docs.splunk.com/Documentation/Splunk/latest/Knowledge/UsefieldlookupstoaddinformationtoyoureventsBlog Artikel: Enriching Data with Lookups (Part 1-2): http://blogs.splunk.com/2009/07/27/enriching-data-with-lookups-part-1/
21
Demo #2KV Store
22
KV Store Lookup Setup
/splunk/etc/apps/<appname>/local
23
KV Store LookupBring your data in:
24
KV Store LookupRessourcen
Dokumentation: http://docs.splunk.com/Documentation/Splunk/latest/Knowledge/ConfigureKVstorelookupsMigration von Lookups mit CSV Files zu KV Store: http://dev.splunk.com/view/webframework-features/SP-CAAAEZQBeispiele KV Store: http://dev.splunk.com/view/webframework-features/SP-CAAAEZHKonfiguration KV Store über REST API: http://dev.splunk.com/view/webframework-features/SP-CAAAEZG
25
Demo #3Script (Python)
26
Scripted LookupExample DNSLOOKUP (external_lookup.py)
27
Scripted LookupExample DNSLOOKUP (external_lookup.py)
Usage lookup hostname: … | lookup dnslookup clientip as ipUsage lookup ip: … | lookup dnslookup clienthost as domain
28
Demo #4DB Connect (MySQL)
29
Lookup mit DB Connect: MySQL
30
Lookup mit DB Connect: Identity
31
Lookup mit DB Connect: Connection
32
Lookup mit DB Connect: Test Query
33
Lookup mit DB ConnectRessourcen
Splunk App for DB Connect (V 2.0):https://splunkbase.splunk.com/app/2686Dokumentation DB Connect: http://docs.splunk.com/Documentation/DBX/latest/DeployDBX/AboutSplunkDBConnect
34
OverviewODBC
35
Übersicht Splunk ODBC (Windows)
Analyst
Splunk admin
Saved Searche
s
ODBC driver(SQL to SPL translation
layer)
STEP 1 Business user and Admin work together to define and build the saved search in Splunk.
1
STEP 1 Business user uses tool to access saved search and retrieve data from Splunk.
2
36
ODBC Treiber für Splunk Enterprise
Download Splunk App: https://splunkbase.splunk.com/app/1606
Documentation ODBC:http://docs.splunk.com/Documentation/ODBC
On Windows OS:Splunk ODBC Driver
+ Tool of choice
Splunk Enterprise auf jeder unterstützten Platform:
- Windows- Linux- OS X- Solaris
37
Zusammenfassung
38
ZusammenfassungMaschinendaten enthalten wertvolle InformationenDurch Anreicherung mit externen Datenquellen können diese explizit gemacht werdenSplunk bietet viele Methoden für Lookups:– CSV Files– KV Store– Script– DB Connect– ODBC
Machen Sie Ihre Maschinendaten durch Lookups verständlicher für Ihre Nutzer!
39
Vielen Dank!Q&A:Bitte den Chat benutzen
Philipp DriegerSales Engineer
40
Thank You