Custom Application to get data from BigFix DB

Customizations
1

Hi All,

Hope you are all doing well, our development team wants to consume endpoint properties data from BigFix DB (BFEnterprise). we want to make sure some things:

  1. does the ComputerID column on the COMPUTERS table can be useed as a unique identity to query some data from another table?
  2. does the isDeleted column become 1 when the client is removed from the computers list on BigFix console?
2
  1. Yes
  2. Yes

For reference, please point your developers to the Database API documentation on the developer portal. If your development team decides to not leverage the Database API but rather access the raw underlying tables, ensure they take due diligence to ensure only READ operations are performed, no schema changes are introduced, and extreme care is taken to ensure query locks are not excessive (ideally if at all possible use the WITH (NOLOCK) hint on the queries).

While the database schema has changed little over the years, only the Database API is supported by BigFix. Accessing the database tables directly may cause issues in the future should the schema change. As such, they should check the database schema version to ensure integration compatibility. They can pull the current database schema version using a query such as:

SELECT TOP (1) [Version] FROM [BFEnterprise].[dbo].[DBINFO] WHERE [ServerID] = 0

2 Likes
3

Hi Mike,

noted, thank you for the advice