Apply a deployment using report but to only some IP range's eg wired ones in office

[hgreenwood]

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

[rom]

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

 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'