Goverlan
GUIDE MENU

WHAT IS SUREDATA TECHNOLOGY?

Goverlan now uniquely combines a real-time information query engine with a database back-end. Retrieve real-time data from accessible machines and the latest database snapshot for inaccessible machines. This way, you will get a more complete view of your environment. For detailed information on how SUREDATA works, see Understanding SUREDATA.

SUREDATA deployment considerations

SUREDATA supports two database configurations: SQLITE(file-based) and Microsoft SQL Server. Even though SQLITE is the default, Microsoft SQL Server is recommended. 

Supported SQL Server versions:

  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 R2 Express
  • Microsoft SQL Server 2012 Express
  • Microsoft SQL Server 2008
  • Microsoft SQL Server 2008 R2
  • Microsoft SQL Server 2012 
  • Microsoft SQL Server 2014

Minimum space requirements for the SUREDATA Database:

Database size will depend on the frequency and the number of workstations being queried.

1000 workstations will be approximately 400MB.  

SQLITE Database Method

Upon the first installation, Goverlan automatically uses a file-based database (SQLITE) that will be stored under the configured Goverlan Application Data Directory. 

If you wish to change any database settings, go to Settings → Database Settings.

SQLITE SUREDATA Configuration

Sharing the SQLITE Database

If you wish to share the database with other Goverlan users:

  1. Update the Folder Path option to a shared location on your network. Be sure that all Goverlan users have read/write access to the shared path. 
  2. Restart Goverlan
  3. Update all other Goverlan users to the same path and restart each Goverlan instance. 

     

Microsoft SQL Server Method

If you have more than 2 users running Goverlan, we recommend a  SUREDATA database on a Microsoft SQL Server. You can use an existing SQL Server instance or create a new Microsoft SQL Server Express instance. Once the Microsoft SQL Server is available, use the Database Settings window to configure it. 

Note: Please refer to our KB articles "Configuring SQL Server Express 2012 for SUREDATA" and "Configuring security for a SQL Server installation of SUREDATA" if you are planning on using Microsoft SQL Server for SUREDATA.

Microsoft SQL Server Configuration

  1. Change the Database Type to Microsoft SQL Server
  2. Enter a Database Name
  3. Enter the SQL Server Name and Instance 
  4. Choose the SQL Server Authentication method
  5. Enter the User ID and Password used to connect to the database
  6. Click Apply 

Goverlan will now create the database on the SQL Server. After Goverlan creates the database, you may now configure the other Goverlan console users to point to the same database. Make sure that the Database Name & Instance String are identical to the initial configuration to prevent duplicate databases

 

Sharing the SureDATA Database

You can distribute the SureDATA database settings to multuple consoles via the Goverlan Central Server or the Goverlan Administrative GPO as opposed to having each Goverlan user set their own console settings. 

via the Goverlan Central Server:

After configuring the Goverlan Central Server,  you'll be able to set the appropriate SureDATA database settings in the Universal Settings Distribution tab: 

 

Double click each setting to configure your database Type, Name, etc. Each policy will have an explanation of the options you can select as well as the scope of machines youd like to set the setting against. See Using the Universal Settings Distribution tab for more info.
 

 

via the Goverlan Administrative GPO Template: 

After adding the Goverlan GPO template to your domain controller, the setting is located in Goverlan Universal Settings > Goverlan Common Settings > Database Configuration and Features:

Advanced SUREDATA Settings

SUREDATA Inventory information can be managed through Database Settings → Advanced.

SUREDATA Advanced Settings

Resetting SUREDATA tables

Database Inventory Types can be cleared individually or the entire database can be reset.

  1. Locate the Inventory Type that needs to be reset
  2. Click the Reset Data button 

Or

Click Reset All Data to clear all Inventory Types and reset the database.

Enable or Disable Inventory Types

Inventory Types can be Enabled or Disabled for various performance reasons, such as slow links between sites.

  1. Locate the Inventory Type that needs to be enabled or disabled
  2. Click the Enable/Disable button to toggle the state

Inventory Type Update Thresholds

Update thresholds are periods where the Inventory Types cannot be updated. The default setting is 300 ms. You may wish to change this setting based on the frequency of a Scope Action.

SUREDATA Threshold Settings

  1. Locate the Inventory Type that needs the threshold set
  2. Click on the Update Threshold link
  3. Change the threshold setting in milliseconds

REFERENCES