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

Query Install Errors & Update Errors

Hambone

Using T-SQL, I'd like to be able to query "Install Errors"  and seperately "Update Errors" so that I can easily group computers with similar errors.  For example:  I'd like to pull a list of computers that "need a restart" as an Update error.

Thanks!

:21517


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

    Hi,

    No problem! There isn't a lookup table, the easiest thing might be to just add to the lookup table you construct as and when new errors come in.  I.e. Copy the string as seen in SEC and convert the hex to decimal for the DB lookup.

    Each component managed it's own errors, I know that interms of "source" to "component":

    Source/Component

    SAV=SAV

    ALC=AutoUpdate
    SCF=Firewall
    SDDM=SUM
    SDDMAlert=SUM alerts 

    I assume you're aware of the reporting interface?  Might be worth installing that if it makes a few queries simpler, plus they're more likely to continue working in the future.  The only "lookup" table is the Enumerations table as used by the reporting interface.  This is now installed by default it seems with the SOPHOS50 (SEC 5) database.

    Regards,

    Jak

    :21537
Reply
  • 0

    Hi,

    No problem! There isn't a lookup table, the easiest thing might be to just add to the lookup table you construct as and when new errors come in.  I.e. Copy the string as seen in SEC and convert the hex to decimal for the DB lookup.

    Each component managed it's own errors, I know that interms of "source" to "component":

    Source/Component

    SAV=SAV

    ALC=AutoUpdate
    SCF=Firewall
    SDDM=SUM
    SDDMAlert=SUM alerts 

    I assume you're aware of the reporting interface?  Might be worth installing that if it makes a few queries simpler, plus they're more likely to continue working in the future.  The only "lookup" table is the Enumerations table as used by the reporting interface.  This is now installed by default it seems with the SOPHOS50 (SEC 5) database.

    Regards,

    Jak

    :21537
Children
No Data