Aperture Script Memos
From Datateknik
Contents |
Creating users with CSV file on Windows Server 2019 AD
- Create the CSV file with ";" as delimiter
- Create an OU container in your Active Directory server and record the location
- Create a PowerShell script in the same location as the CSV file is located
- Use the following script
Run with PowerShell:
# Import Active Directory module and import CSV File to list
Import-Module Active Directory
$import_users = Import-Csv -Path .\Users.csv -Header "FirstName","LastName","Password" -Delimiter ";"
# Start a loop and send each line of the CSV file to create a user
$import_users | ForEach-Object{
New-ADUser `
-Name $($_.FirstName + " " + $_.Lastname) `
-GivenName $_.FirstName `
-SurName $_.LastName `
-DisplayName $($_.FirstName + " " + $_.Lastname) `
-SamAccountName $($_.FirstName.Substring(0,3).ToLower() + $_$.LastName.Substring(0,3).ToLower()) `
-UserPrincipalName $($_.FirstName.ToLower() + "." + $_.LastName.ToLower() + "@example.com") `
-AccountPassword $(ConvertTo-SecureString $_.Password -AsPlainText -Force)`
-Path "OU=ExampleUsers,DC=example,DC=com" `
-Enabled $True `
}
Blocking open resolver and enabeling WSUS Service on Windows Server 2019 AD
- Disable recursive queries
- Use the following script
Run with PowerShell:
# Script for allowing internal hosts to send recursive queries to a public DNS server
# Adding internal network IP addresses to the client subnet
# Creating a scope to enable recursion and where to send queries
# Creating policy for recursion matching client subnet and recursion scope
Add-DnsServerClientSubnet -Name InternalNetworkIP -IPv4Subnet 1.2.3.4 /n
-IPv6Subnet aaa:bbbb:ccc::/64
Add-DnsServerRecursionScope -Name InternalRecursionScope -EnableRecursion $true
-Forwarder 8.8.8.8, 2001:4860:4860::8888
Add-DnsServerQueryResolutionPolicy -Name InternalQueryPolicy -Action ALLOW -ApplyOnRecursion -ClientSubnet "EQ,InternalNetworkIP" -RecursionScope InternalRecursionScope
# Confirm configuration by showing DNS recursion policy, DNS recursion scope, and our query policy.
Get-DnsServerClientSubnet
Get-DnsServerRecursion
Get-DnsServerRecursionScope
Get-DnsServerQueryResolutionPolicy
Creating a CSV file with names
- Copy names from Canvas from People > Group > Group start page > Group People into TXT file with ISO 8859-4 encoding.
- Run the following script.
Run with Python 3.6 and higher:
# Python 3.8 Test script to extract student groups to CSV file to be opened with Excel.
# Make sure Encoding is set to ISO 8859-4 for both this script and TXT file.
import sys
from itertools import islice
FILENAME = "Group1Names.txt"
FILENAME2 = "Group2Names.txt"
GROUPFILENAME = "Studentgroups.csv"
def CSVFile(Group, FILENAME, GROUPFILENAME):
Students = ""
with open(FILENAME, 'rt') as f:
for line in islice(f,0,None, 4):
Students += ';'+line
with open(GROUPFILENAME, 'a') as f:
f.write(Group + Students)
CSVFile('Grupp 1;\n',FILENAME,GROUPFILENAME)
CSVFile('Grupp 2;\n',FILENAME2,GROUPFILENAME)
Creating a short status list script from systemctl status on CentOS 8
Run with Python 3.6 and higher on CentOS 8:
#!/bin/python3
# Import needed modules
import os
import subprocess
# Get terminalsize
TERMINALSIZE = os.get_terminal_size()
COLUMNLENGHT = TERMINALSIZE.columns
def StatusFilter(SERVICE):
# Function that sends the systemctl status command to shell.
# Saves output as a string and divides the string into lines.
# Extracts the "Active:" line from lines and returnes it.
CMD = 'systemctl status ' + SERVICE
output = subprocess.check_output([CMD], shell=True, universal_newlines=True)
OUT = output.splitlines()
for line in OUT:
if 'Active:' in line:
return line
def ServiceStatus(LIST):
# Loop the a list of services and prints them neatly.
for elem in LIST:
S = elem + ': '
print(S.rjust(15), StatusFilter(elem.lower()))
# Stores a list of services to check status of.
LIST = ['SSHD','NFtables']
# Spacing and other strings to print
SPACING = '\n' + '='*COLUMNLENGHT +'\n'
SPACING2 = '\n' + '-'*COLUMNLENGHT + '\n'
HEADING = 'Status of installed/configured services:'
# Calles function to loop through desired services to print status.
print(SPACING)
print(HEADING.center(int(COLUMNLENGHT - 20)))
print(SPACING2)
ServiceStatus(LIST)
print(SPACING)
Use Windows Scheduler to remove old files
- Create a schedule in Windows Scheduler
- Add the following script to run:
Save file as .bat
:: Text file formats
ForFiles -p "C:\Users\user\Desktop" -s -m *.txt* /C "cmd /c del @path"
ForFiles -p "C:\Users\user\Desktop" -s -m *.doc* /C "cmd /c del @path"
ForFiles -p "C:\Users\user\Desktop" -s -m *.pdf* /C "cmd /c del @path"
:: txt, doc, odt, rtf, ods, xls, pdf, ppt, odp, pkt, pka, zip.