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 supports two database configurations: SQLITE(file-based) and Microsoft SQL Server. Even though SQLITE is the default, Microsoft SQL Server is recommended.
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.
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.
If you wish to share the database with other Goverlan users:
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.
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
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.
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.
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:
SUREDATA Inventory information can be managed through Database Settings → Advanced.
Database Inventory Types can be cleared individually or the entire database can be reset.
Click Reset All Data to clear all Inventory Types and reset the database.
Inventory Types can be Enabled or Disabled for various performance reasons, such as slow links between sites.
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.