Loving the Universal Reporter, it’s so much cleaner that the other reports.
But….I have a site where I deactivated an endpoint in December 2019 and it is showing on the reports as Unmanaged and has been added to each Endpoint Extended Data graph. How do I remove this from all future reports?
Best answer by cbullas
From our engineers, this may help:
The “Additional Agent Information”/Shields counts in the “Endpoint Extended” report are calculated via the Shields worksheet. This uses the data from the EndpointStatus worksheet. The formulas count endpoints that have respective settings/shields enabled, regardless whether an endpoint has been deactivated or not.
To achieve what you are asking for, you would have to adjust the formulas on the Shields worksheet to exclude deactivated endpoints. You could do so by changing all the Shields formulas from COUNTIF to COUNTIFS. For example as below:
(Note that the column K in the EndpointStatus worksheet holds the value for an endpoint being deactivated)
There may be others related areas in the report template that you want to adjust.