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

I need an SQL query for nodes that update fail in last 7 days

Hello.

 

I need an SQL query that show me the nodes whit update fails in the last seven days and only de clients in a group folder.

 

Could you help me?

I have found a query like the following, but I have not been able to modify it by referring to the parameter corresponding to the status of the update

 

Extract a list of computer where the on-access scanner is inactive

sqlcmd -E -S .\sophos -d sophos52 -Q "select name, savonaccess from computersanddeletedcomputers where managed=1 and savonaccess=0" -w 1000 -o c:\onaccessIsOff.txt
Extract the computer name, HIPS detection and file path for a computer

 

Thanks.

 



This thread was automatically locked due to age.
  • Hello RaulManteca Fernandez,

    I'm not sure I understand what exactly you mean by update fails in the last seven days. Do you mean endpoints that have encountered an update error in the last seven days, regardless whether they are now up-to-date or not?

    Christian