I’m trying to find a way to write a report, it likely has to be excel, and in the report, I have to list the server name in the 1st column, then the domain of the server in the 2nd column, and then there are 4 or 5 services I have to list the status of. I need to put headers into the csv or excel file as well to identify the columns, but if that were a manual step then it’s ok.
Has anyone done something like this before?
I would again point you to Web Reports, which can be viewed directly, set up to send e-mail csv reports, and/or have data pulled into other systems (like Splunk) through the SOAP API.
For the existence of a service and the state of it, just use the services inspector: https://developer.bigfix.com/relevance/reference/service.html
For example, if you just want to know the state of a single service:
Q: exists services “besclient”
A: True
Or, if you want the state of it and start type of it:
Q: (states of it, start types of it) of services “besclient”
A: Running, auto
Pull those into properties, group them in Web Reports. Hey presto.