Export Access Details in Batches
This function allows you to export the access details to a file and save the file locally or to the INC server.
Operation Procedure
- Select the User tab, and then click Access User > Batch Operations in the navigation tree to enter the batch operations page.
- Select the radio button of Export Access Details in Batches, and then click Next to enter the access details query page.
- Type the query conditions and click Preview. The matched access details will be displayed in the access details list. To restore the default query conditions and query accounts information by the default query conditions, click the Reset button.
- Click Export Details, enter the format setting page of exporting file. When you finish the setting, click the OK button.
- The system will export the access details to a file, save the file to the INC server, and then display the operation result page.
- On the operation result page, you can click the Download button to download and save the file to the local PC.
Precautions
- In operation step 4, the formats include TXT and CSV. If TXT was selected, you can select the file column separators: space, Tab, comma (,), colon (:), number sign (#), and dollar sign ($). The comma-separated values (CSV) format is a text format that uses commas (,) to separate values. In Windows, a file in CSV format is opened by using Excel by default. Excel can automatically select the display format according to the contents. As a result, the contents displayed in Excel may be different from the actual contents. For example, Excel will display 123456789123456789 as 1.23457E+17 according to the scientific notation. In this case, you can configure Excel to display the contents as text, or use text editors (for example, Notepad) to open a file in CSV format.
- In operation step 4, you can select optional fields so that the exported details will contain the information of the selected fields in addition to the default fields. The optional fields include device IP, port, VLAN ID/inner VLAN ID, outer VLAN, end at, and so on. With none of these optional fields selected, the operation exports information of account name, user name, login name, service name, access at, access duration and user IP address by default.
- In operation step 5, the path for saving the exported file is: <conductor INC server installation directory>/tmp.
- In operation step 5, the name of the exported file is suffixed with the time at which you exported the file. This is for you to find the file easily.
- Make sure no column delimiter exists in any fields. Otherwise, the export will fail.
Related Topics