TechShizz | All posts by rich

Steps to Migrate PICs application by Pellcomp

Backup the data:
The most secure way to move the data is to create a PICS backup and then restore the backup once PICS is installed on the new server. To create a backup, please follow these instructions...

From the PICS logon screen, go to the Tools menu and select Backup Database (Data Only).
When the backup screen appears, click on Start.
When prompted, save the file to a network share that is accessible to both servers.
Transferring via removable media is also possible at this point.

Copy miscellaneous files:
It’s possible that staff have saved various reports and files into the PICS Software or Data folders.  In particular you should look for any files in the Software folder which start ‘ILP_’ or end with a .ahl extension.  Any such files need to be copied and moved over to the new Software folder once it’s been created. 

If you have the optional Scheduled Reporting module then you will need to make a copy of the SchedRepData sub-folder which is also in the Software folder.

In addition to these standard PICS files, staff may well have saved general reports and documents so it’s best to check with them or look out for large numbers of Office documents which may require moving.

Install PICS Software on the new server:
Download the latest copy of PICS from the following link:
http://www.pellcomp.co.uk/pics_dl.php
Create a folder on the server called 'Pellcomp' and within there a folder called 'Software'.
Install the software on the server in the new 'Software' folder.
Once installed you will be prompted for the data path. Leave it there for now and go to the ‘Move the data’ section below.

Move the data:
Create another new folder in the 'Pellcomp' folder called 'Data'.
Set the folder permissions so that all users and the System account have Full Control.
Copy the backup from the network drive to the new 'Data' folder.

Restore the data:
Go back to the PICS screen and click on the Browse button.
Navigate to the Data folder we created earlier and click Select. Please note that the address used here needs to be an address that means the same to the client computers, so either a UNC path or a common mapped network drive.
When warned that no database exists, click on Accept.
Click the Restore button and then click on the folder icon (3 dots).
Find the backup file in the DATA folder and click on Open.
Click on Restore.
Confirm the details on screen and then click Yes.
The database will now restore.

Install ADS:
Please follow the instructions in the attached document.

Re-Create the client shortcuts:
Go to the 'Software' folder you created and installed the software into earlier.
Create a shortcut to PICS.exe in this folder. This is the shortcut that the client PCs will need on their desktops.

Finally:
You can now logon, but when you try to access the data you will be asked for a licence.  Please enter:

[PLEASE EMAIL PELLCOMP FOR YOUR LICENCE INFO]

The last thing to do is update the software to make sure it is fully up to date.
To do this follow the instructions below:

  1. Make sure everyone is out of PICS.
  2. Get to the Login Screen.
  3. Go to the ‘Tools’ Menu item, then ‘Software Updates’.
  4. Enter your usual username and password, when prompted. This is actually a password permission to be able to run Software Updates so it may be needed to be added to your user in Password maintenance, by the PICS supervisor.
  5. You should get another window pop up and the PICS login screen close. In this new window click on ‘Next’.
  6. This should then check the versions available and give you a list of the parts of PICS that need updating, click ‘Next’ again.
  7. This will run through downloading the different files. After it done click on ‘Next’ again.
  8. Click ‘Next’ on the next screen, which talks about Local Network Updates.
  9. This will then go through installing the updates and will display the message ‘Updates installed, press OK to return to PICS’. Click ‘OK’.
  10. Log into PICS as normal.

Finally, a Windows 10 VPN solution that doesn't make you want to blow your brains out!

As a system administrator, I use many VPN connections throughout the day. Windows 10 is great, but whoever was in change of the VPN client in windows 10 at Microsoft did not deserve his/her bonus for this edition of windows!! It's slow, buggy, gives you no decent error. Fortunately, Mr gates left the good old rasphone intact so we can use this. 

The problem is, its still clunky loading in Windows 10. It can take 3-10 seconds to load the Rasphone each time you open it.

I've written a PowerShell script to make a tidy folder of useable shortcuts that you can add the to tool bar. Here's how it works.

1. Create a folder called "VPNs" in c:\

2. Right click the task bar > Toolbars > New Toolbar

3. Navigate to the VPNs folder and select it and click 'Select Folder'.

4. Paste this PS Script to s txt file. Save it as a .ps1 file.

Remove-Item -Path C:\VPNs\* -Recurse -Force
$vpnlist = Get-VpnConnection | Select Name -Skip 1
ForEach ($vpnname in $vpnlist.Name ){
$Shell = New-Object -ComObject ("WScript.Shell")
$ShortCut = $Shell.CreateShortcut("C:\VPNs\$vpnname.lnk")
$ShortCut.TargetPath="rasphone.exe"
$ShortCut.Arguments="-d `"$vpnname`""
$ShortCut.WorkingDirectory = "c:\windows\system32\";
$ShortCut.WindowStyle = 1;
$ShortCut.Description = "$vpnname";
$ShortCut.Save()}

5.You can check the status (See what VPNs are connected) with this script.

Get-VpnConnection | Where-Object {$_.ConnectionStatus -eq "Connected" } | Select Name,ConnectionStatus,TunnelType,ServerAddress,SplitTunneling | Format-Table
Pause
Exit

6. You can disconnect all VPNs at the same time with this script.

$vpnlist = Get-VpnConnection | Where-Object {$_.ConnectionStatus -eq "Connected" }
ForEach ($vpnname in $vpnlist.Name ){

  rasdial $vpnname /DISCONNECT;

}

Installing and working with Windows Containers in Server 2016

Installing Docker

First, Install "Containers" Feature from Windows Features.

Run PowerShell as administrator:

## Install the module, pull down from internet
Install-Module -Name DockerMsftProvider -Repository PSGallery -Force
##Say yes to install Nuget

## Install the package
Install-Package -Name Docker -ProviderName DockerMsftProvider
##Confirm install.

#Reboot

Installing the base OS

You can do this either in PowerShell or CMD (as admin)

docker pull microsoft/nanoserver
OR
docker pull microsoft/windowsservercore

Containers are created in the file system here: C:\ProgramData\Docker\Containers

Here are some basic commands:
docker images - Shows the current images available.
docker run -it mimcrosoft/nanoserver cmd - Runs a new container with a nanoserver base and runs CMD. You can see the container running in C:\ProgramData\Docker\Containers. If you type "hostname" you'll see the hostname is infact a new one, not the name of your physical host.


docker ps -a - Shows all containers currently running on the server and the container ID.

If you "exit" from the cmd, this will stop the container since no processes are running.

If the container stops, you can start it again with:
docker start <containerid>

If you wanted to get into a cmd in the container again you could do:
docker exec -it <containerid> cmd

docker commit <containerid> <name>
docker commit 11dfds1sf1 containerone

docker run --rm <name> <command> -- --rm removes the container once finished.

Setting up Encrypted email in Office 365 in 5 Steps

1. Ensure you have assigned an Azure right Management license to the user in Office 365.

2. Run the following from a an Elevate PowerShell instance.

If you have never installed Encrypted email before, you may need to install AzureRM and AADRM.

Install-Module -Name AzureRM -AllowClobber
Install-Module -Name AADRM

3. Next run this script (you will need the tenant office 365 credentials):

$session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://outlook.office365.com/powershell-liveid/ -Credential $cred -Authentication Basic -AllowRedirection
Import-PSSession $session
Set-IRMConfiguration -SimplifiedClientAccessEnabled $true
$cred = Get-Credential
Get-Command -Module aadrm
Connect-AadrmService -Credential $cred
Enable-Aadrm
$rmsConfig = Get-AadrmConfiguration
$licenseUri = $rmsConfig.LicensingIntranetDistributionPointUrl
Disconnect-AadrmService
$session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://outlook.office365.com/powershell-liveid/ -Credential $cred -Authentication Basic -AllowRedirection
Import-PSSession $session
$irmConfig = Get-IRMConfiguration
$list = $irmConfig.LicensingLocation
if (!$list) { $list = @() }
if (!$list.Contains($licenseUri)) { $list += $licenseUri }
Set-IRMConfiguration -LicensingLocation $list
Set-IRMConfiguration -AzureRMSLicensingEnabled $true -InternalLicensingEnabled $true
Set-IRMConfiguration -SimplifiedClientAccessEnabled $true
Set-IRMConfiguration -ClientAccessServerEnabled $true

4. To test it is working run:

Test-IRMConfiguration -Sender user@domain.co.uk

5. Next, in the Office 365 Exchange Admin centre, set up a mail flow rule like this: