View source for Aperture Script Memos

<h2>Creating users with CSV file on Windows Server 2019 AD</h2>
*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
<div class="toccolours mw-collapsible mw-collapsed">
'''Run with PowerShell:'''
<div class="mw-collapsible-content">
<blockquote><code># Import Active Directory module and import CSV File to list<br>Import-Module Active Directory<br>$import_users = Import-Csv -Path .\Users.csv -Header "FirstName","LastName","Password" -Delimiter ";"<br># Start a loop and send each line of the CSV file to create a user<br>
$import_users | ForEach-Object{<br>
New-ADUser `<br>
&nbsp;&nbsp;&nbsp;&nbsp;-Name $($_.FirstName + " " + $_.Lastname) `<br>
&nbsp;&nbsp;&nbsp;&nbsp;-GivenName $_.FirstName `<br>
&nbsp;&nbsp;&nbsp;&nbsp;-SurName $_.LastName `<br>
&nbsp;&nbsp;&nbsp;&nbsp;-DisplayName $($_.FirstName + " " + $_.Lastname) `<br>
&nbsp;&nbsp;&nbsp;&nbsp;-SamAccountName $($_.FirstName.Substring(0,3).ToLower() + $_$.LastName.Substring(0,3).ToLower()) `<br>
&nbsp;&nbsp;&nbsp;&nbsp;-UserPrincipalName $($_.FirstName.ToLower() + "." + $_.LastName.ToLower() + "@example.com") `<br>
&nbsp;&nbsp;&nbsp;&nbsp;-AccountPassword $(ConvertTo-SecureString $_.Password -AsPlainText -Force)`<br>
&nbsp;&nbsp;&nbsp;&nbsp;-Path "OU=ExampleUsers,DC=example,DC=com" `<br>
&nbsp;&nbsp;&nbsp;&nbsp;-Enabled $True `<br>
}
</code></blockquote></div>
</div>
<h2>Blocking open resolver and enabeling WSUS Service on Windows Server 2019 AD</h2>
*Disable recursive queries 
*Use the following script
<div class="toccolours mw-collapsible mw-collapsed">
'''Run with PowerShell:'''
<div class="mw-collapsible-content">
<blockquote><code># Script for allowing internal hosts to send recursive queries to a public DNS server<br># Adding internal network IP addresses to the client subnet<br># Creating a scope to enable recursion and where to send queries<br># Creating policy for recursion matching client subnet and recursion scope<br>Add-DnsServerClientSubnet -Name InternalNetworkIP -IPv4Subnet 1.2.3.4 /n
-IPv6Subnet aaa:bbbb:ccc::/64<br>Add-DnsServerRecursionScope -Name InternalRecursionScope -EnableRecursion $true
-Forwarder 8.8.8.8, 2001:4860:4860::8888<br>Add-DnsServerQueryResolutionPolicy -Name InternalQueryPolicy -Action ALLOW -ApplyOnRecursion -ClientSubnet "EQ,InternalNetworkIP" -RecursionScope InternalRecursionScope<br># Confirm configuration by showing DNS recursion policy, DNS recursion scope, and our query policy.<br>Get-DnsServerClientSubnet<br>Get-DnsServerRecursion<br>Get-DnsServerRecursionScope<br>Get-DnsServerQueryResolutionPolicy
</code></blockquote></div>
</div>
<h2>Creating a CSV file with names</h2>
*Copy names from Canvas from People > Group > Group start page > Group People into TXT file with ISO 8859-4 encoding.
*Run the following script.
<div class="toccolours mw-collapsible mw-collapsed">
'''Run with Python 3.6 and higher:'''
<div class="mw-collapsible-content">
<blockquote><code># Python 3.8 Test script to extract student groups to CSV file to be opened with Excel. <br># Make sure Encoding is set to ISO 8859-4 for both this script and TXT file.
<br>import sys
<br>from itertools import islice<br><br>
FILENAME = "Group1Names.txt"<br>
FILENAME2 = "Group2Names.txt"<br>
GROUPFILENAME = "Studentgroups.csv"<br>
def CSVFile(Group, FILENAME, GROUPFILENAME):<br>
&nbsp;&nbsp;&nbsp;&nbsp;Students = ""<br>
&nbsp;&nbsp;&nbsp;&nbsp;with open(FILENAME, 'rt') as f:<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;for line in islice(f,0,None, 4):<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Students += ';'+line<br>
&nbsp;&nbsp;&nbsp;&nbsp;with open(GROUPFILENAME, 'a') as f:<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;f.write(Group + Students)<br><br>
CSVFile('Grupp 1;\n',FILENAME,GROUPFILENAME)<br>
CSVFile('Grupp 2;\n',FILENAME2,GROUPFILENAME)
</code></blockquote></div>
</div>
<h2>Creating a short status list script from systemctl status on CentOS 8</h2>
<div class="toccolours mw-collapsible mw-collapsed">
'''Run with Python 3.6 and higher on CentOS 8:'''
<div class="mw-collapsible-content">
<blockquote>
<code>
<nowiki> #!/bin/python3</nowiki><br><br>

<nowiki># Import needed modules</nowiki><br>
<nowiki>import os</nowiki><br>
<nowiki>import subprocess</nowiki><br><br>

<nowiki># Get terminalsize</nowiki><br>
<nowiki>TERMINALSIZE = os.get_terminal_size()</nowiki><br>
<nowiki>COLUMNLENGHT = TERMINALSIZE.columns</nowiki><br><br>

<nowiki>def StatusFilter(SERVICE):</nowiki><br>
&nbsp;&nbsp;&nbsp;&nbsp;<nowiki># Function that sends the systemctl status command to shell.</nowiki><br>
&nbsp;&nbsp;&nbsp;&nbsp;<nowiki># Saves output as a string and divides the string into lines.</nowiki><br>
&nbsp;&nbsp;&nbsp;&nbsp;<nowiki># Extracts the "Active:" line from lines and returnes it.</nowiki><br>
&nbsp;&nbsp;&nbsp;&nbsp;<nowiki>CMD = 'systemctl status ' + SERVICE</nowiki><br>
&nbsp;&nbsp;&nbsp;&nbsp;<nowiki>output = subprocess.check_output([CMD], shell=True, universal_newlines=True)</nowiki><br>
&nbsp;&nbsp;&nbsp;&nbsp;<nowiki>OUT = output.splitlines()</nowiki><br>
&nbsp;&nbsp;&nbsp;&nbsp;<nowiki>for line in OUT:</nowiki><br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<nowiki>if 'Active:' in line:</nowiki><br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<nowiki>return line</nowiki><br><br>

<nowiki>def ServiceStatus(LIST):</nowiki><br>
&nbsp;&nbsp;&nbsp;&nbsp;<nowiki># Loop the a list of services and prints them neatly.</nowiki><br>
&nbsp;&nbsp;&nbsp;&nbsp;<nowiki>for elem in LIST:</nowiki><br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<nowiki>S = elem + ': '</nowiki><br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<nowiki>print(S.rjust(15), StatusFilter(elem.lower()))</nowiki><br><br>

<nowiki># Stores a list of services to check status of.</nowiki><br>
<nowiki>LIST = ['SSHD','NFtables']</nowiki><br><br>
<nowiki># Spacing and other strings to print</nowiki><br>
<nowiki>SPACING = '\n' + '='*COLUMNLENGHT +'\n'</nowiki><br>
<nowiki>SPACING2 = '\n' + '-'*COLUMNLENGHT + '\n'</nowiki><br>
<nowiki>HEADING = 'Status of installed/configured services:'</nowiki><br><br>
<nowiki># Calles function to loop through desired services to print status.</nowiki><br>
<nowiki>print(SPACING)</nowiki><br>
<nowiki>print(HEADING.center(int(COLUMNLENGHT - 20)))</nowiki><br>
<nowiki>print(SPACING2)</nowiki><br>
<nowiki>ServiceStatus(LIST)</nowiki><br>
<nowiki>print(SPACING)</nowiki><br>
</code> 
</blockquote></div>
</div>