Vlasov Studio Visual Time Spent v2.0.0
![Vlasov Studio Visual Time Spent v2.0.0](https://i.imgur.com/dZkbVPF.png)
Vlasov Studio Visual Time Spent v2.0.0
Visual Time Spent automatically tracks your time spent working on solutions, projects and documents in Visual Studio 2022/2019/2017. You can generate reports to see overall time spent and what activities took most time.
Installation
Visual Time Spent installer requires admin rights and installs for all users. The monitoring module is installed for each Visual Studio version present on the computer - you can verify its integration opening the About Microsoft Visual Studio dialog. A shortcut to the Visual Time Spent reporting tool is added to the Start Menu - All Programs list.
Monitoring and reporting
All your activity such as editing and browsing in Visual Studio automatically recorded to a database. The reporting tool lets you specify report period and displays summary of your activity grouped by solution/project/window and sorted by time spent. For each solution and project the time spent percentage out of total time is displayed in the % column.
You can export the report to a CSV file for analysis in Excel or another application using the Export to CSV toolbar button.
Hovering the mouse over a solution name shows a tooltip with the solution path.
Idle time (when you don't use Visual Studio for more than 2 minutes) is automatically excluded from the report.
Database
The database with all recorder activity is stored in the file %LocalAppData%\Sergey Vlasov\Visual Time Spent\1.0\events.sdf. It is a Microsoft SQL Server Compact 4.0 database.
Visual Time Spent API
Visual Time Spent provides an API that you can use to programmatically retrieve activity statistic collected by the Visual Time Spent monitoring module. To call Visual Time Spent API functions you need to reference "C:\Program Files (x86)\Visual Time Spent\vtsext.dll" assembly from your .NET 4 application.
Following functions from the VisualTimeSpentExt.Reports class are available:
// Returns activity summary grouped by solution/project/window and sorted by time spent.
static UserActivitySummary UserActivity(System.DateTime from, System.DateTime to)
static UserActivitySummary UserActivity(System.DateTime from, System.DateTime to)
To run your application that references vtsext.dll, copy to the application directory following files from "C:\Program Files (x86)\Visual Time Spent": sqlceca40.dll, sqlcecompact40.dll, sqlceer40EN.dll, sqlceme40.dll, sqlceqp40.dll, sqlcese40.dll, System.Data.SqlServerCe.dll, vtsext.dll.
![](/vault/images/2017/04/15/a78a9bf38f979992acdc2afa25ac8331.gif)
![](/vault/images/2017/04/15/a78a9bf38f979992acdc2afa25ac8331.gif)
Warning! You are not allowed to view this text.