Skip to content

Instantly share code, notes, and snippets.

View kumbasar's full-sized avatar
💭
I may be slow to respond.

Volkan K. kumbasar

💭
I may be slow to respond.
16 followers · 20 following
View GitHub Profile
@kumbasar
kumbasar / make_me_grafana_admin.sh
Created March 27, 2024 06:06
Set admin user in Grafana via sqlite3
sudo sqlite3 /data/grafana/grafana.db
update user set is_admin = 1 where login="blahblah";
.exit
sudo systemctl restart grafana-server
@kumbasar
kumbasar / delete-data-influxdb.sh
Created February 17, 2023 05:27
Delete influxdb data using timestamp
curl -vkG 'https://<influxdb_url>/query?db=<DATABASE>&epoch=ns' \
-u *****:******** \
--data-urlencode "q=SELECT * FROM jenkins_data WHERE prefix='hero'" |\
jq -r "(.results[0].series[0].values[][0])" > delete_timestamps.txt
for i in $(cat delete_timestamps.txt); do
echo $i;
curl -G 'https://<influxdb_url>/query?db=<DATABASE>=ns' \
-u ****:******** \
@kumbasar
kumbasar / docker_instance_cleaner.groovy
Created August 2, 2022 04:58
Cancel Jenkins Queues and delete offline nodes
import hudson.model.*
import jenkins.model.Jenkins
def q = Jenkins.instance.queue
q.items.findAll { it.task.name }.each { q.cancel(it.task) }
for (aSlave in hudson.model.Hudson.instance.slaves) {
if (aSlave.getComputer().isOffline() /* || aSlave.getComputer().isOnline() */) {
aSlave.getComputer().setTemporarilyOffline(true,null);
@kumbasar
kumbasar / delete_artifacts.groovy
Created September 4, 2020 07:46 — forked from perja12/delete_artifacts.groovy
Delete artifacts from Jenkins with Groovy script.
// Delete old artifacts that fills up the disk on the master node.
// Run this from the Jenkins console (Manage Jenkins, Manage Nodes, master, Script Console)
def project = Jenkins.get().getItemByFullName('your-project-id')
def jobs = project.getAllJobs()
def total_size = 0
jobs.each{ job ->
def builds = job.getBuilds()
@kumbasar
kumbasar / restartPrintSpooler.bat
Created October 22, 2019 06:53
Restart Print Spooler Windows Service
@echo off
title Restart Print Spooler
echo Stopping Spooler service
net stop Spooler
echo Starting Spooler service
net start Spooler
pause
@kumbasar
kumbasar / rmoldbranches.sh
Created October 15, 2019 08:03
Deleting Old Local Git Branches
git remote prune origin
git branch -vv | grep 'origin/.*: gone]' | awk '{print $1}' | xargs git branch -d
@kumbasar
kumbasar / getaDGroupUserList.bat
Created September 23, 2019 14:19
List all users in a AD Group
C:\Users\kumbasar>net group "test_adgroup" /domain
The request will be processed at a domain controller for domain test.net.
Group name test_adgroup
Comment test_adgroup_comment
Members
-------------------------------------------------------------------------------
kumbasar yildiz volkan
@kumbasar
kumbasar / fivesecreboot.sh
Created September 23, 2019 05:18
Reboot Linux server after 5 sec
#!/bin/bash
set -x
echo "Rebooting after 5 sec.."
( sleep 5 ; reboot ) &
exit 0
@kumbasar
kumbasar / artifactcleaner.sh
Created May 21, 2019 12:29
A bashscript to clean up old builds from Artifactory
#!/bin/bash
URL="http://localhost:8080"
repo="test-repo"
TO=`date -d "1 months ago" +%s000`
FROM=`date -d "3 months ago" +%s000`
curl -u${API_USER}:${API_PASSWORD} -o output.json "${URL}/artifactory/api/search/creation?from=${FROM}&to=${TO}&repos=${repo}"
@kumbasar
kumbasar / imagetest.sh
Created April 25, 2019 19:29
How To Create a NTFS Image File in Linux
#!/bin/bash
set -x
image="test.img"
label="test"
mntdir=`mktemp -d`
sudo dd status=progress if=/dev/zero of=$image bs=6M count=1000 && sync
echo 'type=7' | sudo sfdisk $image