Attach this query to your vpn users group/vlan/subnet, and it will strip out all the connected Local Area Connection interfaces, leaving the connected wireless interfaces, so you can yell at the users who call in complaining about poor vpn quality:
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysIPLocations.IPLocation,
tblAssets.Username,
tblAssets.Lastseen,
tblAssets.IPAddress,
tblNetworkAdapter.NetConnectionID,
tblNetworkAdapter.Name,
tblNetworkAdapter.Manufacturer,
tblNetworkAdapter.Speed,
tblNetworkAdapter.NetEnabled
From tblAssets
Left Join tsysIPLocations On tblAssets.IPNumeric >= tsysIPLocations.StartIP
And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Inner Join tblNetworkAdapter On tblAssets.AssetID = tblNetworkAdapter.AssetID
Where (tsysIPLocations.IPLocation = 'Parkway VPN Employee Users' Or
tsysIPLocations.IPLocation = 'Tarrytown VPN Employee Users') And
tblNetworkAdapter.NetConnectionID <> 'Local Area Connection' And
tblNetworkAdapter.NetConnectionID <> 'Local Area Connection 2' And
tblNetworkAdapter.NetConnectionID <> 'Local Area Connection 3' And
tblNetworkAdapter.NetConnectionID <> 'Local Area Connection 4' And
tblNetworkAdapter.NetConnectionID <> 'Local Area Connection 5' And
tblNetworkAdapter.NetConnectionID <> 'LAN-Wired' And
tblNetworkAdapter.NetEnabled = 'True'
Order By tblAssets.AssetName
