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

After Shh-Updater QM shows PC's that arnt listed with a virus/spyware

apeeler

Clean up has begun after this mess with the Shh-Updater. I ran a script earlier that would "Awknolodge" PC's that had this alert. It cleared most of them, but i still have about 60 PC's in the list. When i open these individually they are blank. No message.

:32821


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

    HI,

    I think it should fix itself at least within the next 24 hours as the management service runs it's regular purge task and calls:

    UPDATE dbo.ComputersAndDeletedComputers
    SET LastThreatInstanceID = dbo.ComputerLastOutstandingThreatInstanceID( ID )

    I assume that the table ComputersAndDeletedComputers in the database has an id (number) in the LastThreatInstanceID column which has no mathcing threat instance id in the Threats table?

    If you run the SQL:

    SELECT c.Name,c.LastThreatInstanceID, t.Threatname
    FROM [dbo].[ComputersAndDeletedComputers] as c
    left outer join threatinstancesall as t on t.ThreatInstanceID = c.LastThreatInstanceID

    If the ThreatName is null but the LastThreatInstanceID has a number this would be the case.

    Regards,

    Jak

    :32859
Reply
  • 0

    HI,

    I think it should fix itself at least within the next 24 hours as the management service runs it's regular purge task and calls:

    UPDATE dbo.ComputersAndDeletedComputers
    SET LastThreatInstanceID = dbo.ComputerLastOutstandingThreatInstanceID( ID )

    I assume that the table ComputersAndDeletedComputers in the database has an id (number) in the LastThreatInstanceID column which has no mathcing threat instance id in the Threats table?

    If you run the SQL:

    SELECT c.Name,c.LastThreatInstanceID, t.Threatname
    FROM [dbo].[ComputersAndDeletedComputers] as c
    left outer join threatinstancesall as t on t.ThreatInstanceID = c.LastThreatInstanceID

    If the ThreatName is null but the LastThreatInstanceID has a number this would be the case.

    Regards,

    Jak

    :32859
Children
No Data