topic Re: How to display operating system information in text box in QlikView

How to display operating system information in text box

Anonymous — Fri, 01 Dec 2017 12:37:59 GMT

Hello Guys,

I would like to change the variable value based on if the system is desktop or server.can someone help me getting os information displayed in text box.

Thanks

Hariprasath

Re: How to display operating system information in text box

avkeep01 — Fri, 01 Dec 2017 12:40:33 GMT

Hi Hari,

Try

=COMPUTERNAME()

Re: How to display operating system information in text box

Chanty4u — Fri, 01 Dec 2017 12:43:05 GMT

try

=OSUSER()

=computername()

Re: How to display operating system information in text box

Anonymous — Fri, 01 Dec 2017 13:13:44 GMT

Thank you, this will give only computer name, but i want operating system version to be fetched

Re: How to display operating system information in text box

Anonymous — Fri, 01 Dec 2017 13:14:01 GMT

Thank you, this will give only computer name and user details, but i want operating system version to be fetched

Re: How to display operating system information in text box

PrashantSangle — Fri, 01 Dec 2017 13:15:21 GMT

Hi,

there is no qlik function which return OS info.

You have to write macro for it.

Regards,

Re: How to display operating system information in text box

Chanty4u — Fri, 01 Dec 2017 13:16:35 GMT

below are the system functions you get here try respective function in text object

you want engine version?

try

=engineversion()

https://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/Scripting/SystemFunctions/system-functions.htm

Re: How to display operating system information in text box

Anonymous — Fri, 01 Dec 2017 13:22:07 GMT

Thank you, that was helpful, but unfortunately EngineVersion() doesn't work in qlikview, can you please help me the same with qlikview

Re: How to display operating system information in text box

avkeep01 — Fri, 01 Dec 2017 13:33:10 GMT

Hi Hari,

try

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/SystemFunctions/system-functions.htm

Re: How to display operating system information in text box

avkeep01 — Fri, 01 Dec 2017 13:35:06 GMT

Hi Hari,

you could make a list in Excel or Inline with the system version per computername. I don't see any other options for you with qlikview.

Re: How to display operating system information in text box

atoz1158 — Fri, 01 Dec 2017 15:23:28 GMT

Hi Hari

If it is of use to you the system function ClientPlatform() will return and empty string if it is running in a desktop client otherwise if it running on the access point then it returns a string with browser details.

Regards

Adrian

Re: How to display operating system information in text box

Anonymous — Mon, 04 Dec 2017 05:57:30 GMT

What would be the output, if it reloads from QMC?

Re: How to display operating system information in text box

Anonymous — Mon, 04 Dec 2017 06:13:24 GMT

I see there is a function called GetRegistryString(path, key),

and the windows registry path is HKLM "SOFTWARE\Microsoft\Windows NT\CurrentVersion" "CurrentVersion"

can someone help me how to use this function?

Re: How to display operating system information in text box

Anil_Babu_Samineni — Mon, 04 Dec 2017 06:18:27 GMT

Looks this Read Registry

Re: How to display operating system information in text box

Anonymous — Mon, 04 Dec 2017 07:01:41 GMT

Thanks, but i cant use macro. is there any post which tells how to use this function?

Re: How to display operating system information in text box

Anil_Babu_Samineni — Mon, 04 Dec 2017 07:04:50 GMT

When i start search, I got this which is answered. I thought to share simply

Re: How to display operating system information in text box

Anonymous — Mon, 04 Dec 2017 07:34:57 GMT

Thank you all for suggesting the ideas, that was very helpful.

Happy to say, i have just found the solutions, example below:

LET vOS = GetRegistryString('HKLM\SOFTWARE\Microsoft\Windows NT\CurrentVersion', 'ProductName');

Re: How to display operating system information in text box

Anil_Babu_Samineni — Mon, 04 Dec 2017 08:09:53 GMT

Would you mine, Can you show the image what you getting?

Re: How to display operating system information in text box

Anonymous — Mon, 04 Dec 2017 08:51:41 GMT

Sorry, i cannot share the screenshot, but i can share you the output text.

use the below expression in text box:

=GetRegistryString('HKLM\SOFTWARE\Microsoft\Windows NT\CurrentVersion', 'ProductName');

i got the below output text in textbox

Windows 7 Enterprise

Note: my operating system is Windows 7 Enterprise