topic Last used (UTC) in QlikView

Last used (UTC)

Anonymous — Tue, 20 Jan 2015 16:56:16 GMT

Hi everyone.

I´m experimenting some problems with QMC. The hour does´nt correspond with my time zone in the loggin information in QMC.

How can i change the time zone?

In the other hand, i want to know if theres any study guide for Qlikview administrator certificate.

Thanks for all.

Have a great day!

Re: Last used (UTC)

sujeetsingh — Tue, 20 Jan 2015 17:00:06 GMT

You cam use timezone() function in any of your deployed application which will tell you the time zone of the QMC

Re: Last used (UTC)

jjordaan — Tue, 20 Jan 2015 17:13:15 GMT

Hi Pablo,

About your question for study material I don't think there really is something.

Off course you can use the reference manual but I found this book very usefull

QlikView Server and Publisher | Packt

Re: Last used (UTC)

Anonymous — Tue, 20 Jan 2015 17:38:34 GMT

Well, actually the only thing i want to change is the timezone in the console. It shows me another hour in the information when a user is logged.

But thanks for all.

Re: Last used (UTC)

Anonymous — Tue, 20 Jan 2015 17:39:25 GMT

Thanks, it was very usefull!!!

Re: Last used (UTC)

jonasheisterkam — Tue, 20 Jan 2015 18:03:55 GMT

Hi, you can not change timezone in the QMC. But if you want only the information you can call the qlikview management api. In c# you can use timezone functions.

c# code:

QMSClient Client;

Client = new QMSClient("BasicHttpBinding_IQMS");

string key = Client.GetTimeLimitedServiceKey();

ServiceKeyClientMessageInspector.ServiceKey = key;

ServiceInfo MyQVS = Client.GetServices(ServiceTypes.QlikViewServer)[0];

CALConfiguration myCALs = Client.GetCALConfiguration(MyQVS.ID, CALConfigurationScope.NamedCALs);

List<AssignedNamedCAL> currentCALs = myCALs.NamedCALs.AssignedCALs.ToList();

List<string[]> AssignedNamedCALs = new List<string[]>();

AssignedNamedCALs.Add(new string[4] {

"UserName","MachineID","LastUsed","QuarantinedUntil"

});

for (int x = 0; x < currentCALs.Count; x++)

{

AssignedNamedCALs.Add(new string[4] {

currentCALs.ElementAt(x).UserName,currentCALs.ElementAt(x).MachineID,

TimeZoneInfo.ConvertTime(currentCALs.ElementAt(x).LastUsed, TimeZoneInfo.Utc, TimeZoneInfo.Local).ToString(),

TimeZoneInfo.ConvertTime(currentCALs.ElementAt(x).QuarantinedUntil, TimeZoneInfo.Utc, TimeZoneInfo.Local).ToString()

});

}