Windows 10: Routing and Remote Access Automated CSV

Hi all,

I was wondering if I could get some help on this script that I have been working on.

It's a small script and it works perfectly fine but the only issue I am having is getting the script to run by itself at a certain time.

The server that this will be running on will be a Windows Server 2012 R2. I have tried to add this script to the task scheduler and nothing has worked.

This happens even though I have told the Task Scheduler to run as an administrator.

The script I created is just a small script so HR can know who's really working from home and who's not, its basically an attendance sheet if you think of it.


Start-Process powershell -ArgumentList '-nonprofile -file C:\Users\lesliej\Desktop\VPN\working script.ps1' -verb RunAs
$startDate = Get-Date -Date "04/06/2020"
$endDate = Get-Date -Date "12/06/2020"
$Day = Get-Date -format "08:00:00"
$endDate = Get-Date -format "17:30:00"
$Path = "C:\Users\lesliej\Desktop\VPN\filelist.csv"
Get-RemoteAccessConnectionStatistics -StartDateTime $Day|Export-Csv "\\KL-FS01\Data\Home\LeslieJ\VPN List of users\June\VPN User List - $((Get-Date).ToString('dd-MM-yyyy - HH-mm-ss')).csv" -NoTypeInformation

Any help would be appreciated as this is getting really annoying having to do this manually.

:)

 

Cannot Start the Routing and Remote Access Service

I get the error below and the event below logged when I try to start the RRAS service. Any ideas?

 

Route to the remote station with win route table

Hello,

I have three pc's:
- Local PC with an ip 192.168.1.100
- Remote PC_1 with an ip 192.168.2.100
- Remote PC_2 with an ip 192.168.2.101
I would like to access remote pc_2 via remote pc_1. On the local pc and remote pc_1 i have enabled routing in the registry. Windows ip configuration shows as follow:
Windows IP Configuration

Host Name . . . . . . . . . . . . : (PC name)
Primary Dns Suffix . . . . . . . :
Node Type . . . . . . . . . . . . : Hybrid
IP Routing Enabled. . . . . . . . : Yes
WINS Proxy Enabled. . . . . . . . : No
I have installed teamviewer on local pc and remote pc_1 and a vpn adapters of the teamviewer and established vpn connection betwean local pc and remote pc_1.
On the local pc i have added a route to the route table:
route add 192.168.2.0 MASK 255.255.255.0 (ip of the teamviewer vpn of the remote pc)
Route was added successfully, i have route in the route table:
Active Routes:
Network Destination Netmask Gateway Interface Metric
192.168.6.0 255.255.255.0 (remote vpn ip) (local vpn ip) 56
Now from the local pc i can ping to the address 192.168.2.100:
C:\Windows\system32>ping 192.168.6.253

Pinging 192.168.2.100 with 32 bytes of data:
Reply from 192.168.2.100: bytes=32 time=238ms TTL=128
Reply from 192.168.2.100: bytes=32 time=107ms TTL=128
Reply from 192.168.2.100: bytes=32 time=123ms TTL=128
Reply from 192.168.2.100: bytes=32 time=108ms TTL=128

Ping statistics for 192.168.2.100:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 107ms, Maximum = 238ms, Average = 144ms
I can also ping succesfully from the remote pc_1 to the remote pc_2, but when i try to ping from local pc to remote pc_2 - all packets are lost. Any help is highly appreaciated.
Local pc is Windows 10 pro 1909 OS ver 19363.628. Firewalls, antivirus were temporary disabled while i did tests.

 

My VPN server has stopped working - Route and Remote Access error

Anyone who knows how to start the Route and Remote Access service..?