General discussion

Locked

User login times report

By Eric-M ·
Hi Everyone,

I thought this would be a pretty frequently asked question, but I did not find anything about it, so I will ask.

I have am frequently asked if I know of a software package that lets you create a report that will help me generate a report on when users logged in. Specificly I have a need for two reports, the first is a report organized by user, showing when they logged in. And another report would be showing who logged in for a certain day.

If I could get that data out of the event log and into Excel I could organize everything, but I am not aware of how to do that, if it can even be done.

So I actually have two questions, A) is there a free/low cost package to create those reports automatically, and B) if not, is there a way to dump my event log into an XLS sheet?

Thanks!

Eric

This conversation is currently closed to new comments.

6 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by jschein In reply to User login times report

On a domain, turn on auditing for those portions you need to record the data. You can export the information as needed.

Collapse -

by Eric-M In reply to User login times report

I should have been more specific, sorry... I do have auditing enabled, and I have all the data I need. But it is contained in 100,000+ security event entries. I can search for very specific things, but I am in need of a very readable report for the non-technical type.

Could you give any information on how to export information from the logs? I know you can export them to a SQL database, but that is not really what I want.

Collapse -

by Eric-M In reply to User login times report

And one last thing, the utility/program I am wondering exists would be something that would run the above mentioned reports automatically and send them to someone via e-mail. So every morning, or every Monday a manager would get a listing of the login times of all of their employees. I would assume that is a fairly common request, but I am not finding anything anywhere; perhaps I am not searching for the correct terms.

Collapse -

by Chris910 In reply to User login times report

Here is a general picture of how to manually extract your information.

From the event viewer select your category, select action on the menubar, select properties, select the filter tab, Select your event source and type and date range. This should reduce your dataset to what you need to view.
Next,
From the event viewer select your category, select action on the menubar, select export, give the file a name and select a comma delimited text file for the file type and save the file.

Now you can open the file in Excel, and tweak the appearence as needed.

Collapse -

by Eric-M In reply to

Oh dear god... I have looked at that menu a thousand times and have never seen Export there before. Thank you! I thought you needed some tool by Microsoft that ran SQL queries against the event log.

I am still curious if there are any tools to automatically run reports too, I will make a new post on that in the future.

Collapse -

by Eric-M In reply to User login times report

This question was closed by the author

Back to Windows Forum
6 total posts (Page 1 of 1)  

Related Discussions

Related Forums