Emerson Navarro emnavarro02

Insert Timestamp on Notepad++

This is a python-based plugin for inserting custom time/date on Notepad++ documents.

Install the "Python Script" plugin. If you use the Notepad++ Plugin Manager, check where the PythonScript folder has been created (e.g., under %AppData% or %ProgramFiles%) If you prefer, install the PythonScript plugin manually. To do so, you can download the PythonScript plugin from http://npppythonscript.sourceforge.net/download.shtml.

Save the script to the PythonScript\Scripts folder. In my case it was:

"%ProgramFiles%\Notepad++\plugins\PythonScript\scripts\timestamp.py"

The performance of large Windows Server Update Services (WSUS) deployments will degrade over time if the WSUS database is not maintained properly. The WSUSDBMaintenance script is a T-SQL script that can be run by SQL Server administrators to re-index and defragment WSUS databases. It should not be used on WSUS 2.0 databases.This script contributed by the Microsoft WSUS team.

If you are using Windows Internal Database, you will need to use the sqlcmd utility, which can be downloaded from docs.microsoft.com page for SQLCMD. This page will also contain additional information about the sqlcmd utility.

To use this script with Windows Internal Database, you should run the following command:

sqlcmd -S np:\\.\pipe\MICROSOFT##WID\tsql\query -i <script-location>\WSUSDBMaintenance.sql

	<#
	.SYNOPSIS
	Retrieves a list of VNet peerings and exports it as CSV.
	.DESCRIPTION
	Retrieves a list of VNet peerings and exports it as CSV.
	Make sure you are logged in the right Azure Tenant/Subscription before running this script.
	.PARAMETER ResourceGroupName
	The name of the Resource Group
	Example: "my-azure-resource-group"
	.PARAMETER VNetName

	<?xml version="1.0" encoding="UTF-8"?>
	<zabbix_export>
	<version>5.0</version>
	<date>2021-04-12T08:47:25Z</date>
	<groups>
	<group>
	<name>MyTemplates</name>
	</group>
	</groups>
	<templates>

	// https://stackoverflow.com/questions/43216543/mailing-google-sheet-as-csv
	// https://gist.github.com/mrkrndvs/a2c8ff518b16e9188338cb809e06ccf1

	function mailRequestCSV() {

	// Send the CSV of the spreadsheet to this email address
	var recipients = "[email protected]; [email protected]"
	var bcc = "[email protected]"
	var sender = "[email protected]"
	var ss = SpreadsheetApp.getActiveSpreadsheet();

	#---
	# http://fkazi.blogspot.com/2013/04/creating-custom-active-directory_27.html
	$Prefix="1.2.840.113556.1.8000.2554"
	$GUID=[System.Guid]::NewGuid().ToString()
	$Parts=@()
	$Parts+=[UInt64]::Parse($guid.SubString(0,4),"AllowHexSpecifier")
	$Parts+=[UInt64]::Parse($guid.SubString(4,4),"AllowHexSpecifier")
	$Parts+=[UInt64]::Parse($guid.SubString(9,4),"AllowHexSpecifier")
	$Parts+=[UInt64]::Parse($guid.SubString(14,4),"AllowHexSpecifier")
	$Parts+=[UInt64]::Parse($guid.SubString(19,4),"AllowHexSpecifier")

	# https://docs.aws.amazon.com/systems-manager/latest/userguide/sysman-install-win.html
	# Requires Administrator Privileges

	Invoke-WebRequest `
	https://s3.amazonaws.com/ec2-downloads-windows/SSMAgent/latest/windows_amd64/AmazonSSMAgentSetup.exe `
	-OutFile $env:USERPROFILE\Desktop\SSMAgent_latest.exe

	Start-Process `
	-FilePath $env:USERPROFILE\Desktop\SSMAgent_latest.exe `
	-ArgumentList "/S"

	Param(
	[Parameter(Mandatory=$true)]
	[string] $FileName
	)

	$x= "Path"
	$path = (Get-Item env:$x).Value

	$path = $path.Split(";")

	#######################################################################################################################
	# Get Top process CPU Consumers
	# Author: Emerson Navarro
	# Version: 0.1
	#######################################################################################################################
	# CHANGE LOG:
	# - 04/02/2019:
	# - Initial PID Collumn
	#######################################################################################################################