topic Re: Os group in QlikView

Os group

omid5ive — Tue, 17 May 2016 09:36:12 GMT

in qlikview we can have a osuser and qvuser.

how can i get operating system that user member of it?

i need something like osgroup()

Re: Os group

sunny_talwar — Tue, 17 May 2016 09:39:54 GMT

May be using ClientPlatform() function:

Author ‒ QlikView

Re: Os group

omid5ive — Tue, 17 May 2016 09:42:36 GMT

would you please explain it?

Re: Os group

kkkumar82 — Tue, 17 May 2016 09:45:18 GMT

May be ComputerName()

Re: Os group

sunny_talwar — Tue, 17 May 2016 09:46:54 GMT

I have never used this function before, but from the help section

When I tried this on my computer, it rendered no result, but it might be a function which can be used on AccessPoint? Don't really know, but I just thought you might want to play around with it to see if this can help you.

Re: Os group

kkkumar82 — Tue, 17 May 2016 09:47:05 GMT

Take a text box and write the following in it,

=Osuser() &chr(10) & ComputerName() &chr(10) & QVuser() and feel the difference

also add Clientplatform() to it

it may help what u want

Re: Os group

omid5ive — Tue, 17 May 2016 09:50:06 GMT

I need group name

in windows we have user and group managements and each user can be member of one or many group

i need to get group name of user that log in in qlikview access point

Re: Os group

Kushal_Chawda — Tue, 17 May 2016 09:50:28 GMT

There is no OsGroup() function , OsUser() function will be sufficient. what exactly do you want?

Re: Os group

awhitfield — Tue, 17 May 2016 09:51:08 GMT

Hi Omid,

sorry, but do you mean the Windows Security Group/s, that the user belongs to?

Andy

Re: Os group

jonathandienst — Tue, 17 May 2016 09:53:45 GMT

I think that if you add AD group names to the NTUSER column in section access, this group name will be applied to OsUser() when the user connects using the group name.

I haven't tested that though...

Re: Os group

omid5ive — Tue, 17 May 2016 09:54:26 GMT

i need the groups of computer and user management

Re: Os group

Kushal_Chawda — Tue, 17 May 2016 09:58:26 GMT

I don't think so that you can show group name but If you want to show then Manually create the excel file with all the users with their NT user name and group like below

UerName Group

User1\Domain Sales

Now write the expression in text box

=only({<UerName={"$(=OsUser())"}>}Group)

Note: UserName field value should match with OsUser() function value

Re: Os group

HirisH_V7 — Tue, 17 May 2016 10:26:42 GMT

Hi stalwar1,

i just tried it .on access point its showing like this,

-Hirish

Re: Os group

omid5ive — Sun, 29 May 2016 07:13:55 GMT

Thank you

Re: Os group

Peter_Cammaert — Sun, 29 May 2016 11:07:30 GMT

Do you need all of them? There is no such thing as "a" group name. Users usually belong to multiple default groups in addition to all groups the sysadmin made them member of.

IMHO group names don't make any sense in QlikView (QlikView has no idea of AD groups, it simply doesn't care), as a user will always be identified by a user name, never by way of a group name. Groups are only used to let additional rights trickle down from the group level to the user level.

You can always deduce group membership by querying AD and the local domain. Not the easiest of discoveries though. Before you embark on this journey, check whether you really want this by opening QMC->Users, entering a user name in the search box and analysing the data on the Groups tab.

Peter