emnavarro02

#######################################################################################################################
# Get Top process CPU Consumers
# Author: Emerson Navarro
# Version: 0.1
#######################################################################################################################
# CHANGE LOG:
# - 29/01/2020:
#       - Initial 
# - 31/01/2019: 
#       - Changing CPU information from Win32_Process to \Process(*)\%Processor Time

emnavarro02

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

emnavarro02

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

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

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

emnavarro02

#---
# 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")

emnavarro02

// 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@email.com; email@email.com" 
var bcc = "email@email.com"
var sender = "email@email.com" 
var ss  = SpreadsheetApp.getActiveSpreadsheet();

emnavarro02

# 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"

emnavarro02

<?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>

emnavarro02

Insert Timestamp on Notepad++

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

1. 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.
2. Save the script to the PythonScript\Scripts folder. In my case it was:

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

emnavarro02

<#
    .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

emnavarro02

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