Qlik Community

Ask a Question

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
May 18th, Changes to the way you login: using email vs. username. READ DETAILS/WATCH VIDEO
cancel
Showing results for 
Search instead for 
Did you mean: 
sleepyteatree
Partner
Partner

Find the total unique visitors per month?

Hello,

Is it possible to find the total number of unique monthly visitors in NPrinting?

Thank you

Labels (2)
1 Solution

Accepted Solutions
Lech_Miszkiewicz

Hi, be more precise please - who in your definition is visitor - do you refer to a person who has an access to NPrinting admin console and/or News Stand portal? 

Would you then use a formula like:

Count(Distinct User name), where user "User name" is a session created by a "User name" who gets authenticated by NPrinting?

If that's what it is you would have to gather nprinting_webengince.log  load them to QlikView or Qlik Sense or even excel and search for lines where you would see "Windows login successful...." phrase

 

Qlik.NPrinting.Repo	20.19.3.0	Qlik.NPrinting.Repo.Service.AuthenticationService	20200618T090306.410+10:00	INFO	NPTEST01	Lech Miszkiewicz	0	0	0	0	0	0	0	0	Windows login successful. The user with id fe4d87c2af884575b8706f954e5b07d4 has been correctly identified as a Windows domain user with sid S-1-5-21-587454654-587454654-587454654-22211			
Qlik.NPrinting.Repo	20.19.3.0	

Qlik.NPrinting.Repo.Service.AuthenticationService	20200618T090405.096+10:00	INFO	NPTEST01	Lech Miszkiewicz	0	0	0	0	0	0	0	0	Windows login successful. The user with id fe4d87c2af884575b8706f954e5b07d4 has been correctly identified as a Windows domain user with sid S-1-5-21-587454654-587454654-587454654-22211			

 

 

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

View solution in original post

3 Replies
Lech_Miszkiewicz

Hi, be more precise please - who in your definition is visitor - do you refer to a person who has an access to NPrinting admin console and/or News Stand portal? 

Would you then use a formula like:

Count(Distinct User name), where user "User name" is a session created by a "User name" who gets authenticated by NPrinting?

If that's what it is you would have to gather nprinting_webengince.log  load them to QlikView or Qlik Sense or even excel and search for lines where you would see "Windows login successful...." phrase

 

Qlik.NPrinting.Repo	20.19.3.0	Qlik.NPrinting.Repo.Service.AuthenticationService	20200618T090306.410+10:00	INFO	NPTEST01	Lech Miszkiewicz	0	0	0	0	0	0	0	0	Windows login successful. The user with id fe4d87c2af884575b8706f954e5b07d4 has been correctly identified as a Windows domain user with sid S-1-5-21-587454654-587454654-587454654-22211			
Qlik.NPrinting.Repo	20.19.3.0	

Qlik.NPrinting.Repo.Service.AuthenticationService	20200618T090405.096+10:00	INFO	NPTEST01	Lech Miszkiewicz	0	0	0	0	0	0	0	0	Windows login successful. The user with id fe4d87c2af884575b8706f954e5b07d4 has been correctly identified as a Windows domain user with sid S-1-5-21-587454654-587454654-587454654-22211			

 

 

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

View solution in original post

sleepyteatree
Partner
Partner
Author

Thank you so much for the reply @Lech_Miszkiewicz

For our purposes, a visitor would be any individual who visits the NPrinting or NewsStand portals. I looked through the logs and that seems to fit what I need.

Do you know if there's a way to find the same information through the postgres database?

Lech_Miszkiewicz

I dont know at the moment - Let me play with it little bit and see if there is any relevant info in posgresql db

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.