Patrick Kilter m0veax

Excel Befehle die ich immer wieder brauche

Erste 3 Zeichen löschen

    =RECHTS(A1;LÄNGE(A1)-3)

Ver"und"dieren bzw concat

Um beispielsweise mal Flott einen SQL Query aus einer Excel Datei zu erzeugen ist folgendes hilfreich

Symfony Console Cheat Sheet

Serve

php bin/console server:start *:8080

Listen on all Interfaces at port 8080

Commands i need from time to time on windows boxes

Remote CMD

winrs -r:<REMOTEHOST> cmd.exe

Spawns a cmd.exe shell per remote connection which is nice, because you don't need to do a full RDP Connection

commands for analysis of IIS Logfiles

Average Taken Time for Requests DESC

logparser.exe "SELECT  cs-uri-stem, cs-uri-query, COUNT(*) AS TotalCount, MAX(time-taken) AS MaximumTime, AVG(time-taken) AS AverageTime FROM *.log GROUP BY cs-uri-stem, cs-uri-query ORDER BY AverageTime DESC" -i:w3c

HTTP Status and Time-Taken for cs-uri-stem

take an cs-uri-stem value from the report above and replace it in the following command

	<?php

	$it = new RecursiveIteratorIterator( new RecursiveDirectoryIterator('.'));
	$regx = new RegexIterator($it, '/^.*\.php$/i', // only matched text will be returned
	RecursiveRegexIterator::GET_MATCH);
	foreach ($regx as $file) {
	$file = $file[0];
	exec('php -l ' . $file); //check the syntax here
	}

	// SOURCE https://stackoverflow.com/questions/16616722/sending-all-javascript-console-output-into-a-dom-element


	var baseLogFunction = console.log;
	console.log = function(){
	baseLogFunction.apply(console, arguments);

	var args = Array.prototype.slice.call(arguments);
	for(var i=0;i<args.length;i++){
	var node = createLogNode(args[i]);

	USE [DB_NAME]
	GO
	/****** Object: StoredProcedure [dbo].[W3_APP_GEN_Doctrine] Script Date: 03.09.2019 09:18:59

	FOUND HERE: https://stackoverflow.com/a/35901836

	Updates I did:

	- Save some lines, because SQL Server Terminates at some number of lines
	- Added timestamp type

	REM Source: https://stackoverflow.com/a/4507364

	set wsc = CreateObject("WScript.Shell")
	Do
	WScript.Sleep (60*1000)
	wsc.SendKeys ("{SCROLLLOCK 2}")
	Loop

	'author Patrick Kilter
	'email [email protected]

	'OTRS Base URL
	DIM strOtrsBaseUrl
	strOtrsBaseUrl = "http://otrs.local"

	'get TN
	DIM strTn
	strTn =InputBox("Ticket Number", "OTRS FastForward")