Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 8 replies
  • Subscribers 1 subscriber
  • Views 20712 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

Sophos SQL\ DB Query - Sophos EC 51

FK

Hi All,

need to find and list what applications has been allowed for a particular Group. I Couldn't find/ Guess which table is holding the Application Control information. Any help is appreciated a lot.

Thank you in Advance AK

:32683


This thread was automatically locked due to age.
Parents
  • 0

    HI,

    It's in the "Enumerations" table.  With SEC 5.0+ it's installed by default, prior to that installing the Sophos Reporting Interface will add it:

    So for this one:

    SELECT * FROM [dbo].[Enumerations] where EnumID = 17

    Will get you what you want.  If you're now wondering about 17, I just had a scan through the table :)

    Regards,

    Jak

    :33349
Reply
  • 0

    HI,

    It's in the "Enumerations" table.  With SEC 5.0+ it's installed by default, prior to that installing the Sophos Reporting Interface will add it:

    So for this one:

    SELECT * FROM [dbo].[Enumerations] where EnumID = 17

    Will get you what you want.  If you're now wondering about 17, I just had a scan through the table :)

    Regards,

    Jak

    :33349
Children
No Data