Downloading Reports From SOPHOS Central

Question

Hello! 
 I am wanting to download a report from SOPHOS Central to show me all the devices it currently protects and for it to show me the exact Make and Model of the devices as well as the users that are using them. 
 I want to find any older model HP EliteBooks that we have still in the wild and to replace them with newer models but i want SOPHOS to tell me the recently active devices of a particular model. 
 Is there anyway of me doing that? 
 Kind regards 
 Jamie

Qoosh · Answer

Hi Jamie, 
 Thanks for reaching out to the Sophos Community Forum. 
 The default reports in Sophos Central will not have the specific device information you're looking for. If you have a Sophos XDR license however, you can run queries on your devices to gather additional information. The following query would be a good starting place. - Windows PCs inventory asset discovery info 
 This query specifically leverages osquery which Sophos has integrated into XDR to provide a larger data-set to work with. You can find more information on the data available when querying a device using the following document. - Sophos Schema

RichardP · Answer

Do you have the XDR feature? If you do, then you can use the DataLake to poll that data and create a nice table in SQL.

Downloading Reports From SOPHOS Central

Top Replies