topic Returning hardware parameters to QV project in QlikView

Returning hardware parameters to QV project

peter_turner — Thu, 04 Feb 2010 18:42:39 GMT

Hello Everyone,

I'd like to find the amount of free RAM on my server, and return this to my QV project as a variable from the script.
I've had a look in the manual and did'nt see anything about hardware parameters.

Whats the best way todo this sort of thing? if at all?

Thanks,
Peter.

Returning hardware parameters to QV project

Oleg_Troyansky — Thu, 04 Feb 2010 19:23:30 GMT

Peter,

as far as I know, QlikView doesn't have a built-in function for that. You can develop a VBScript function and get the amount of ram from the system, and then call your VBScript function from the QlikView script. The following URL provides a somewhat relevant example with the VBScript syntax:

http://www.computerperformance.co.uk/vbscript/wmi_memory.htm#Example_1_-_To_Discover_how_much_RAM_there_is_on_NetworkMachine_

Returning hardware parameters to QV project

peter_turner — Fri, 05 Feb 2010 10:22:47 GMT

Hello Oleg,

Thanks for the info.
I've not used vbs from the script before, how would i pass the value from the vbs into my var?

Thanks,
Peter.