Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 3 replies
  • Subscribers 1 subscriber
  • Views 8922 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 Enterprise Console - create an own Template Reports

psc

Hello,

I have a question about the report function. Is it possible to create an own Report template?
per example i want to see all protected computers of a group listed with hostname.
the predefined template creates only a list with the numbers or percentage of all computers in the Sophos Enterprise Manager.

Thank you in advance for your help.

psc

in German:

Hallo zusammen,

Ich würde gerne ein eigenes Template erstellen, wo ich definieren kann, welche Dinge ich abfragen möchte...
ist dies möglich oder nicht?
Die vordefinierten Templates bieten ja nicht so viel Möglichkeiten, diese nach eigenen Wünschen anzupassen. Über euere Rückmeldung freue ich mich.

Besten Dank und Gruss
psc

:27741


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

    Here is a starter for you using without using the reporting interface:

    SELECT c.ComputerName, c.SAVVersion, gp.PathAndName

    FROM dbo.ComputerListData2 as c

    INNER JOIN dbo.GroupPathAndNameTable() as gp

    ON c.GroupID = gp.GroupID

    WHERE c.Managed = 1

    ORDER BY gp.PathAndName

    That will get you:

    Computer Name, SAV Version and SEC Group.

    You can add lots of different info from the ComputerListData2 view, if you look at the columns.  I would suggest installing SQL Server Management Studio to take a look.

    You could extend the WHERE clause for a specific group, e.g.

    SELECT c.ComputerName, c.SAVVersion, gp.PathAndName

    FROM dbo.ComputerListData2 as c

    INNER JOIN dbo.GroupPathAndNameTable() as gp

    ON c.GroupID = gp.GroupID

    WHERE c.Managed = 1

    and

    gp.PathAndName ='Servers\2003\Exchange'

    ORDER BY c.ComputerName

    For example.

    Hope it helps.

    Regards,

    Jak

    :27747
Reply
  • 0

    Here is a starter for you using without using the reporting interface:

    SELECT c.ComputerName, c.SAVVersion, gp.PathAndName

    FROM dbo.ComputerListData2 as c

    INNER JOIN dbo.GroupPathAndNameTable() as gp

    ON c.GroupID = gp.GroupID

    WHERE c.Managed = 1

    ORDER BY gp.PathAndName

    That will get you:

    Computer Name, SAV Version and SEC Group.

    You can add lots of different info from the ComputerListData2 view, if you look at the columns.  I would suggest installing SQL Server Management Studio to take a look.

    You could extend the WHERE clause for a specific group, e.g.

    SELECT c.ComputerName, c.SAVVersion, gp.PathAndName

    FROM dbo.ComputerListData2 as c

    INNER JOIN dbo.GroupPathAndNameTable() as gp

    ON c.GroupID = gp.GroupID

    WHERE c.Managed = 1

    and

    gp.PathAndName ='Servers\2003\Exchange'

    ORDER BY c.ComputerName

    For example.

    Hope it helps.

    Regards,

    Jak

    :27747
Children
No Data