QVSystemMonitor_v5.1.23 not work

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi Everyone,

could someone please help me?, when try to run the qvsytemMonitor I got and error message about the Field not found

Field not found - <Timestamp>

Sessions:

LOAD

Date(Timestamp) &'_'& Time(Timestamp,'hh')&'_'& Time(Timestamp, 'mm') as DateHourKey,

Capitalize(LOWER(SubField(Document,'\',-1))) as SessionDocName,

Time(Timestamp) as SessionsTime,

Timestamp as SessionsTimestamp,

AutoNumber(Timestamp&Document) as DocUseKey,

Capitalize(LOWER(SubField(Document,'\',-1))) &'_'&SubField([Authenticated user],'\',-1) as %DocUserKey,

[Exe Type] as SessionExeType,

[Exe Version] as SessionExeVersion,

if(len([Authenticated user]) = 0 ,Timestamp&'-'&[Session Start]&'-'&[Authenticated user]&'-'&Lower(Mid(Document,Index(Document,'\',-1)+1)),

Timestamp&'-'&[Session Start]&'-'&[QlikView User]&'-'&Lower(Mid(Document,Index(Document,'\',-1)+1)) ) as SessionID,

if(len([QlikView User]) = 0 ,[Authenticated user],[QlikView User]) as UserID,

Lower(Document) as DocumentPath,

Lower(Mid(Document,Index(Document,'\',-1)+1)) as DocumentName,

[Server Started] AS [Server Started Sessions],

Timestamp,

Date(Floor(Timestamp)) AS Date2,

Year(Date(Floor(Timestamp))) AS Year2,

Month(Date(Floor(Timestamp))) AS Month2,

Weekday(Date(Floor(Timestamp))) AS Weekday2,

Week(Date(Floor(Timestamp))) AS Week2,

Day(Date(Floor(Timestamp))) AS Day2,

Hour(Timestamp) AS Hour2,

Minute(Timestamp) AS Minute2,

Document,

[Document Timestamp],

[QlikView User],

[Exit Reason],

[Session Start],

[Session Start] AS SSessionStart,

[Session Duration],

Time([Session Start] + [Session Duration]) AS [Session End],

[Session Start] as SessionStart,

[Session Duration] as SessionDuration,

Date([Session Start] + [Session Duration], 'YYYY-MM-DD hh:mm:ss') as SessionEnd,

[Session Start] &'-'& ([Session Start] + [Session Duration]) As SessionRange,

[CPU spent (s)],

[Bytes Received],

[Bytes Sent],

Calls as SessionCalls,

Selections as SessionSelections,

Upper([Authenticated user]) as AuthenticatedUser,

[Identifying user],

[Client machine identification],

[Serial number],

[Client Type],

IF([Client Type] like '*MSIE*', 'Internet Explorer',

IF([Client Type] like '*gecko*', 'Firefox',

If([Client Type] like '*chrome*', 'Chrome',

If([Client Type] like 'Windows Exe', 'IE Plugin',

If([Client Type] like '*android*', 'Android',

If([Client Type] like '*safari.mobile*', 'Mobile Safari',

If([Client Type] like '*browser.safari*', 'Safari',

If([Client Type] like '*opera*', 'Opera',

If([Client Type] like '*mobile.iphone*', 'Native iPhone', 'Other')

)))))))) As [Client Type2],

If( SubField([Client Build Version], '.', -1) > 0, SubField([Client Build Version], '.', -1)) AS 'Client Build Version',

SubField([Exe Version],'.', -3) AS BuildVersion,

[Secure Protocol],

[Tunnel Protocol],

[Server Port],

[Client Address],

[Client Port],

Lower(Mid(Document,Index(Document,'\',-1)+1)) & '_' & Subfield([Authenticated user], '\', 2) as "DocUser_Key",

UPPER(Subfield([Authenticated user], '\', 2)) as LanID,

Autonumber(Subfield([Authenticated user], '\', 2)) as UserCountField,

[Cal Type],

[Cal Usage Count],

TextBetween(mid(FileName(),1,index(FileName(),'.')-1)&'_', '_', '_') as QVSClusterNodeSession

FROM C:\ProgramData\QlikTech\QlikViewServer\\Sessions_*.log

(txt, utf8, embedded labels, delimiter is '\t', msq)

Where (round(num(Date(Today()) - Date(Timestamp, 'MM/dd/YYYY'))) < '30')

Any idea why? or suggestion?

Re: QVSystemMonitor_v5.1.23 not work

Anil_Babu_Samineni — Fri, 18 Aug 2017 01:07:16 GMT

You can not use duplicate fields more than one time in you single load statement. Looks like Timestamp placed 2 times. Can you check the same

topic Re: QVSystemMonitor_v5.1.23 not work in QlikView

QVSystemMonitor_v5.1.23 not work

Re: QVSystemMonitor_v5.1.23 not work