Simple Compliance Audit Report

In the next example we visualize compliance information that Power BI can pull from OTbase if you have defined policies in WORKFLOW/AUDIT.

Here we have started again with a simple device table that allows us later to see details for non-compliant devices. We have also included the device counter that we used in the previous example, and the location treemap that shows the sites where the devices in the result set are located. Finally we have added a slicer that we have associated with the Tags data model; it allows us to drill further down if we want to limit the result set to devices that have certain tags attached.

In order to check policy compliance, we have introduced a slicer that is linked to the Policy field in the Compliance data model. This gives you a breakdown of all policies that are defined in OTbase. The slicer now allows you to filter the device result set to devices that are associated with the selected policy.

In our example we have selected the Adobe Flash Player policy, which means that the output will be filtered to only show devices and associated metadata that are subject to this policy.

In order to check compliance status, we also introduce a donut chart that shows the relationship of the number of compliant devices to the number of non-compliant devices.

If we only want to see non-compliant devices, we just need to click on the non-compliant segment on the donut chart (or the respective legend to the right), and the result set shrinks to 64 devices.

Since we have also set up a slicer for tags, and our data set includes a special tag for engineering stations, we take advantage of this capability and Ctrl-Click on the "Engineering Station" tag. This allows us to check for any engineering stations in the non-compliant result set.

Here we see that one engineering station is in non-compiance with the Adobe Flash policy, and that it is located in the Flat Rock plant. Since we have also included the device profile as a field in our device table and made it clickable, we can launch the device profile of the troublemaker with one mouse click and see all the details for this device.