Setup Process

1. Create MS SQL database "uping" on you sql server and execute create.sql script to create "MainData" table
2. Edit file "uping.exe.config":
   In section
   <add name="uping.My.MySettings.upingConnectionString" connectionString="Data Source=SQL_SERVER_ADDRESS;Initial Catalog=uping;Integrated Security=True" providerName="System.Data.SqlClient"/>
   replace SQL_SERVER_ADDRESS with th name or ip of your sql server
3. Put uping.exe (uping.exe.cofig must e placed to the same folder) to startup folder or startup script (may be using GPO) without any parameters

When user logs on, Uping will collect information to MainData table of UPING database.

After that you can query database running uping.exe with different parameters:

C:\PsTools>uping /?

UPING usage:
uping.exe [login|-l [options]]

Examples:
uping.exe - to register user in database
uping.exe mike - to search information about user Mike
uping.exe mike -p - to search information about user Mike with ip ping
uping.exe -c comp - to search information about host
uping.exe -c comp -p - to search information about host with ip ping
uping.exe -i ip - to search information about IP
uping.exe -i ip -p - to search information about IP with ip ping
uping.exe -l|-a|-all - to search information about all users
with possibility to order information by:
UserName, HostName, HostIP, LogonDateTime, ago