.NET, Technology

This .NET 2.0 website adds additional functionality to associate a name and notes to the MAC addresses in a DD-WRT flashed router. I did this because the built in only has MAC fields which makes it cumbersome to associate names/computer to MACs when you have dozens of clients. The C# source code is included in the zip file. I make use of the open source SharpSSH library to gain access to the router over SSH.

You will have to edit several files for your particular environment.

DD-WRT MAC Address Toolkit Website

Category: .NET, Technology author: admin comments: 1 Comment

As an application developper you often need to write some logs for your application, and hopefully there is actually many framework to ease your pain: Log4net, Entlib Logging Application Block, etc. But when it come to read those logs, extract statistics or to do some alert or action on them, things become harder. Actually a free command line tool from Microsoft name LogParser and it is quite awesome: you can query any log and data sources (database, event log, iis logs, file system, registry, etc.) with a complexe SQL query (I mean with functions, group by, etc.).

On the down side, using it from the command line become quickly boring as you need to type your sql query in a DOS prompt. As we failed to find any intuitive GUI for logParser, we just start to build our own, by assembling the following pieces: the logparser engine, a “visual studio” like MDI dockable interface, syntax highlighting…

Publishers Web Site

Download Now

Some other notes…

Do an insert to a db with the log parser utility from IIS resource toolkit:

C:\Program Files\IIS Resources\Log Parser>logparser "SELECT date, time, c-ip, cs
-uri-stem, cs-uri-query, cs-username  FROM C:\WINDOWS\system32\LogFiles\W3SVC201
2337366\*.log TO test2 WHERE SUBSTR( cs-uri-stem, LAST_INDEX_OF(cs-uri-stem,'.'), STRLEN(cs-uri-stem)) = '.asp'" -i:IISW3C -o:SQL -server:teas-db1 -usern
ame:sa -password:"foobar" -driver:"SQL Server" -database:kevin_temp -createtable:ON

Category: Technology, Windows author: admin comments: No Comments