heinrichvk

#!/bin/bash
 
#2015-06-24T00:00:00Z = 1435093200000 ms
#2015-06-25T00:00:00Z = 1435179600000 ms

echo "temperature, humidity, precipitation, timestamp, host" >> splunk_no_tags
 
for (( i = 1435093200000; i < 1435179600000; i+=10000 )); do

        for ((q = 1; q < 101; q++)); do

heinrichvk

KHD_CSV_OUTPUT_ACTIVATE=Y
KHD_CSV_OUTPUT=/tmp/itm/csv
KHD_CSV_OUTPUT_TAGGED_ONLY=Y
KHD_CSV_ISO_DATE_FORMAT=Y
KHD_CSV_MAXSIZE=400
KHD_CSV_EVAL_INTERVAL=60

heinrichvk

<PRIVATECONFIGURATION>
        <HISTORY Interval="1" Export="1" RETAIN="1" USE="A" Table="KLZ_CPU"></HISTORY>
        <HISTORY Interval="1" Export="1" RETAIN="1" USE="A" Table="KLZ_CPU_Averages"></HISTORY>
        <HISTORY Interval="1" Export="1" RETAIN="1" USE="A" Table="KLZ_Disk"></HISTORY>
        <HISTORY Interval="1" Export="1" RETAIN="1" USE="A" Table="KLZ_Disk_IO"></HISTORY>
        <HISTORY Interval="1" Export="1" RETAIN="1" USE="A" Table="KLZ_Disk_Usage_Trends"></HISTORY>
        <HISTORY Interval="1" Export="1" RETAIN="1" USE="A" Table="KLZ_IO_Ext"></HISTORY>
        <HISTORY Interval="1" Export="1" RETAIN="1" USE="A" Table="KLZ_Network"></HISTORY>
        <HISTORY Interval="1" Export="1" RETAIN="1" USE="A" Table="KLZ_NFS_Statistics"></HISTORY>
        <HISTORY Interval="1" Export="1" RETAIN="1" USE="A" Table="KLZ_LPAR"></HISTORY>

heinrichvk

create tablespace TBS1 DATAFILE AUTOEXTEND ON;

truncate table Measurements;
drop table Measurements;
truncate table Sensors;
drop table Sensors;



create table Sensors(   Id NUMBER(6) GENERATED BY DEFAULT ON NULL AS IDENTITY primary key,   Name varchar(20)) Tablespace TBS1;

heinrichvk

create tablespace TBS1 DATAFILE AUTOEXTEND ON;

truncate table Measurements;
drop table Measurements;
truncate table Sensors;
drop table Sensors;



create table Sensors(   Id NUMBER(6) GENERATED BY DEFAULT ON NULL AS IDENTITY primary key,   Name varchar(20)) Tablespace TBS1;

heinrichvk

create tablespace TBS1 DATAFILE AUTOEXTEND ON;

truncate table Measurements;
drop table Measurements;
truncate table Metrics;
truncate table Sensors;
drop table Metrics;
drop table Sensors;

heinrichvk

<#assign metrics = getMetrics("${entity}") >      
<#list metrics as metric>
<#if metric?index_of("cpu") gte 0>
  [widget]
      type = chart
      timespan = 1 hour
    [series]
        label = ${metric}
        entity = ${entity}
        metric = ${metric}

heinrichvk

<#assign metrics = getMetrics("${entity}") >      
<#list metrics as metric>
    [series]
        label = ${metric}
        entity = ${entity}
        metric = ${metric}
        statistic = avg
        period = 10 minute
</#list>

heinrichvk

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
  <dict>
    <key>Label</key>
      <string>scollector</string>
    <key>ProgramArguments</key>
      <array>
        <string>$SCOLLECTOR_BIN</string>
        <string>-conf=$SCOLLECTOR_CONF</string>

heinrichvk

         <Location "/static/">
                SetHandler None
                Require all granted
         </Location>