TiloGit

### run like::  python3 get_tds_cert.py mySQLserver 1433
import sys
import pprint
import struct
import socket
import ssl
from time import sleep 

# Standard "HELLO" message for TDS
prelogin_msg = bytearray([      0x12, 0x01, 0x00, 0x2f, 0x00, 0x00, 0x01, 0x00, 0x00, 0x00, 0x1a, 0x00, 0x06, 0x01, 0x00, 0x20,

TiloGit

CPU: percentage of limit

A lot of people land when trying to find out how to calculate CPU usage metric correctly in prometheus, myself included! So I'll post what I eventually ended up using as I think it's still a little difficult trying to tie together all the snippets of info here and elsewhere.

This is specific to k8s and containers that have CPU limits set.

To show CPU usage as a percentage of the limit given to the container, this is the Prometheus query we used to create nice graphs in Grafana:

sum(rate(container_cpu_usage_seconds_total{name!~".*prometheus.*", image!="", container_name!="POD"}[5m])) by (pod_name, container_name) /

TiloGit

def item_already_equipped(lingo, item):
    if item == 'streak_freeze':
        return lingo.__dict__['user_data'].__dict__['tracking_properties']['num_item_streak_freeze'] > 0
    if item == 'rupee_wager':
        return lingo.__dict__['user_data'].__dict__['tracking_properties']['has_item_rupee_wager']

def main(a, b):
    import duolingo, os

    username = os.environ['usernames']

TiloGit

$result = Get-EventLog -LogName Security -InstanceId 4625 |
   ForEach-Object {
     [PSCustomObject]@{
     Time = $_.TimeGenerated
     Machine = $_.ReplacementStrings[6]
     User = $_.ReplacementStrings[5]
     Access = $_.ReplacementStrings[10]
     SourceAddr = $_.ReplacementStrings[19]
     }
   }

TiloGit

		<RollingFile name="VFLOGMON"
		             filePattern="${sys:log.dir}/VFLOGMON/MyFlow-LogMon-%d{yyyy-MM-dd}-%i.log"
		             immediateFlush="true">
			<PatternLayout alwaysWriteExceptions="false"
			               pattern="%d %-5p [%t] %C{2} (%F:%L) - %enc{%m}{CRLF} %replace{%throwable}{[\r|\n]}{|}%n"/>
			<Policies>
				<TimeBasedTriggeringPolicy interval="1"
				                           modulate="true"/>
				<SizeBasedTriggeringPolicy size="22 MB"/>
			</Policies>

TiloGit

#PS use shell.azure.com
Connect-MicrosoftTeams -UseDeviceAuthentication
##use browser to login
##check value
Get-CsTeamsMeetingPolicy | select Identity, WhoCanRegister, MediaBitRateKb , RecordingStorageMode
##set to new value
Set-CsTeamsMeetingPolicy -Identity Global -MediaBitRateKb 50001

###output: 
PS /home/tilo> Get-CsTeamsMeetingPolicy | select Identity, WhoCanRegister, MediaBitRateKb , RecordingStorageMode

TiloGit

importClass(java.lang.System);

function OnCustomProcess (CEObject)
{
               var objStor = CEObject.getObjectStore();
               objStor.refresh();
               var myDomain = objStor.get_Domain();
               myDomain.refresh();
               var AddOnListIterator = myDomain.get_AddOns().iterator();
               var output = "";

TiloGit

#!/bin/bash

##from https://ops.tips/gists/measuring-http-response-times-curl/
##mod by allow self sign cert (-k)
# Set the `errexit` option to make sure that
# if one command fails, all the script execution
# will also fail (see `man bash` for more 
# information on the options that you can set).
set -o errexit

TiloGit

iamURL="cp-console.apps.ocp6.tsodev.com"
cpdURL="cpd-alf1.apps.ocp6.tsodev.com"
userid="cp4baadmin"
 userpw="mypass123"

##now in chain
iamToken=$(curl -b icncookie.txt -c icncookie.txt -k -s -X POST -H "Content-Type: application/x-www-form-urlencoded;charset=UTF-8" -d "grant_type=password&username=$userid&password=$userpw&scope=openid" https://$iamURL/idprovider/v1/auth/identitytoken | jq '.access_token' | xargs)

echo $iamToken

TiloGit

#################createPrinter
# choose a name for your new printer
$printerName = 'PrintPDFUnattended'
# choose a default path where the PDF is saved
$PDFFilePath = "C:\PrinterTemp\PDFResultFile.pdf"
New-Item $PDFFilePath -type file -Force
# add printerPort
Add-PrinterPort -Name $PDFFilePath 
# add printer
Add-Printer -DriverName "Microsoft Print to PDF" -Name $printerName -PortName $PDFFilePath