Client Inventory Details report in Symantec Endpoint Protection Manager (SEPM) does not have options to filter by group

Products

• Endpoint Detection and Response Hardware

Issue/Introduction

An inquiry was made into if there was an option in the"Client Inventory Details" report in SEPM to return or filter computers by group affiliation.

Environment

4.8, 14.3 RU7

Cause

Reports are canned and not able to be easily customized for additional fields.

Resolution

Attached is a SQL query that can be run directly against the SEM5 database via SQL Management Studio or embedded in a spreadsheet using an ODBC connector that will pull the information and also include group affiliation.