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

Get-AzureADServicePrincipal -All:$true | ? {$_.Tags -eq "WindowsAzureActiveDirectoryIntegratedApp"}  | Foreach-Object{

    $AppObjectId = $_ 
    $AppUser = Get-AzureADServiceAppRoleAssignment -ObjectId $AppObjectId.ObjectId #-All $true

    New-Object -TypeName PSObject -Property @{
        AppDisplayName = $AppObjectId.DisplayName
		AppDisplayName2 = $AppObjectId.AppDisplayName
		AppPublisherName = $AppObjectId.PublisherName
        AppObjectId = $AppObjectId.ObjectId

TiloGit

Use this as an example on how to start the virtual console without the need of Java Web Start or accessing it from the web interface.
You can use the user and password that you use for the web interface.

You need an old JRE... I used 1.7.0_80 from the Server JRE package, also I have tested successfully 1.7.0_79 with MacOS.
You don't need to install it, just extract it or copy the files in "jre" folder.

Open the viewer.jnlp file that you get by launching the virtual console from the web interface with a text editor.
Note the urls to the jar files. Download the main jar file avctKVM.jar and the libs for your operating system and architecture.
Extract the dlls (.so Linux, .jnilib MacOS) from the jar libs.

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

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

$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