Solution

1. Device and OU Information:

   • Device data is in the dbo.Device table.

   • OU data is in the dbo.Groups table.

2. Setup Configuration:

   • The SetupID field in dbo.Device or dbo.Groups references the configuration details stored in the dbo.Setup table.

   • In dbo.Setup, two critical fields related to firmware are:

     • ImageFile: Specifies the image file.

     • FirmwareID: Links to the dbo.Firmware table.

3. Firmware Details:

   • In dbo.Firmware, essential fields include:

     • Protocol: Defines the protocol (0 = HTTP, 1 = FTP, 2 = FTPS, 3 = HTTPS).

     • Path: Specifies the file path.

     • ServerID: Connects to the dbo.Server table.

4. Server Configuration:

   • In dbo.Server, the configured server information is accessible via:

     • IPAddress: Server’s IP address.

     • IPName: Server’s domain name.

To find Firmware tab information related to devices and organization units (OUs) in the Scout Enterprise Console within the SQL database, the following guide provides details on tables and fields involved.

Referencing the fields in dbo.Device, dbo.Groups, dbo.Setup, dbo.Firmware, and dbo.Server enables precise access to Firmware tab data within the Scout Enterprise SQL database.