Is it possible to log access by users using HAP from home?

[ragbuster]

Does HAP have a log in which I can determine who is logging in/off to the system at home?

Would be nice to have it list login time/logoff time and files accessed for a user.

Actually a nice graph might be nice to see the change over a certain period of time.

 

The logon tracker sounds like it logs access from local workstations which I do not really need, is this correct?

[nickbro]

What you are after is the web tracker part of the logon tracker, which is enabled when you create an SQL Database for HAP+ to use

[ragbuster]

Thanks Nick, are there any instructions somewhere on how to set this up?

[nickbro]

https://hap.codeplex.com/wikipage?title=Logon%20Tracker&referringTitle=Videos

[Edu-IT]

So if I understand you right this will track usage of HAP, rather an computers right?

[nickbro]

Adding a SQL Provider will enable the web tracker part of logon tracker. You can then use both

[Edu-IT]

But what does the web tracker do, just track logins to HAP or actual web usage on clients?

[nickbro]

it tracks a fair number of things that HAP+'s api's do because of the clients

[nickbro]

E.g.

 

11 October 2012 18:41 Logon 86.186.133.127 07lc IE 9.0 WinNT Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.0; Trident/5.0)

11 October 2012 18:41 MyFiles.List 86.185.61.121 12RM IE 9.0 WinNT Requesting list of: \\cri-svr-001.crick.internal\Shared Areas\Students\Subjects\ICT\Year 7\ICT - Personal profile powerpoint

[ragbuster]

So I still need to install logon tracker then?

 

So install logon tracker and then follow sql server setup. Your video shows hap version 6 but I assume the config options are still in the same places. Will have to install the database on a different server because our cc4 server is working hard already.

[nickbro]

The logon tracker is just for work stations. The web tracker is a part of the logon tracker's interface but not really tied to it apart from the sql database

[ragbuster]

So I dont need to install anything on the server just set up the sql database, is this right?

[nickbro]

Yep, and tell HAP+ to use that provider

[ragbuster]

Excellent, will have a look at doing this tomorrow.

Just out of interest will hap be compatable with the new windows 8 phones. Looking at buying a Nokia Lumia 920 in yellow. I think I read somewhere that you were also getting one.

[nickbro]

It works on WP7 so should work on WP8. You can't upload files though, it's one of limitations, though WP8 should fix some of those

[Edu-IT]

Thanks for this Nick! What's the URL to view the tracker data, is it just /tracker? I removed some of the original links from the dashboard. ;-)

[ragbuster]

Morning Nick, you knew this was coming but I have a question.

I have got to the part where I have to create login account in sql server which your video shows you creating a IIS APPPOOL\extranet user but in my case I am using IIS6.5 on a different server.

I assume I have to use network service user but seem unable to select it when browsing active directory. The server is a member of cc4 domain so I see the domain listed and click check names and it finds network service, I click to add it and it ends up being entered as the name of the sql server\network service instead of the cc4 server\network service.

 

First am I right in thinking I should be using the network service account for iis6.5 and do you know how I can enter the account properly?

Thanks

[ragbuster]

Ok managed to get it to work had to add the user in SQL server as domainname\computername$.

I think it is working correctly now but I dont seem to see any graphs, does it require something else for this?

[ragbuster]

Been looking at the aspx file and noticed at the top these lines:

 

Looking in the scripts folder show that none of these .js files exist. Is this the problem?

[nickbro]

Sorry about that, don't know where they have disappeared to, attached is the correct scripts folder

[Edu-IT]

Ragbuster - can you clarify what you mean? I am looking to set this up too and have IIS on a different server to SQL.

[ragbuster]

Replied to your private message. Hope it helps

[peterdwyer]

There is another way without using SQL at all. If you look in inetpub\logs\LogFiles\W3SVC1, you will find a heap of log files with names like "u_ex120820.log". These files contain all access (except upload) for HAP and a new file is created each day at GMT midnight.

 

I wrote a quick and (very) nasty VBS Script which looks through the file after it's been rolled over and separates out records that contain:

. "GET /hap/ - 443" - these are "login" records

. "GET /hap/Download" - these are "download" records

 

I then output a few fields (eg. User ID, Date/Time, IP Address) to separate "login" and "download" log files and, hey presto! There's my logs.

 

I actually go a bit further and extract data for the previous 30 days within my script and... convert the time to our timezone (Australian ESST) using a VBS Function that I found on the Internet. It took me only and hour or so to write the script

 

Hope this helps

[Edu-IT]

Hmm. Entries are being logged to the database but when I try to view reports the browser crashes. Any ideas? I'm pretty sure that it only started doing this after I added the new scripts folder that you uploaded to the forum. Does that folder need any special permissions? I literally just pasted the folder in over the old scripts one.

[nickbro]

What browser are you using?