Qdabra Active Directory Web Service

Re: Query Network for Location

Patrick Halstead — Wed, 22 Jun 2011 07:46:36 GMT

You can but it requires Full Trust since system environment variables require elevated .NET permissions to read and InfoPathy is all about being a straighlaced domain-trust dude.

Re: Query Network for Location

tberch — Tue, 21 Jun 2011 12:23:20 GMT

Yes, that will work as well... I guess I was just seeing if I could read from environment variables or something.

Re: Query Network for Location

Patrick Halstead — Tue, 21 Jun 2011 00:25:43 GMT

Stupid quesiton, but why not just add a dropdown and ask the user to select the location?

Re: Query Network for Location

tberch — Mon, 20 Jun 2011 16:57:40 GMT

The form I have created, uses logic to define the location of the user, and I have gotten it to utilize active directory for the default location based on the users group information, but if the user is travelling, or doing a report from another office, it should reflect that location. The only way I can think of doing it is querying the network properties.

Re: Query Network for Location

Jim Cantwell — Mon, 20 Jun 2011 16:42:09 GMT

qRules and DBXL do not have features to access network information, but will require additional code.

Most environment access will require full-trust, some things, like UserName can be done with domain trust when using Local Intranet zone.

If you can deal with the added inconvenience of a full-trust form, code can be used to access network information. If machines have multiple connections, VPNs, wi-fi, etc., that may complicate determining exactly which route the access to your SharePoint site is taking. The System.Net.NetworkInformation namespace has many classes for accessing details of the network configuration.

Can you describe the problem you are trying to solve? There may be other alternatives, as working off network information is not likely going to be totally foolproof.

Re: Query Network for Location

tberch — Mon, 20 Jun 2011 13:59:57 GMT

Im opening the document from Sharepoint though... So, I need a way to query some environment variable that would reflect what network they are currently on ideally. Everybody would be opening the document from the same location in sharepoint, so I dont think that would work..

Re: Query Network for Location

Jimmy — Mon, 20 Jun 2011 11:15:16 GMT

You can use this formula to get the location of the XSN that's currently open:

substring-before(substring-after(/processing-instruction()[local-name() = "mso-infoPathSolution"], 'href="'), '"')

would that be enough to help you extract out the information you need?

Query Network for Location

tberch — Thu, 16 Jun 2011 17:30:10 GMT

I would like to query my network to see which subnet I am on, Im not exactly sure what I can query. How can I find out which network the user is attached to with qrules or dbxl.