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

Crystal Reports Help

xdankex

Is there anywhere that has templates for the reporting interface of sophos? i'm trying to use crystal reports for retrieve only "current" or "unresolved" infections. I can't figure out what table or combination of tables that i need to use in order to just retrieve the current infections. i have no problem returning them all... lol i tried limiting it by the last few days but that doson't pull up all of the current and it pulls up the already resolved.

does anyone know how to do this or is my description really confusing?

thank you,

:20637


This thread was automatically locked due to age.
  • 0

    Hi,

    I guess you really want the 'Outstanding' flag rather than inferring the state from the date of threat or status.  On the ThreatInstancesAll view for example there is an Outstanding column, this is 1 for an unresolved threat and 0 for a resolved threat.

    Note: This is also essentially the difference between the Threats and ThreatsArchived tables.

    I suppose you could update the reporting interface view that deals with threats to include the Outstanding column, I think that would be better than joining back onto to the Threats table or the ThreatInstancesAll view on the threatid jut go get this.  At least it would keep the reporting interface views separate from the actual core of the database.

    Regards,

    Jak 

    :20647