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

Application Control list

There has to be a way to export a searchable index of all controlled appliactions, along with pertinent details (i.e. category, date added to control, etc.). Within the SEC, if you don't know what category the application is listed under, you can spend a long time clicking and hunting for a specific application. (And let's be honest here, some of the application category assignments are odd.)  This makes it extremely time-consuming to build custom, fine-grained policies or to quickly answer questions on what is allowed and not.

If this cannot be obtained from the database, why not attach a spreadsheet to the monthly update thread and update the spreadsheet instead of listing the new applciations in a forum post?

Come on, Sophos, get your act together on this.  When the COO of a $1B company asks me to block an application, or wants to know if an application is blocked, do you realize how amateurish it looks for me to have to hunt and peck through a console to try to find him an answer?  Sure, I can get the information.  But most IT departments run very thin (including mine) and I simply do not have the time to dedicate to this level of software management.  That's one reason we purchased your products.  So help us out.  You've got to keep this list somewhere, right? I assume you have some sort of change management, where update requests are tracked.  Why not make it public?

:49034


This thread was automatically locked due to age.
Parents
  • Hi,

    Glad that helped a bit, as for the policies, 

    SELECT gp.PathAndName AS [SEC Path],
    p.Name AS [Policy Name],
    PolicyXML
    FROM [dbo].[Policies] as p
    left outer join [dbo].[GroupPolicyMapping] as gpm on gpm.PolicyID = p.ID
    left outer join [dbo].GroupPathAndNameTable() as gp on gp.GroupID = gpm.GroupID
    where p.Type = 7

    Or to allow searching in the XML

    SELECT gp.PathAndName AS [SEC Path],
    p.Name AS [Policy Name],
    cast(p.PolicyXML as nvarchar(max))
    FROM [dbo].[Policies] as p
    left outer join [dbo].[GroupPolicyMapping] as gpm on gpm.PolicyID = p.ID
    left outer join [dbo].GroupPathAndNameTable() as gp on gp.GroupID = gpm.GroupID
    where p.Type = 7
    and cast(p.PolicyXML as nvarchar(max)) like '%internet Explorer 10%'

    Will provide something.

    I'll see if I can fathom a better way to display on a per application basis.

    Regards,

    Jak

    :49080
Reply
  • Hi,

    Glad that helped a bit, as for the policies, 

    SELECT gp.PathAndName AS [SEC Path],
    p.Name AS [Policy Name],
    PolicyXML
    FROM [dbo].[Policies] as p
    left outer join [dbo].[GroupPolicyMapping] as gpm on gpm.PolicyID = p.ID
    left outer join [dbo].GroupPathAndNameTable() as gp on gp.GroupID = gpm.GroupID
    where p.Type = 7

    Or to allow searching in the XML

    SELECT gp.PathAndName AS [SEC Path],
    p.Name AS [Policy Name],
    cast(p.PolicyXML as nvarchar(max))
    FROM [dbo].[Policies] as p
    left outer join [dbo].[GroupPolicyMapping] as gpm on gpm.PolicyID = p.ID
    left outer join [dbo].GroupPathAndNameTable() as gp on gp.GroupID = gpm.GroupID
    where p.Type = 7
    and cast(p.PolicyXML as nvarchar(max)) like '%internet Explorer 10%'

    Will provide something.

    I'll see if I can fathom a better way to display on a per application basis.

    Regards,

    Jak

    :49080
Children
No Data