If you are developing a new configuration, then be sure to include the log. It will allow you to track all changes made by users in 1C. For example, you can find out who added, deleted or changed what.
But in order for this data to be recorded, you need to configure the log. In general, it is enabled by default when creating a new configuration. But if you are not using your own configurations, it is better to check these settings.
Customizing the Log and Viewing the Change History
And so, for starters, let's set up the registration log in 1C. The settings are similar for both version 8.2 and 8.3. We start the Configurator, look for the Administration item and select Logging settings.
Here you need to select the last item Log errors, warnings, information, notes.
Now, for example, let's go to 1C and create some new document or directory, you can just make changes. I will create a new document.
Now, in order to view the changes in the registration log, you need to go to the configurator, open the Administration menu item and select the Registration log.
The Logbook opens, which records all user actions. For example, I created a new document. Let's see how my actions are recorded in the log. We see a table that has fields Date and time, User, Event, Transaction status and metadata. According to them, we see that I entered the program on 11/13/17 under the Administrator account. In the event column, you can see that I added Data. The metadata column shows which document.
The registration log is very convenient, it stores detailed information about the user's actions. When I launched the configuration under whom I entered what I added and what time I left the program. But in order to track the actions of each user, it is necessary that he log in under his account.
In the course of an enterprise's operation, it often becomes necessary to find out who, when and what exactly changed in a document or program guide.
Very often I get asked questions:
- How to see the changed document in 1C 8.2?
- How to see the person who changed the document in 1s?
- How to find out in 1C who and when changed documents?
- How to find out in 1C who changed the wiring in a document?
- How to see who changed the document in 1s?
Registration log
Contains information about what events occurred in the infobase at a certain point in time or what actions a particular user performed. For each log entry that reflects data changes, the completion status of the transaction is displayed (transaction completed successfully, or transaction canceled).
The registration log is available both in 1C:Enterprise mode and in the Configurator mode.
Access to the registration log is possible both from the Configurator mode (via the menu Administration - Logbook) and from the Enterprise mode (menu Service - Logbook). In taxi mode ( Main Menu - All Functions - Standard - Logbook)
Log type(Regular forms and Taxi):
Selection in the register(Regular forms and Taxi):
Using the tools for working with lists, it is possible to upload the registration log to a spreadsheet or, if necessary, a text document (via Actions - Display a list), which can later be saved, for example, in Excel, TXT or HTML format. At the same time, it is possible to set the level of events that will be recorded in the log, as well as the frequency of dividing the log into separate files (in the menu configurator mode Administration - Logging Setup).
And there it is also possible to reduce the number of entries in this log until a certain date, which is done to speed up the work with the mechanism for analyzing and logging events in the system or because irrelevant information is no longer needed.
Where is the log file stored?
In the Filebase: in the base directory folder 1Cv8Log- this is the directory containing the log.
If you are planning to transfer a file database and want to keep the log history & you should definitely copy the 1Cv8Log folder to the category of the new 1C database. If you need to clear the 1C log in the file base, simply delete the 1Cv8Log folder.
ATClient-server base: C:\Program Files\1cv8\srvinfo\<Имя кластера сервера>\<Идентификатор базы на сервере>\1Cv8Log
Since version 8.3.5.1068. Significantly reworked the registration log in order to increase the speed of executing requests to the log and increase the reliability of data storage.
For this, among other things, it was necessary to change the format for storing the registration log. It is now stored in a single SQLite database file. This file has the lgd extension.
Object versioning
In some 1C configurations, a special mechanism "Versioning objects" has been introduced.
Versioning is disabled by default, to enable open Service - Accounting settings - Accounting settings
By clicking the "Setting object versioning" button, we select which directories and documents need to be versioned (observe who changed what and when).
By default, infobase objects are not monitored, so each type of document has the "Do not version" flag set. If you want the monitoring to be carried out, you need to set "Version" in front of the document log of interest.
That's all, when you close the window and click on the "OK" button, objects will be monitored.
In order to view all the changes that someone made in a document or directory, you need to go to the menu: Service - History of object changes
The registration log in 1C 8.3 is very useful in that it displays events that have occurred in the infobase with the time, computer name and user name, and links to the data being changed. When users are authenticated, entries are also created in the log indicating the method of entering the program. This mechanism allows you to answer one of the most common questions - who last made changes to a particular object.
Where can I find the registration log in 1C 8.3? Through the menu "All functions" - "Standard" or, in typical 1C configurations, in the menu "Administration" - "Support and maintenance".
The registration log is configured in the configurator mode. From the Administration menu, select Logging Setup.
Here you can configure the events that will be displayed in the log.
Selecting the first setting item allows you to not keep a log at all. The remaining settings are arranged in ascending order of importance. With a large number of users, it is not recommended to register notes in order not to clog the database.
When creating a new infobase, the mode for registering all events is set by default.
Viewing and searching records
When you open the registration log itself, at first glance it may seem that there is a lot of information and it is simply unrealistic to find it. Actually it is not.
By default, 200 entries are output to the log. Displaying a large number of records can adversely affect the performance of your program or simply freeze it.
In the log list form, you can set the filter and use the search. The search is only superimposed on records that are already displayed (in this case, the last 200 events). The selection is applied to all records.
The search is carried out by the displayed data in the tabular section, so when using it, you only need to specify the column and the data to be found.
Filtering allows you to filter data by specific users, computer names, events, etc. You also have the opportunity to display log entries only for specific metadata, data (a link to the desired object is indicated, for example, a specific document) and other settings.
This example shows the registration log settings for selecting all events of the "Admin" user, starting from 06/20/2017.
Where is the log file 1cv8.lgd stored
The place of physical storage of the registration log directly depends on whether the file base or client - server.
File base
With this placement mode, the log is located in the folder with the database itself. Its location can be found either from the list of bases, or from the help "About the program".
If you go to this address, you will find a folder named "1Cv8Log". This is where the log data is located in the 1Cv8.lgd file.
If you need to transfer the database from one place to another, you can also copy this directory, then the log data will be transferred along with the database.
When this directory is deleted, the log will be cleared.
Client-server base
In this mode, everything is the same as in the previous one, only the 1C log data is stored on the server. Most often, its location is as follows:
- C:\Program Files\1cv8\srvinfo\<место расположения информационной базы>\1Cv8Log
Optimization
The log can be optimized if necessary, especially when a large number of events occur in the database.
One way is to configure the logging of only certain events discussed above. For example, you don't need to track notes if you don't need them.
In older releases of the platform, the division of the registration log by periods was available in the log settings. The entire log could be divided into separate files with a specified frequency (day, month, year, etc.).
Starting from the version of the 1C platform 8.3.5.1068, the registration log is stored in the sqlite database file with the *.lgd extension, and this setting has become unavailable. This method of storing the log is much more productive than the old one.
How to reduce or delete the log in 1C
If it is necessary to partially or completely clear the log entries in the settings window, click the "Reduce" button. In the window that appears, specify the date by which all entries should be deleted. Also deleted records can be saved to a file just in case.
14.09.2018 15:26:36 1С:Servistrend en
Where is the registration log in 1C 8.3?
The registration log is a 1C functionality that allows you to view information about events that occurred in a particular database and changes to documents. The log consists of records, each of which is structured in detail: who, what, when and in what performed any operation.
Thanks to the competent use of the registration log in 1C 8.3, you will be able to fully see the picture of interaction with the database, which can be extremely important in some cases. For example, in one document, someone changed the number/date/cost or some other important details, and you would like to find out who did it and when. Often there are also cases when a document in the database simply disappears (that is, someone deleted it) - in this case, you cannot do without a registration log.
Let's move on to opening the registration log in 1C 8.3. In the program, select Menu - Tools - Options:
Make sure you have the "Display command All functions" checkbox checked:
After that, open Menu - All functions:
Select Standard - Logbook:
You will see the current database registration log with the presented list of operations:
It can be viewed in free mode, but it contains many records of operations that take place in the database without your participation (supporting the operation of various mechanisms). In order to filter out unnecessary information, you need to use the selection.
For example, let's ask ourselves a question - what did the chief accountant do today? Set the selection conditions:
By clicking OK, we get a list of user operations:
It can be seen that she made changes to the payment order. Unfortunately, the log does not capture the specific values changed in the document. We can only state the fact of change itself.
Now let's see who logged into the program today by setting the selection conditions for the "Session - Authentication" events:
By clicking OK, we get a list of users who entered the database today:
There are many examples of the use of the logbook. Combining the experience of our consultants, we can say that the registration log is a powerful tool that allows answering many questions of accountants that someone has changed something somewhere without their knowledge.
Try different eligibility criteria and get familiar with the logbook. It will allow you to control the actions of employees in the database and detect unreasonable changes in time.
During the long-term operation of 1C databases, a large number of entries can accumulate in the registration log, which, in turn, greatly reduces free disk space. Therefore, periodically it is recommended to reduce the size of the log and delete outdated entries.
What is a 1C registration log?
The registration log stores information about the events that occurred in the infobase and what actions users performed.
The logbook is available both in 1C:Enterprise mode (menu: Service - Logbook) and in the Configurator mode (menu: Administration - Logbook).
Log setting.
Logging is configured in the Configurator mode (menu: Administration - Logging settings)
It is possible to set the level of detail of the data stored in the log, as well as the frequency of splitting the log into separate files.
Where are log files stored?
The log files are stored in the folder srvinfo 1C:Enterprise installation directory (C:\Program Files (x86)\1cv82). The 1CV8Reg file contains a description of the directories in which the registration log data for each 1C base is saved.
How to reduce log size?
You can reduce the registration log by clicking the "Reduce" button on the form of the Registration log settings. The form that opens will display the current range of events stored in the log. It is possible to delete events before a certain date and save the deleted data to a file in case the data needs to be analyzed later. In addition, it is possible to merge the reduced data with the previously saved file.
A warning is issued before the log is truncated.
By the way, it makes sense to store the archive records of the registration log in a compressed form, because the textual information stored in them is very well compressed by the archiver.
