Skip to content

Instantly share code, notes, and snippets.

@ludwigschuster
ludwigschuster / addingAD-UsersToSQL.ps1
Created December 7, 2017 12:34
add AD Users to MSSQL
foreach($GroupMember in $(Get-ADGroupMember 'YourAD-Group' | Get-ADUser -Properties * | Select-Object Name, DisplayName, EmailAddress)){
$time=[int64](([datetime]::UtcNow)-(get-date "1/1/1970")).TotalMilliseconds #UnixTime
$commandText =
"
begin
if exists(select login from DATABASE.dbo.users where login ='"+$GroupMember.Name+"')
begin
update DATABASE.dbo.users
set
login='"+$GroupMember.Name+"',

Powershell

Active-Directory

Powershell-Befehl Was macht das
Get-ADUser -Filter "DisplayName -like 'Schuster'" -Properties * | Select-Object Name, EmailAddress, DisplayName | ft Teile des Namens sind bekannt, wie ist der vollständige Name?
Get-ADPrincipalGroupMembership lschuster | Select-Object Name In welchen Gruppen ist der Benutzer?
Get-ADGroupMember "de-dl its netpat admins" | Select-Object Name Wer ist in dieser Gruppe?
Get-ADGroupMember "de-dl its alle" | Get-ADUser -Filter "physicalDeliveryOfficeName -like 'Schelling'" -Properties * | Select-Object DisplayName, EmailAddress | ft Wer sitzt in der SchellingStraße?
Get-ADUser lschusterad -Properties * | Select-Object LockedOut Ist Kollege X bereits gesperrt, oder hat er sich nur beim Passwort vertippt?
Get-ADUser -Filter "EmployeeID -like '5626'" -Properties * | Select-Object DisplayName, EmailAdress | ft Wer gehört zu dieser Personalnummer?
@ludwigschuster
ludwigschuster / timidity.sh
Created August 25, 2017 13:26
play Midi and convert to wav
brew install timidity
timidity *.midi
timidity input.mid -Ow -o out.wav
@ludwigschuster
ludwigschuster / moveBranch.sh
Created August 10, 2017 13:22
move Commits from one Branch to another
git branch newbranch # Create a new branch, saving the desired commits
git reset --hard HEAD~3 # Move master back by 3 commits (GONE from master)
git checkout newbranch # Go to the new branch that still has the desired commits
git reset --hard a1b2c3d4
# Existing Branch
git checkout existingbranch
git merge master
git checkout master
@ludwigschuster
ludwigschuster / zip_verschluesseln.sh
Last active May 18, 2017 13:04
Zip verschlüsseln
zip -e -r -X [Name der neuen Zip mit *.zip] [Dateiname mit Dateiendung]
@ludwigschuster
ludwigschuster / autostart.sh
Last active April 12, 2017 15:13
autostart Linux
#create name.desktop in ~.config/autostart
cd ~/.config
mkdir -p autostart
vim name.desktop
#######enter into file##############
[Desktop Entry]
Type=Application
Name=TightVNC
Exec=vncserver -geometry 1024x768 :1
StartupNotify=false
@ludwigschuster
ludwigschuster / scaleand_gif_or_video.sh
Last active April 2, 2017 05:23
Scale images and make a GIF
convert *.jpg -resize 250x250 -set filename:f '%t' '%[filename:f].jpg' && convert -delay 15 *.jpg out.gif
brew install ffmpeg && ffmpeg -framerate 10 -pattern_type glob -i '*.jpg' -c:v libx264 -pix_fmt yuv420p out.mp4
@ludwigschuster
ludwigschuster / getIPFromDNS
Created February 24, 2017 15:27
get Host IP adresses with Powershell
for($i=1;$i -le 31;$i++){if($i -le 9){Resolve-DnsName("DNS0"+$i+"domain")}else{Resolve-DnsName("DNS"+$i+"domain")}}
@ludwigschuster
ludwigschuster / vim-deleteall
Created January 18, 2017 12:29
delete all in VIM
g #jump to Top
d #start delete mode
G #jump to End