Discussion Board for collaboration related to QlikView App Development.
I'm trying to get the operation system user name by using the funtion OsUser() in the load script.
The problem is that the user that I got is Administrator, because the reload done automaticly by the server.
How can I get the real Operation System user (Client user).
Unfortunately one cannot get the client os oser.
Best Regards, Bill
QV does not get reloaded client wise. So you can't get client user in the script. If you want client user, you can get it in the UI using the same function.
Are you saying that one can get the End User Client o/s user name [and not that of the [QV Server] returned into the dashboard qvw and then used in dashboard expressions ?
It would be great if that was the case.
try, OsUser() function in a text box and see it in the browser.
the function will return your domain and userid, not your user name.
my id is 'DKO' and username is 'Dirk Konings'
If you also read the AD tables, you could get the actual name out of there.
what is the AD tables?
Active Directory tables.
add this to connect:
CONNECT TO 'Provider=ADsDSOObject';
and something like this to retrieve the data
SQL select name, distinguishedName, sAMAccountName, mail, userAccountControl, telephoneNumber FROM 'LDAP://$(RootDse)' WHERE objectCategory='Person' and objectClass = 'user'
where RootDse is your domain grouping name as found in LDAP