ScreenConnect download file from script

JaredBusch

This all assumes that you have the access client installed with the default permissions (aka admin rights) on the computers.

Mike Davis

Thanks @JaredBusch That worked great for Windows 10. I had to use some other powershell commands for the Windows 7 computers.

#!ps
#timeout=60000
$url = "http://mywebsite.com/sonicwall.cer" 
$path = "C:\temp\sonicwall.cer" 
# param([string]$url, [string]$path) 
if(!(Split-Path -parent $path) -or !(Test-Path -pathType Container (Split-Path -parent $path))) { 
$targetFile = Join-Path $pwd (Split-Path -leaf $path) 
} 
(New-Object Net.WebClient).DownloadFile($url, $path) 
$path

$url = "http://mywebsite.com/NetExtender.8.6.260.msi" 
$path = "C:\temp\NetExtender.8.6.260.msi" 
# param([string]$url, [string]$path) 
if(!(Split-Path -parent $path) -or !(Test-Path -pathType Container (Split-Path -parent $path))) { 
$targetFile = Join-Path $pwd (Split-Path -leaf $path) 
} 
(New-Object Net.WebClient).DownloadFile($url, $path) 
$path

certutil -addstore TrustedPublisher c:\temp\sonicwall.cer
Msiexec /i C:\temp\NetExtender.8.6.260.msi /q /qn /lv!*x c:\temp\netextender.log ALLUSERS=2

dbeato

@mike-davis said in ScreenConnect download file from script:

Thanks @JaredBusch That worked great for Windows 10. I had to use some other powershell commands for the Windows 7 computers.

#!ps
#timeout=60000
$url = "http://mywebsite.com/sonicwall.cer" 
$path = "C:\temp\sonicwall.cer" 
# param([string]$url, [string]$path) 
if(!(Split-Path -parent $path) -or !(Test-Path -pathType Container (Split-Path -parent $path))) { 
$targetFile = Join-Path $pwd (Split-Path -leaf $path) 
} 
(New-Object Net.WebClient).DownloadFile($url, $path) 
$path

$url = "http://mywebsite.com/NetExtender.8.6.260.msi" 
$path = "C:\temp\NetExtender.8.6.260.msi" 
# param([string]$url, [string]$path) 
if(!(Split-Path -parent $path) -or !(Test-Path -pathType Container (Split-Path -parent $path))) { 
$targetFile = Join-Path $pwd (Split-Path -leaf $path) 
} 
(New-Object Net.WebClient).DownloadFile($url, $path) 
$path

certutil -addstore TrustedPublisher c:\temp\sonicwall.cer
Msiexec /i C:\temp\NetExtender.8.6.260.msi /q /qn /lv!*x c:\temp\netextender.log ALLUSERS=2

Interesting, you are trying to install the SSl VPn clienr for Sonicwall on Windows 10, I have had mixed results with it on Windows 10, some on the Mobile Connect app or the application installer.

Mike Davis

@dbeato What issues have you had? I have a new SonicWall going in and would like to avoid those issues if possible. It's one of those install it over night and it needs to work in the morning cut overs. Cut is scheduled for Thursday. We tested it last week with a Windows 10 and Windows 7 client.

Dashrender

@mike-davis said in ScreenConnect download file from script:

@dbeato What issues have you had? I have a new SonicWall going in and would like to avoid those issues if possible. It's one of those install it over night and it needs to work in the morning cut overs. Cut is scheduled for Thursday. We tested it last week with a Windows 10 and Windows 7 client.

Why are you deploying SonicWalls? what feature does it have that ER's don't that you need?

Mike Davis

@dashrender said in ScreenConnect download file from script:

Why are you deploying SonicWalls? what feature does it have that ER's don't that you need?

Grant money paid for it
must have content filtering

dbeato

@mike-davis said in ScreenConnect download file from script:

@dbeato What issues have you had? I have a new SonicWall going in and would like to avoid those issues if possible. It's one of those install it over night and it needs to work in the morning cut overs. Cut is scheduled for Thursday. We tested it last week with a Windows 10 and Windows 7 client.

It is mostly with Windows 10 where the client installs fine but when it comes to connect to the Sonicwall SSL VPN it does not work properly with it stating various error on connecting. Which then leads me to setup the Mobile Connect application.

travisdh1

@mike-davis said in ScreenConnect download file from script:

@dashrender said in ScreenConnect download file from script:

Why are you deploying SonicWalls? what feature does it have that ER's don't that you need?

Grant money paid for it

must have content filtering

Why does the content filtering have to happen at the gateway? DNS filtering is even easier, imo.

Dashrender

@travisdh1 said in ScreenConnect download file from script:

@mike-davis said in ScreenConnect download file from script:

@dashrender said in ScreenConnect download file from script:

Why are you deploying SonicWalls? what feature does it have that ER's don't that you need?

Grant money paid for it

must have content filtering

Why does the content filtering have to happen at the gateway? DNS filtering is even easier, imo.

I was wondering what grant money had to do with it - unless the grant specifically said it had to be SonicWall? or no other filtering solution was less?

wirestyle22

@travisdh1 said in ScreenConnect download file from script:

@mike-davis said in ScreenConnect download file from script:

@dashrender said in ScreenConnect download file from script:

Why are you deploying SonicWalls? what feature does it have that ER's don't that you need?

Grant money paid for it

must have content filtering

Why does the content filtering have to happen at the gateway? DNS filtering is even easier, imo.

Yeah it seems weird to need it on the firewall itself

wirestyle22

@dashrender said in ScreenConnect download file from script:

@travisdh1 said in ScreenConnect download file from script:

@mike-davis said in ScreenConnect download file from script:

@dashrender said in ScreenConnect download file from script:

Why are you deploying SonicWalls? what feature does it have that ER's don't that you need?

Grant money paid for it

must have content filtering

Why does the content filtering have to happen at the gateway? DNS filtering is even easier, imo.

I was wondering what grant money had to do with it - unless the grant specifically said it had to be SonicWall? or no other filtering solution was less?

¯\(ツ)/¯

Mike Davis

@dashrender said in ScreenConnect download file from script:

I was wondering what grant money had to do with it - unless the grant specifically said it had to be SonicWall? or no other filtering solution was less?

Yes, the grant specifically specified a SonicWall. I can't use the money and put in an Edge Router with OpenDNS. They actually have auditors come out and see that the equipment is installed. It's so frustrating on so many levels as a tax payer...

Dashrender

@mike-davis said in ScreenConnect download file from script:

@dashrender said in ScreenConnect download file from script:

I was wondering what grant money had to do with it - unless the grant specifically said it had to be SonicWall? or no other filtering solution was less?

Yes, the grant specifically specified a SonicWall. I can't use the money and put in an Edge Router with OpenDNS. They actually have auditors come out and see that the equipment is installed. It's so frustrating on so many levels as a tax payer...

So who submitted (based on what recommendation) for a sonicwall when the grant was requested?

wirestyle22

@mike-davis said in ScreenConnect download file from script:

@dashrender said in ScreenConnect download file from script:

I was wondering what grant money had to do with it - unless the grant specifically said it had to be SonicWall? or no other filtering solution was less?

Yes, the grant specifically specified a SonicWall. I can't use the money and put in an Edge Router with OpenDNS. They actually have auditors come out and see that the equipment is installed. It's so frustrating on so many levels as a tax payer...

That is gross. What do they have a state contract with Dell?

Dashrender

@wirestyle22 said in ScreenConnect download file from script:

@mike-davis said in ScreenConnect download file from script:

@dashrender said in ScreenConnect download file from script:

I was wondering what grant money had to do with it - unless the grant specifically said it had to be SonicWall? or no other filtering solution was less?

Yes, the grant specifically specified a SonicWall. I can't use the money and put in an Edge Router with OpenDNS. They actually have auditors come out and see that the equipment is installed. It's so frustrating on so many levels as a tax payer...

That is gross. What do they have a state contract with Dell?

Dell Sold SonicWall.

wirestyle22

@dashrender said in ScreenConnect download file from script:

@wirestyle22 said in ScreenConnect download file from script:

@mike-davis said in ScreenConnect download file from script:

@dashrender said in ScreenConnect download file from script:

I was wondering what grant money had to do with it - unless the grant specifically said it had to be SonicWall? or no other filtering solution was less?

Yes, the grant specifically specified a SonicWall. I can't use the money and put in an Edge Router with OpenDNS. They actually have auditors come out and see that the equipment is installed. It's so frustrating on so many levels as a tax payer...

That is gross. What do they have a state contract with Dell?

Dell Sold SonicWall.

Didn't know that. Haven't used a Sonicwall in years. Who did they sell to?

Ah, independent.

dbeato

@wirestyle22 said in ScreenConnect download file from script:

@dashrender said in ScreenConnect download file from script:

@wirestyle22 said in ScreenConnect download file from script:

@mike-davis said in ScreenConnect download file from script:

@dashrender said in ScreenConnect download file from script:

I was wondering what grant money had to do with it - unless the grant specifically said it had to be SonicWall? or no other filtering solution was less?

Yes, the grant specifically specified a SonicWall. I can't use the money and put in an Edge Router with OpenDNS. They actually have auditors come out and see that the equipment is installed. It's so frustrating on so many levels as a tax payer...

That is gross. What do they have a state contract with Dell?

Dell Sold SonicWall.

Didn't know that. Haven't used a Sonicwall in years. Who did they sell to?

Ah, independent.

Francisco Partners and Elliot Management.

dbeato

More here,
https://www.businesswire.com/news/home/20160620005663/en/Francisco-Partners-Elliott-Management-Acquire-Dell-Software

Still Dell Contacts you for selling you the Sonicwall

Mike Davis

@dashrender said in ScreenConnect download file from script:

So who submitted (based on what recommendation) for a sonicwall when the grant was requested?

The grantor came up with that. The agency only filled out a form that said how many full and part time people they had doing certain functions and the grant had a formula that said how many of each model number of different pieces of equipment you got. They even speced a printer that isn't available through normal channels. (discontinued) The printer was probably the dumbest thing because they already had a large multifunction copier on each floor. No need for the printer at all, but it didn't matter. Then they send auditors to visit the site and make sure it's plugged in.

These things baffle me, but at the end of the day you take them because if you accept the SonicWall you get all the other gear on the grant. It's frustrating to say the least because I can't standardize the agency because different grants specify different gear.

Like I said it's real frustrating watching money get wasted like that. Government agencies have no incentive to do things to save money. Politicians only pat themselves on the back for money that gets thrown at one group or another.