Submit a ticketCall us

AnnouncementsFace your biggest database issues head-on

Our new eCourse helps you navigate SQL Server performance blocks by teaching you how to recognize and deal with the three DBA Disruptors: Performance Hog, Blame Shifter, and Query Blocker. Register today to learn how to defend your environment and fend off menacing disruptions.

Register for your free eCourse.

Home > Success Center > Log & Event Manager (LEM) > LEM - Knowledgebase Articles > Import a text file to create a User Defined Group (UDG)

Import a text file to create a User Defined Group (UDG)

Table of contents
Created by Justin Rouviere, last modified by MindTouch on Jun 23, 2016

Views: 963 Votes: 1 Revisions: 4

Overview

This process will cover how to import a text file to create a User Defined Group.

Environment

  • All versions of LEM

Steps

To prepare the file:

  1. Create a .txt file locally on the computer from where you would like to import the group.
  2. The first line should contain three parts:
    1. UDG,Group Name,Description
    2. All files first line should always begin with UDG, followed by the name of the group as it should appear in the LEM and finally the description separated by commas.
    3. Example: UDG,My Import Group,My Import Description
  3. The next lines will contain the data:
    1. Name, Data, Description
    2. The next lines will be the data as it will appear in the LEM. Name is the common name how you will reference the data. Data is the information the LEM will use in rule correlations. Description is a notes field for your reference.
    3. Example:  Bob's Machine, <Client's IP address>, This is the IP for Bob's Machine
  4. Save the file as a .txt file.

 

To import the file:

  1. Sign into the LEM Web or AIR console.
  2. In the top navigation bar, click Build and Groups.
  3. On the right side there is a Plus icon to Add and a Gear icon.
  4. Click the Gear icon and select Import.
  5. Browse to the file and select Open.
  6. The User Defined Group should now appear in the Groups view.

 

 

 

Last modified

Tags

Classifications

Public