Find the total unique visitors per month?

[sleepyteatree]

Hello,

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

Thank you

[Lech_Miszkiewicz · Accepted solution]

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			

[sleepyteatree]

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