→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
hgreenwood
Engaged Sweeper

Dear All

I have a report which checks the version of the Cisco VPN client , I have a Deployment package to install the current release. I can create a scheduled deployment using both of the above which is great , However how do I not deploy this to machines which are connected to the vpn. Can I exclude IP ranges from the deployment ?

Many Thanks

 

 

 

1 REPLY 1
rom
Champion Sweeper III

Make an IP Location for the VPN subnet(s) and then join the table:

rom_0-1669857614840.png

 

 

 Left Outer Join tsysIPLocations On tsysIPLocations.LocationID =
      tblAssets.LocationID

 

And then put it in the WHERE clause where it is NOT EQUAL to the IP Location:

 

WHERE tsysIPLocations.IPLocation <> 'THE NAME YOU NAMED THE VPN SUBNET'