Skip to main content

Recommended Configuration for the MongoDB Solution

The MongoDB Solution inherits settings from the MongoDB > Settings node. However, it is best practice to assign the host list and the Connection Profile at the data collection level, the 0.Collection Job Group. After you assign these to the job group, you can run it directly or schedule it.

Dependencies

  • The query must be configured with a list of target database clusters or instances

Some of the 0.Collection Job Group queries can be scoped to target specific databases/instances. However, add the databases to the query first.

Targeted Hosts

You must set the 0.Collection Job Group to run against a custom host list containing the MongoDB database instances / clusters.

Connection Profile

The NoSQL Data Collector requires a specific set of permission. See the Permissions section for necessary permissions. The account used can be either an Active Directory account or a SQL account. After you provision the account, create a custom Connection Profile containing the credentials for the targeted environment. See the NoSQL Custom Connection Profile & Host List topic for additional information.

Assign the Connection Profile under the MongoDB > 0.Collection > Settings > Connection node. By default, the connection node uses the Default Profile configured at the global settings level. However, since this may not be the Connection Profile with the necessary permissions for the assigned hosts, click the radio button for the Select one of the following user defined profiles option and select the appropriate Connection Profile dropdown menu.

See the Connection topic for additional information.

Schedule Frequency

One of the most important decisions to make is how frequently to collect this data. The MongoDB Job Group can be scheduled to run as desired depending on the types of auditing being conducted and the scope of the target environment. The general recommendation is to schedule the solution to run daily.

Run Order

Run the 0.Collection Jobs first and in order. You can run the other MongoDB Solution sub-job groups in any order, together, or individually, after running the 0.Collection Job Group.

info

Run the solution at the top level.

Workflow

  1. Set a Connection Profile for the 0.Collection Job Group with the permissions listed in the Recommended Configurations section. See the NoSQL Custom Connection Profile & Host List topic for additional information.

  2. Set the Host list for the 0.Collection Job Group with the servers containing the target databases. Additionally, add the database clusters or instances to the Filter page in the query configuration. See the NoSQL Custom Connection Profile & Host List topic for additional information.

  3. (Optional) Configure the queries for the jobs in the 0.Collection Job Group

  4. Schedule the 0.Collection Job Group to run daily or as desired

    note

    Running the 0.Collection Job Group is a prerequisite for the other job groups in the SQL solution

  5. Review the reports generated by the 0.Collection Job Group’s jobs