<div>
I have no answers because I am not a programmer but a few more facts would assist those who do ... what kind of database, version, etcetera?
</div>


I have no answers because I am not a programmer but a few more facts would assist those who do ... what kind of database, version, etcetera?

HelpDesk Technician

Michael Elliott

<div>
Is auditing part of the application your users use?<br />
Are you talking about recording their keystrokes?<br />
<br />
Remotely how, via VPN or on gaged into Remote Desktop applications?<br />
Much depends on what you are looking for. Publish an application such that the remote user has a limit of they can do.<br />
<br />
The application has to have auditing I.e. Medical, financial, etc. commonly gave auditing of which record a user accessed and when.
</div>


Is auditing part of the application your users use?
Are you talking about recording their keystrokes?

Remotely how, via VPN or on gaged into Remote Desktop applications?
Much depends on what you are looking for. Publish an application such that the remote user has a limit of they can do.

The application has to have auditing I.e. Medical, financial, etc. commonly gave auditing of which record a user accessed and when.

<div>
To track all user activities, you need to have an agent installed and act as a surveillance &nbsp;services which user cannot disable or remove it without authorisation. Better to explore solution along the user activity monitoring aspect. One of which is ObserveIT. <a href="https://documentation.observeit.com/configuration_guide/user_recording_policy.htm" rel="ugc">https://documentation.observeit.com/configuration_guide/user_recording_policy.htm</a>
</div>


To track all user activities, you need to have an agent installed and act as a surveillance  services which user cannot disable or remove it without authorisation. Better to explore solution along the user activity monitoring aspect. One of which is ObserveIT. https://documentation.observeit.com/configuration_guide/user_recording_policy.htm [https://documentation.observeit.com/configuration_guide/user_recording_policy.htm]

<div>
It can be a VPN or internal network. We need to be able to track it in SQL Server environment.
</div>


It can be a VPN or internal network. We need to be able to track it in SQL Server environment.

<div>
Thank you very much for detailed explanation
</div>


Thank you very much for detailed explanation

<div>
<div class="content wysiwyg-content">
Management wants to know what employees are doing if working remotely. I would like to track and store their activity while they are connected to our work server via remote access.<br />
<br />
I need to track all user activity such as select, insert, update and delete and put it into a table in order to create a report.<br />
<br />
The Database we use is Microsoft SQL Server 2012.
</div>
</div>


Management wants to know what employees are doing if working remotely. I would like to track and store their activity while they are connected to our work server via remote access.

I need to track all user activity such as select, insert, update and delete and put it into a table in order to create a report.

The Database we use is Microsoft SQL Server 2012.

Record activity of users

Remote access may refer to the connection to a data-processing system from a remote location, for example through a virtual private network remote desktop software, terminal emulation, or the activation of features of a business telephone system from outside the business's premises.

Remote Access

IT Administration is the processes and best practices for programming and development, and incorporates methodologies for managing activities and projects. Common methodologies include waterfall, prototyping, iterative and incremental development, spiral development, rapid application development, extreme programming and various types of agile methodology. The life-cycle "model" is a more general term for a category of methodologies, and a software development "process" a more specific term to refer to a specific process chosen by a specific organization.

IT Administration

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

This topic area includes legacy versions of Windows prior to Windows 2000: Windows 3/3.1, Windows 95 and Windows 98, plus any other Windows-related versions including Windows Mobile.

Windows OS

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.