Send email with baseline/fixlet results when completed

[mikelbeck]

Is there a way to send an email containing the results of a baseline, fixlet or action when the activity has completed? I’m able to send an email saying something like “done” but I’d like to include the list of computers impacted and the status/exit code to make it easy to see what worked and what didn’t.

[mikelbeck]

Nobody has a solution for this? Does that mean it can’t be done?

[JasonWalker]

Easiest way is probably to use a Scheduled Report out of BigFix Web Reports. You can can get a report of all of the action statuses, and schedule it either on a set frequency, or when the report changs, or via a custom session relevance.

[mikelbeck]

When I view the report of a baseline it shows me the components with reported, fixed, failed. If I drill down into each component I can see the individual computers that the action applied to and the result of each.

How can I get a report that shows the detailed information for each component (computers applied to with results)?

[jhickok]

You will probably need to use a custom report for that, or use the Scheduled Compliance report:

Report Available: Schedulable Compliance by Computer or Content

One of the most common feedback I get regarding these 2 reports is that they cannot be scheduled for delivery via Schedule Activity. Fixlet Compliance by Computer Group Fixlet Compliance by Content I have just created versions that can be scheduled, please check them out here: Schedulable Compliance by Computer or Content reports A few key notes: They can be scheduled using the Web Reports Scheduled Activity They are accompanied by a Custom Executable that is used for emailing, and conver…

[mimaloney01757]

In theory I see requirements to either perform an analysis or create a post action script that would read a set of log files, looking for errors, warnings, unable, fail, etc. and build a compiled columnar report that you would send as email report.

I thought BigFix uses SQLite DB and if so would it be possible to access with a BI reporting app like Cognos, Business Objects or Pentaho?

Is the BigFix DB accessible with SQL or maybe using Perl dbi?

[mikelbeck]

I would up writing something in VBScript that checks the status of baselines every 15 minutes and if the baseline is has completed, expired or if every affected computer has reported that it’s done processing the script will send an email.

[JasonWalker]

The database itself is either MS SQL (for Windows root servers) or IBM DB2 (for Linux root servers).
It’s possible, but discouraged, to query/export the database directly, as the schema is subject to change between versions.
Instead, the recommendations are to use the REST API to query data. There are some details and examples at https://developer.bigfix.com , including examples with curl, powershell, and perl.

[cmcannady]

Have you looked at the Notification Server that’s part of Server Automation?

[mikelbeck]

We don’t have Server Automation, only Patching.

[cmcannady]

Then a REST API integration to query status of action on some schedule like @JasonWalker mentioned previously is likely your best option.

[iamjairoescobar]

Also you can use WebUI . And schedule an email after is complete it

[AlexaVonTess]

Catch 22? The WebUI is NOT recommended to be installed on the BES Yet Notifications will only work if the WebUI service is co-located with the Notification Service installed. Only the Notification Service cannot be installed unless you install the BES Plug-in for SOAP/REST API, which, as the name implies, can only be installed on the BES.

Am I missing something? Has anyone be able to configure the Email Notification option in WebUI when the WebUI is on a separate server?

[wilsonchang]

Email notifications are working in our environment even though I installed WebUI on a separate server.

[AlexaVonTess]

Do you remember your steps? You had to make it a relay? Install the Notification Service? Etc?

[wilsonchang]

I had setup notifications long before WebUI came on the scene so that part known to be working. Then when I installed WebUI, I happened to choose one of our relays to host that role. No other configuration was necessary (that I recall).