Thread Info
  • State Suggested Answer
  • Locked Locked
  • Replies 1 reply
  • Answers 1 answer
  • Subscribers 6 subscribers
  • Views 2193 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

Database Schema

lonpm2 Phil

Hi

we have just started using Sophos Safeguard

I have been asked to create management reports from it for presentation at Operational Security Meetings

The original consultant suggested that the best way to accomplish this was direct from the database possibly by using Business Objects or similar

I've approached the Business Objects person in the business and asked if this is feasible and I was asked for details of the schema and the organisation of the data within the database.

My knowledge of SQL is none

Has anyone seen any documentation or managed to get these details

in which case would you be prepared to share?

 

thanks



This thread was automatically locked due to age.
  • 0

    Hi - You can get basic reports from the Inventory function that may suit?

     

    This "report" includes...

    Encryption type (BL, FV2, Sophos), hostname, OS, POA, Encrypted drives, Unencrypted drives, Last server contact, Last policy received, Modification date and parent DSN.

     

    You can sort by each column heading.

     

    You can also export this view so can then customise it within Excel/CSV editor of choice.

     

    To produce this view of ALL your encrypted machines.

    On the Users and Computers tab - Select the root (or the AD root) on the left.

    On the right select the Inventory tab - Leave computername blank and click Search.

    Ta da - report. Basic but it might do?

     

    To export....

    Select one machine in the inventory (any - doesn't matter) - Without doing this the options we need are greyed out.

    File and Print Preview....(NOT Print)

    Click OK on the "calculating print area..." message. 

    A separate window will now open - Titled Inventory Report.

    On THIS window select Export Document....

    You can now select a PDF, CSV etc....

     

    I use this data for all my reports - It does show enough for my needs without having the hassle of logging onto the secure SQL server to run a query and then to export....

    I produced a report each month with this data so staff could see progression. Made some pretty charts in Excel with it for added "wooo" factor.

    Hope this helps and might suit your needs?

Unfiltered HTML