Reports¶

SambaBox enterprise directory allows you to export data from your database as reports in various formats such as csv and xls.

You can get two types of reports in SambaBox. In general, getting a report is explained.

Report title editing and report printing are common in both report types.

Built-in Reports¶

On this screen, you can select one of the frequently used reports from the list of reports prepared by default.

Default Report List¶
Process
user list
group list
computer list
users in a group
expired accounts
active accounts
users not logged in
users not changed password
last edited users
last deleted users
users recently changed their password
last added users
last added computer
last deleted computer
users who are logged in
last added groups
last edited groups
last deleted groups
last edited computer
users who are failed to login
users who are entered wrong password
users who are entered non existent user

Custom Reports¶

You can follow the steps below to prepare a custom report.

Press the [New Report] button on the custom report screen.

Type the new report name.

Press the [Ldap Query Editor] button.

On this screen, you can report users, groups and computers according to various criteria. You can perform searches for the report by selecting more than one criteria combined with and/or. You can search for the report by selecting the search criteria and pressing the [+] button, then the [Export to New Report Form] button.

Use of report criteria¶
Search criteria	Explanation
enabled	Objects active in the domain
disabled	Objects disabled in domain
non expiring	Objects not expiring in domain
days since last logon	Number of days since last login (Must be minimum 14 days or password change period)

Custom report preparation object attributes selection¶
Attribute	Explanation
CN	Object name without specific information
Department	User’s partition feature
Description	User’s explanation definition
DisplayName	User’s display name
Givenname	User’s first name
MemberOf	User’s subscriptions
Name	User’s name
samaccountname	User’s login name
mail	User’s e-mail address
mobile	User’s mobile phone number
sn	User’s recognition name
userprincipalname	User’s name in form of e-mail address

Note

The criteria or attributes listed above;

same

not equal

starting with

ending with

there is

none

Enter the value for the attribute to be searched with selections and you can search by pressing the [+] button and then the [Search] button.

Press the [Add] button.
Select the report you created from the edit window.
Press the [Results] button.

Reports List Heading¶

On this screen, you can add or remove other attributes from the report titles prepared by default.

Select account type (User-Group-Computer).

Select the attribute to add as a title from the attribute box.

Press the [Add] button to the report titles.

Press the [Save] button.

Hint

You can easily change the report titles as you want them to appear with drag / drop method.

Send Report via E-mail¶

Custom Reports can be sent to certain e-mail addresses at certain time intervals.

You can use this screen for reports up to active accounts.

When the days of the week are selected, which day of the week is selected in the selection field on the side and at what time the report will be sent on the selected day in the last optional field.
When the days of the month are selected, the day of the month is selected in the selection field on the side and the time at which the report will be sent on the selected day is selected in the last optional field.

When day of the week/sun/2am is selected, the report will be sent at 02 am every Sunday of the week.

From users who are not logged in, you can use this screen. On this screen;

The time from which the selected report feature will be valid is set.
The selection to be made from the date field is set in the report after which date the desired state occurs.
When the validity time is selected, the last number of days is set when the desired condition is met.
When the days of the week are selected, which day of the week is selected in the selection field on the side and at what time the report will be sent on the selected day in the last optional field.
When the days of the month are selected, the day of the month is selected in the selection field on the side and the time at which the report will be sent on the selected day is selected in the last optional field.

In this report, when the validity time is selected as 10, the events in which the desired situation occurred in the last 10 days will be reported.

In Special Reports;

When the days of the week are selected, which day of the week is selected in the selection field on the side and at what time the report will be sent on the selected day in the last optional field.
When the days of the month are selected, the day of the month is selected in the selection field on the side and the time at which the report will be sent on the selected day is selected in the last optional field.

When day of the week/sun/2am is selected, the report will be sent at 02 am every Sunday of the week.

Report Export¶

Select the organizational unit to receive the report from.

Warning

If you do not make any selection, the report will be issued for registrations in the whole domain.

Select the report output format.

Reports are created in XLS and CSV format. You can choose the one you want and download it to your computer.

Hint

If you want, you can add other attributes to the attributes shown by default. For this, enter a few letters of the attribute to be added in the attribute addition window and you can add it by selecting it from the list. You can remove it from the list later if necessary.

Warning

The search criteria and attributes listed above are for user searches. The criteria and attributes for group and computer searches may differ.