Is there a way or a query that I can use on SQL db to pull out all the global properties (activated and not activated) in bigfix?
Have a look at this: Property ID Mapper
I don’t know if it fully meets your needs…
Could also go to Console > Tools > Manage Properties > CTRL+A > CTRL+C
There isn’t a nice right click to get headers in addition to data like in Actions or Computers, but the data is there regardless.
Assuming all you’re looking for is the property details, the above options are good. I’ll add one more:
Rather than querying the database directly (generally not recommended), you can query for this via Session Relevance and the REST API (using the /api/query resource) with the following:
(name of it, name of source analysis of it | "n/a", display name of site of source analysis of it | "n/a") of bes properties
Or you can use the session relevance example above to create a custom Web Report with the property details output.
2 Likes
Thank you on your response here .I would like to pull out specific property from the database such as IP address of the servers.
Such information might be available through Session Relevances. For instance, have a look at (hostname of it, ip addresses of it) of bes computers.
For reference: https://developer.bigfix.com/relevance/reference/bes-computer.html#properties
1 Like