Thread Info
  • State Suggested Answer
  • Locked Locked
  • Replies 2 replies
  • Answers 1 answer
  • Subscribers 1 subscriber
  • Views 11590 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Export exemption device list including comment

Azwan

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


This thread was automatically locked due to age.
  • 0
    Hi Sophos Team,

    we are using Sophos 5.22 and i need way to export the exemptions list with comments...

    Is there already a solution?

    best Regards

    Mathias
  • 0
    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
Unfiltered HTML