Endpoint Protection

<o p=""></o> Hi all,
I am looking at a solution to disable USB mass storage devices via an Application and Device Control Policy which I have that policy successfully working. I am planning on applying the policy based on location policy within a group, location members will be based on a subnet range i.e. if the PC is on subnet x they cannot use the USB mass storage device but if they are on subnet y they have access to USB mass storage. This I have work successfully in my lab.

The question I have is one of the requirements to be able to report on what clients are in location x and which are in location y, I have not been able to find a SEPM log report or SEPM report to tell me this, does anyone know if any of the reports can do this?

We are running SEP MR4 Mp2 with SQL database.

Thanks

I don't think you can create a report for location from SEPM

Refer the DB schema reference guide
SQL Database Schema Information and Database Planning for Symantec Endpoint Protection Manager 

Thanks AravindKM I thought I may have to quiry the database directly but I thought I would ask the question of the community first.