iTimeTrack Sql Server Management Studio (SSMS) Plugin

You can automatically track your time in Sql Server Management Studio (SSMS) using the iTimeTrack plugin.

Installing

  1. Download the four required files from:
    1. Github (https://github.com/itimetrack/itimetrack-ssms/releases/latest), individually download each file
  2. Copy the four files to:
    1. C:\Users\<username>\AppData\Roaming\Microsoft\MSEnvShared\Addins
      1. You will probably need to create the last two folders MSEnvShared and Addins
    2. Optionally, you can choose other folders that SSMS looks for plugins at by starting regedit.exe, then go to HKEY_CURRENT_USER\Software\Microsoft\SQL Server Management Studio\11.0_Config\AutomationOptions\LookInFolders
  3. Right click on iTimeTrack.dll, Properties and select Unblock.  Also unblock nlog.dll
  4. Restart SQL Server Management Studio.
    1. The first time the plugin runs, it will download and install Python (if there is no Python on the system) and it will install the itimetrack-cli (the shared code between plugins), so be patient.
  5. Enter your API key (retrieved from http://itimetrack.com/app/) , then press enter.
  6. Use SQL Server Management Studio like you normally do and your time will be tracked for you automatically.
  7. Visit http://itimetrack.com/app/ to see your generated time.