topic Retrieve the NTuser into qlikview in QlikView

Retrieve the NTuser into qlikview

Tue, 18 Oct 2011 19:29:04 GMT

Hello,

I need to retrieve the NT user account into the qlikview file , anyone knows if is possible and what is the code for this.

Thanks and Regards,

Fernando.

Retrieve the NTuser into qlikview

Miguel_Angel_Baeyens — Tue, 18 Oct 2011 19:42:31 GMT

Hi Fernando,

I don't know what do you want exactly, but you can use the function OSUser() to get the current user account in the form DOMAIN\USERNAME

Is that what you were looking for?

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Retrieve the NTuser into qlikview

isaiah82 — Tue, 18 Oct 2011 19:43:27 GMT

Fernando ~ can you clarify what exactly is it you are trying to do? There is a function OSUser() which will return the currently logged in user, but I'm not sure that's what you're after...

-Isaiah

Retrieve the NTuser into qlikview

Tue, 18 Oct 2011 19:51:32 GMT

That’s excatly what I want, but what is exactly the code in script to retrieve this value ? I need this value in a field to use this field in a script to exclude some records from one file.

Thanks and regards

Fernando.

Retrieve the NTuser into qlikview

Tue, 18 Oct 2011 19:55:43 GMT

That’s exactly what I want, but what is exactly the code in script to retrieve this value? , I need this value in a field to use in a script to exclude some records in a SQL.

Thanks and regards

Re: Retrieve the NTuser into qlikview

Miguel_Angel_Baeyens — Tue, 18 Oct 2011 19:57:39 GMT

Fernando,

The following should work, but it will always return the user running the reload:

Table:
LOAD *,
FROM File
WHERE OSUser() = 'DOMAIN\GRANTEDUSER';

If you want some users to see only some pieces of information, I'd use instead section access, which gives you further control on the same application on what can any given user see. There are a lot of information on how to build a section access if you never did before, but this and this and this threads are a good start point. Check the Documents

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Retrieve the NTuser into qlikview

Tue, 18 Oct 2011 20:14:35 GMT

Thanks very much I will try and let you know the feedback

Re: Retrieve the NTuser into qlikview

Wed, 19 Oct 2011 08:43:29 GMT

Hello Miguel,

I try to do it and I receive a error message 'OSUser' is not a recognized built-in function name , do you have a clue what could be , is necessary to do any else in the script?

Thanks and Regards,

Fernando.

Re: Retrieve the NTuser into qlikview

Miguel_Angel_Baeyens — Wed, 19 Oct 2011 08:53:30 GMT

Hi Fernando,

Yes, I may misunderstood the question. This makes more sense to me

IF Upper(OSUser()) = 'DOMAIN\USERNAME' THEN
Table:
LOAD *
FROM Source;
ELSEIF Upper(OSUser()) = 'DOMAIN\ADMIN' THEN
Table:
LOAD *
FROM Source2;
END IF

Hope that makes more sense.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Re: Retrieve the NTuser into qlikview

Wed, 19 Oct 2011 11:22:45 GMT

Hello Miguel,

Sorry but I don't understand what do you mean by this code.

I explain better my issue, I have a file with several employees and from this file I want to select only the one is login in .

I try the first time , this code as per your suggestion as follow:

LOAD *

SQL

SELECT *
FROM "Europe_BI".dbo."D_SALES_REP" where "SALES_REP_NT_ACCOUNT" = OSUser();

and then gives me the error i told , how your last sugestion is apply to my need , sorry but I didn't understand.

Thanks very much for your help.

Fernando.

Re: Retrieve the NTuser into qlikview

Miguel_Angel_Baeyens — Wed, 19 Oct 2011 11:43:59 GMT

Hi Fernando,

You are using SELECT (that queries the database manager) and OSUser() (QlikView function, so non existent in your DBM). But you can do something like that with a variable:

LET vCurrentUser = OSUser();
Table:
LOAD *;
SQL SELECT *
FROM "Europe_BI".dbo."D_SALES_REP"
WHERE SALES_REP_NT_ACCOUNT = '$(vCurrentUser)';

Since OSUser() returns a string, I quote the variable that returns the resulting value. Depending on your DB and your driver, you may need double quoting or something similar for strings.

Hope that makes sense this time.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Re: Retrieve the NTuser into qlikview

Wed, 19 Oct 2011 12:32:19 GMT

Thanks Miguel, it seems it works at least dosen't have a error. But sorry I have another question do you know how to see the content of the variable vcurrentuser, I like to see the content to the see how the information is retrieved.

Thanks very much for all help.

Fernando.

Re: Retrieve the NTuser into qlikview

Miguel_Angel_Baeyens — Wed, 19 Oct 2011 14:12:23 GMT

Hi Fernando,

I assume you mean to see the value when the reload takes place. If so, then use the following code with the TRACE function (TRACE only writes in the progress dialog)

LET vCurrentUser = OSUser();
TRACE $(vCurrentUser);

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Retrieve the NTuser into qlikview

Thu, 22 Mar 2012 15:11:08 GMT

Hi,

Is it possible/practical to read into QlikView the ntuser.dat file, directly or from a copy, to find the users in the system so that you don't need to hard code into the script NT user names that may change over time.

As I understand it this file can't be read as it's always open, making this more of an O/S question (Windows 7 Professional in my case) than a QlikView one. I just wonder whether anyone has tried to do this, or can see a need to do so.

Regards,

Jonathan