Export exemption device list including comment

Question

Hi Guys,

As per subject above does anybody have solution or guide for the request, I have use below command exportconfig however the exmption device comment is not listed any other posible ways I can extract the information?. Thanks

Sophos Knowledgebase : 
 http://www.sophos.com/it-it/support/knowledgebase/13111.aspx

Command Example : 
 ExportConfig.exe -type DEVC -policy <policy name> -output C:\savconfdevc.xml :43231

Matze · Answer

Hi Community, 
 
i have created a small script as a workaround. 
The script exports the exempted device list directly from the Sophos database to csv. 
 
Instructions: 
- save the script on Sophos Server 
- edit the SophosDB 
- have fun :-) 
 
---- Script ----- 
 
ECHO ON 
REM Scriptname: SOPHOS_create_devc_exemptionlist 
 
set SophosDB=SOPHOS521 
set sqlcmdfile=temp_sql_cmd.sql 
set csv_file=SOPHOS_create_devc_exemptionlist.csv 
 
echo use %SophosDB%; > %sqlcmdfile% 
echo SELECT DeviceTypeID,Comment,DeviceDescription,DeviceModel,DeviceInstance,DefaultExemptionLevel FROM dbo.ExemptedDevices >> %sqlcmdfile% 
echo go >> %sqlcmdfile% 
 
sqlcmd -E -S .\sophos -i %sqlcmdfile% -h-1 -s";" -w 700 -W -o %csv_file% 
pause