SIEM Visualization Example 4

2 min read

Users Added Or Removed From A Local Group (Within A Specific Timeframe)

In this SIEM visualization example, we aim to create a visualization to monitor user additions or removals from the local “Administrators” group from March 5th 2023 to date.

Our visualization will be based on the following Windows event logs.

Navigate to the bottom of this section and click on Click here to spawn the target system!.

Navigate to http://[Target IP]:5601, click on the side navigation toggle, and click on “Dashboard”.

A prebaked dashboard should be visible. Let’s click on the “pencil”/edit icon.

Elastic dashboard with SOC-Alerts listed, option to create or edit dashboards.

Now, to initiate the creation of our first visualization, we simply have to click on the “Create visualization” button.

Upon initiating the creation of our first visualization, the following new window will appear with various options and settings.

Elastic dashboard: Add filter, select windows index, bar vertical stacked chart.

There are four things for us to notice on this window:

  1. A filter option that allows us to filter the data before creating a graph. In this case our goal is to display user additions or removals from the local “Administrators” group. We can use a filter to only consider event IDs that match 4732 – A member was added to a security-enabled local group and 4733 – A member was removed from a security-enabled local group. We can also use a filter to only consider 4732 and 4733 events where the local group is the “Administrators” one.Elastic dashboard filter: event.code is 4732 or 4733, group.name is administrators.
  2. This field indicates the data set (index) that we are going to use. It is common for data from various infrastructure sources to be separated into different indices, such as network, Windows, Linux, etc. In this particular example, we will specify windows* in the “Index pattern”.
  3. This search bar provides us with the ability to double-check the existence of a specific field within our data set, serving as another way to ensure that we are looking at the correct data. We are interested in the user.name.keyword field. We can use the search bar to quickly perform a search and verify if this field is present and discovered within our selected data set. This allows us to confirm that we are accessing the desired field and working with accurate data.Elastic dashboard: Filter event.code 4625, search user fields.
  4. Lastly, this drop-down menu enables us to select the type of visualization we want to create. The default option displayed in the earlier image is “Bar vertical stacked”. If we click on that button, it will reveal additional available options (image redacted as not all options fit on the screen). From this expanded list, we can choose the desired visualization type that best suits our requirements and data presentation needs.Visualization type menu: Bar vertical stacked selected.

For this visualization, let’s select the “Table” option. After selecting the “Table”, we can proceed to click on the “Rows” option. This will allow us to choose the specific data elements that we want to include in the table view.

Table configuration: Add fields to Rows, Columns, and Metrics.

Let’s configure the “Rows” settings as follows.

Rows configuration: Select user.name.keyword, top 1000 values, ranked by count of records in descending order.

Moving forward, let’s close the “Rows” window and proceed to enter the “Metrics” configuration.

Table configuration: Rows set to top values of user.name.keyword, add fields to Columns and Metrics.

In the “Metrics” window, let’s select “count” as the desired metric.

Metrics selection: Choose 'Count' function.

One final addition to the table is to include some more “Rows” settings to enhance our understanding.

  • Which user was added to or removed from the group? (winlog.event_data.MemberSid.keyword field)
  • To which group was the addition or the removal performed? (double-checking that it is the “Administrators” one) (group.name.keyword field)
  • Was the user added to or removed from the group? (event.action.keyword field)
  • On which machine did the action occur? (host.name.keyword field)Table showing top values of user.name, winlog.event_data.MemberSid, group.name, event.action, host.name, with record counts.

Click on “Save and return”, and you will observe that the new visualization is added to the dashboard.

As discussed, we want to monitor user additions or removals from the local “Administrators” group within a specific timeframe (March 5th 2023 to date).

We can narrow the scope of our visualization as follows.

Dashboard showing failed logon attempts and RDP logon for service account, with options to edit lens and create drilldown.
Dashboard showing failed logon attempts and RDP logon for service account, with options to customize time range.
Dashboard with failed logon attempts and RDP logon, showing panel time range customization to March 5, 2023.

Share This Article :

Leave a Reply

Your email address will not be published. Required fields are marked *