Up to date

Question

All my computers(clients)  are up to date according the Enterprise console. But where can i see which virus(pattern File) is in use by our clients or in the Update manager?  :9025

jak · Accepted Answer

Hi,

Do you mean the actual list of ide files a machine has? They are centrally stored in the database but from SEC they are only visible when you look at the computer details of an individual machine.

As a very broad blanket SQL query which is probably way to expensive unless you really need all of those columns you could run :):

select * from computerlistdata2 as c 
left join idelists as i with (nolock) 
on i.id = c.idelistid
 
 This will get you quite a lot of machine specific information, IDEList being a comma separated list of the ides. Hopefully this gives you something to work with.

Thanks, 
 Jak 
 
 :9035