There does not seem to be a good place for Webroot information as it pertains to the Kaseya VSA. Here are some SQL scripts that we have found useful in the past couple of days:
(If you are not proficient in SQL then please do not use the following queries. Scripts are provided as is. Use at your own risk)
The Webroot.wrTempData is your "processing" table and you can gauge issues based on the quantity of entries.
select count(*) from webroot.wrtempdata
select * from webroot.wrtempdata order by tempname, tempvalue, creationdate desc
The Webroot.Clients table can give you the status of all systems.
-- status 1 = Installingselect count(*) from webroot.clients where statusid=1
-- status 2 = Installedselect count(*) from webroot.clients where statusid=2
-- status 3 = Installation Failedselect count(*) from webroot.clients where statusid=3
-- status 4 = Uninstall Failedselect count(*) from webroot.clients where statusid=4
-- status 5 = Uninstallingselect count(*) from webroot.clients where statusid=5
Cleaning up orphaned records.
-- Count orphaned clients select count(*) from webroot.clients where id not in(select agentguid from machnametab)
-- Count orphaned clientstatusselect count(*) from webroot.clientstatus where clientid not in(select agentguid from machnametab)
-- If you want to delete themdelete webroot.clients where id not in(select agentguid from machnametab)delete webroot.clientstatus where clientid not in(select agentguid from machnametab)delete webroot.threathistory where clientid not in(select agentguid from machnametab)