I’m trying to get some relevance to find machines that don’t have the relay service running, or the main gather service or any of the following service running:
WebUI
Web Reports
BigFix Compliance
BigFix Inventory
and, ideally the SQL server housing the DBs for Inventory, Compliance and Web Reports
I currently have the following relevance, but I am looking at the computer name to determine the Inventory and SQL systems:
if { (not exists relay service) AND (not exists main gather service) AND (not (exists service "BES WebUI")) AND (not (exists service "BES Web Reports Server")) AND (not (exists service "IBM BigFix Compliance")) AND (not (computer name as lowercase contains "sqlwci")) AND (not (computer name as lowercase contains "appbfi")) }
BigFix Inventory Service looks like this:
IBM BigFix Inventory 9.2.8.0 service
I’d like to see if a Service is running that starts with:
IBM BigFix Inventory
So I won’t need to change the relevance when BigFix Inventory gets upgraded
Any idea how I can test for IBM BigFix Inventory being part of the service name?
And, any idea how I could figure out what machine is housing the DBs for Inventory/Compliance/Web Reports as an extra added bonus?
This relevance is from the Environment Information Analysis in the IBM BigFix Inventory v9 Site:
(exists settings whose (name of it starts with "SUA_Server_Path" AND ((exists folder (value of it & "/properties/version") AND exists files of folder (value of it & "/properties/version")) OR (exists folder (value of it & "/iso-swid") AND exists files of folder (value of it & "/iso-swid")))) of client)
The SUA_Server_Path is typically
Linux: /opt/ibm/BFI or
Windows: C:\Program Files\IBM\BFI
FYI - the /properties/version folder test is for older versions. The iso-swid folder structure is what would be on the BFI 9.2.8.0 server, so you may be able to simplify the relevance a bit.
You can check the name of your database and the hostname in the database.yml text file in one of the following directories. (Database problems)