Last post Jul 09, 2013 03:49 PM by codeman061988
Jul 09, 2013 03:26 PM|codeman061988|LINK
I've got a web project with certain links to routers, APs, servers, ect...
The company I work for wants to keep track of how often the equipment is accessed. So far, it's been a painstaking process of digging through old tickets and finding what equipment may have been accessed and when.
I figured, since I have links to the equipment in my application already, could there be some way for me to record the number of times a user clicks those links, store the numbers in SQL and then generate a report every month.
Any useful methods or tutorials to get me on the right track?
Thanks in advance,
Jul 09, 2013 03:39 PM|adamturner34|LINK
I don't think counting clicks would be a very accurate approach to reporting.
Isn't there a timestamp or a record of when the equipment was accessed?
Jul 09, 2013 03:49 PM|codeman061988|LINK
We have the time stamp at the beginning of each ticket. The tickets are recorded into their own database with a seperate application. We can also look at certain DAT tables with the EQ and see login events but these tables are cleared at times when we reset
Unfortunantly, the application the company chose for ticketing was not tailored toward ticketing so I have no way of simply making use of it and generating reports for EQ from it.It does use it's own database but it's rather complex.
The application I've designed for EQ access is one with it's own SQL Ce database.
I had it in my mind to record the click and then have the user input a ticket # for referance.