Tweet
Tweet

Slide 1

Slide 1 text

No content

Slide 2

Slide 2 text

© JAMF Software, LLC Matt Armstrong Senior Systems Engineer, Research Jamf Leslie N. Helou Senior Professional Services Engineer Jamf 275x275 head shot 275x275 head shot

Slide 3

Slide 3 text

© JAMF Software, LLC Integrating Splunk and JasperReports with Jamf Presentation agenda: •Preparing MySQL for Remote Access •Splunk Integration •JasperReports Integration •Q&A

Slide 4

Slide 4 text

© JAMF Software, LLC Prepare MySQL for Remote Access 1. Modify my.cnf or mysql.cnf or mysqld.cnf to allow connections from remote hosts. change: bind-address = 127.0.0.0 to: bind-address = 0.0.0.0 2 Steps

Slide 5

Slide 5 text

© JAMF Software, LLC Prepare MySQL for Remote Access 2. Create an account within MySQL with read- only (select) permissions to run the queries. mysql> grant select on jamfsoftware.* to myreport@'10.1.1.%' identified by 'Myr3pOr+'; (optional)

Slide 6

Slide 6 text

© JAMF Software, LLC Splunk Integration • Modular Input with Jamf API • Database Connection Available on Jamf Marketplace

Slide 7

Slide 7 text

© JAMF Software, LLC Advanced Search • Define Advanced Search • Computers • Mobile Device

Slide 8

Slide 8 text

© JAMF Software, LLC Modular Input • $SPLUNK_HOME = /opt/splunk/ • Clone the repository • Restart Splunk

Slide 9

Slide 9 text

© JAMF Software, LLC Configure Modular Input • Define an index • Add a Jamf Modular Input • Jamf Pro URL • computer or mobile_device Integrate Advanced Search with Splunk

Slide 10

Slide 10 text

© JAMF Software, LLC Database connection • Install Java - must be Oracle-JDK! • Install Splunk DB Connect • Install mysql driver • Copy driver to Splunk DB Connect app Prerequisites

Slide 11

Slide 11 text

© JAMF Software, LLC Configure Database Connection • Define a mysql user on Jamf DB • Create Identity • Create DB Connection Connect Splunk to Jamf Pro Database

Slide 12

Slide 12 text

© JAMF Software, LLC Splunk Query

Slide 13

Slide 13 text

© JAMF Software, LLC Splunk DB Query • Define a mysql user on jamf DB • Create Splunk Identity • Create Splunk DB Connection • Define Query • Create Splunk Input Query Jamf Pro Database

Slide 14

Slide 14 text

© JAMF Software, LLC Search Processing Language (SPL) • Search your data • Pipe to other Splunk Commands • Build dashboards & Visualize https://docs.splunk.com/Splexicon:Searchprocessinglanguage

Slide 15

Slide 15 text

© JAMF Software, LLC Splunk Reporting

Slide 16

Slide 16 text

© JAMF Software, LLC More Splunk Searches https://docs.splunk.com/Splexicon:Searchprocessinglanguage

Slide 17

Slide 17 text

© JAMF Software, LLC Visualizations

Slide 18

Slide 18 text

© JAMF Software, LLC JasperReports Integration • Install JasperReports on a server • Install Jaspersoft Studio on a client 2 components to install

Slide 19

Slide 19 text

© JAMF Software, LLC Install the Server - JasperReports • Runs on Windows, Linux and Mac • Can use the bundle installer or use existing Tomcat and/or PostgreSQL • System Requirements Resource Footprint Minimum Recommended Disk ~1.5 GB 10GB free 40GB+ RAM 4GB 8GB+ Processor 2 cores 2.5GHz + multi-core Pentium

Slide 20

Slide 20 text

© JAMF Software, LLC Connect to the Server http://reports.lab.private:8080/jasperserver/login.html Default Credentials: User ID: jasperadmin Password: jasperadmin

Slide 21

Slide 21 text

© JAMF Software, LLC Add a Data Source Right-click Data Source Move the mouse over Add Resource Click Data Source

Slide 22

Slide 22 text

© JAMF Software, LLC Max image dimensions Configure the Type and Properties • JDBC Driver • Host (MySQL server) • Port • Database • User Name • Password

Slide 23

Slide 23 text

© JAMF Software, LLC Install the Client - Jaspersoft Studio • Runs on Windows, Linux, and Mac We’ll install it on a Mac

Slide 24

Slide 24 text

© JAMF Software, LLC Configure Jaspersoft Suite

Slide 25

Slide 25 text

© JAMF Software, LLC Configure Jaspersoft Suite Add a connection to the JasperReports server

Slide 26

Slide 26 text

© JAMF Software, LLC Configure Jaspersoft Suite Be sure to leave the Organization field blank

Slide 27

Slide 27 text

© JAMF Software, LLC Configure Jaspersoft Suite Add a connection to the jamfsoftware database

Slide 28

Slide 28 text

© JAMF Software, LLC Configure Jaspersoft Suite Select the type of connection we need

Slide 29

Slide 29 text

© JAMF Software, LLC Configure Jaspersoft Suite Configure the connection similar to what we did on the JasperReports server, Data Source

Slide 30

Slide 30 text

© JAMF Software, LLC Create a Report

Slide 31

Slide 31 text

© JAMF Software, LLC Create a Report

Slide 32

Slide 32 text

© JAMF Software, LLC Create a Report

Slide 33

Slide 33 text

© JAMF Software, LLC Create a Report

Slide 34

Slide 34 text

© JAMF Software, LLC Create a Report MySQL query goes here.

Slide 35

Slide 35 text

© JAMF Software, LLC Create a Report The MySQL query

Slide 36

Slide 36 text

© JAMF Software, LLC Create a Report

Slide 37

Slide 37 text

© JAMF Software, LLC Create a Report

Slide 38

Slide 38 text

© JAMF Software, LLC Create a Report

Slide 39

Slide 39 text

© JAMF Software, LLC Create a Report

Slide 40

Slide 40 text

© JAMF Software, LLC Create a Report

Slide 41

Slide 41 text

© JAMF Software, LLC Create a Report

Slide 42

Slide 42 text

© JAMF Software, LLC Create a Report

Slide 43

Slide 43 text

© JAMF Software, LLC Create a Report

Slide 44

Slide 44 text

© JAMF Software, LLC Create a Report 1 2 Set Dataset to [Main Dataset] Click the ellipsis next to Value

Slide 45

Slide 45 text

© JAMF Software, LLC Create a Report Delete the existing text Click Fields, then double-click Count Field Long

Slide 46

Slide 46 text

© JAMF Software, LLC Create a Report Click the ellipsis next to Label Set the value to OS Version

Slide 47

Slide 47 text

© JAMF Software, LLC Create a Report Click Finish, then Preview the report

Slide 48

Slide 48 text

© JAMF Software, LLC Sample Report

Slide 49

Slide 49 text

© JAMF Software, LLC Publish the Report Make the report available on the JasperReports server, click publish

Slide 50

Slide 50 text

© JAMF Software, LLC Publish the Report Select a location, like Reports, to store the report

Slide 51

Slide 51 text

© JAMF Software, LLC Publish the Report Select a Data Source 1 2

Slide 52

Slide 52 text

© JAMF Software, LLC Publish the Report Use jamfsoftware as the Resource

Slide 53

Slide 53 text

© JAMF Software, LLC Publish the Report Review the settings and click Finish

Slide 54

Slide 54 text

© JAMF Software, LLC Publish the Report Once the report is saved click OK, then view the report on the JasperReports server

Slide 55

Slide 55 text

© JAMF Software, LLC View the Report Click our report to view it

Slide 56

Slide 56 text

© JAMF Software, LLC View the Report The report can be exported in several formats Enable SMTP so the reports can be distributed

Slide 57

Slide 57 text

© JAMF Software, LLC Enable SMTP in JasperReports sudo vi /opt/jasperreports-server-cp-7.1.0/ apache-tomcat/webapps/jasperserver/WEB- INF/js.quartz.properties

Slide 58

Slide 58 text

© JAMF Software, LLC Enable SMTP in JasperReports Locate and edit the following block: report.scheduler.mail.sender.host=mail.example.com report.scheduler.mail.sender.username=admin report.scheduler.mail.sender.password=password [email protected] report.scheduler.mail.sender.protocol=smtp report.scheduler.mail.sender.port=25

Slide 59

Slide 59 text

© JAMF Software, LLC Enable SMTP in JasperReports report.scheduler.mail.sender.host=mail.lab.private report.scheduler.mail.sender.username=(may not be needed) report.scheduler.mail.sender.password=(may not be needed) [email protected] report.scheduler.mail.sender.protocol=smtp report.scheduler.mail.sender.port=25

Slide 60

Slide 60 text

© JAMF Software, LLC Enable SMTP in JasperReports Restart the JasperReports webapp: sudo /opt/jasperreports-server-cp-7.1.0/ctlscript.sh restart

Slide 61

Slide 61 text

© JAMF Software, LLC Schedule the Report Right-click the report and select Schedule…

Slide 62

Slide 62 text

© JAMF Software, LLC Schedule the Report Create Schedule

Slide 63

Slide 63 text

© JAMF Software, LLC Schedule the Report Set the schedule options: • Start date/time • Recurrence • When to end

Slide 64

Slide 64 text

© JAMF Software, LLC Schedule the Report Set the output options We’ll be emailing the report, no need to store it locally

Slide 65

Slide 65 text

© JAMF Software, LLC Schedule the Report Configure the notification options

Slide 66

Slide 66 text

© JAMF Software, LLC Emailed Report

Slide 67

Slide 67 text

© JAMF Software, LLC Jamf Marketplace

Slide 68

Slide 68 text

© JAMF Software, LL THANK YOU!