Skip to content

Instantly share code, notes, and snippets.

Created October 14, 2013 16:25
Show Gist options
  • Save anonymous/6978291 to your computer and use it in GitHub Desktop.
Save anonymous/6978291 to your computer and use it in GitHub Desktop.
Sessions:
Load
...
upper([Authenticated user]) AS [Authenticated user],
...
FROM $(LogPath)\SESSIONS*.LOG (utf8, txt, delimiter is '\t', embedded labels);
LEFT JOIN (Sessions)
LOAD
'AUSTRIA\' & upper(NT_USER) AS [Authenticated user],
// Vorname & '|' & Nachname as Full_Name
trim(upper(Vorname)) & ' | ' & trim(upper(Nachname)) as Full_Name
FROM
QVD\VWL_User.qvd
(qvd);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment