The AlienApp for McAfee ePO connects to the Microsoft SQL database within your McAfee ePolicy Orchestrator (ePO) to retrieve and ingest data for analysis in USM Anywhere. After USM Anywhere analyzes the first of these events, the McAfee ePO dashboard is available.
To configure the AlienApp for McAfee ePO, you must add a scheduled job in USM Anywhere that collects data directly from the SQL database in your McAfee ePO. Before you do this, there is information about your database that is required to make the connection:
- Hostname or IP address of the SQL database
- Port number (usually 1433) that is open for the connection
- The database name
Username and password used to log in to the SQL database
Important: This is the Microsoft SQL Server account and not the Microsoft Windows user account. The AlienApp for McAfee ePO uses SQL Server authentication over Windows Authentication.
- User account has read permission for the EPOEvents table
The AlienApp for McAfee ePO page provides easy access to define a new log collection job to retrieve your McAfee ePO event data. After you create the new job, you can make changes to the parameters for the scheduled job or review its history in the Scheduler page. See Managing Jobs in the Scheduler for more information about working with scheduled jobs.
To schedule a McAfee ePO job
- In USM Anywhere, go to Data Sources > AlienApps.
- Click the Available Apps tab.
- Search for the AlienApp, and then click the tile.
- Click the Scheduling tab.
Enable an existing job or click New Job.
This opens the Schedule New Job dialog box with the options defined for an AlienApp for McAfee ePO job.
Enter the name and description for the job.
The description is optional, but it is a best practice to provide this information so that others can easily understand what it does.
Enter the McAfee ePO database connection information:
- In the IP address field, enter the IP address of the ePO server SQL database.
- In the Port number field, enter the port number on which the ePO server SQL database listens.
- In the Database name field, enter the name of the ePO server SQL database.
- In the Username and Password fields, enter the credentials you use to access the ePO server SQL database.
In the Schedule section, specify when USM Anywhere runs the job:
- Select the increment as Minute, Hour, Day, Week, Month, or Year.
Set the interval options for the increment.
The selected increment determines the available options. For example, on a weekly increment you can select the days of the week to run the job.
Or on a monthly increment, you can specify a date or a day of the week that occurs within the month.
Set the Start time.
This is the time that the job starts at the specified interval. It uses the time zone configured for your USM Anywhere instance (default is Coordinated Universal Time [UTC]).
- Click Save.
After the scheduled job runs, you should start seeing new events in USM Anywhere originating from the ePO server SQL database.