The following sql queries will help to find short evaluation intervals for Computer groups and also Software Policy groups so they can be updated in DSM-Explorer:
For Computer groups run the following query to show Computer Groups using Queries and ordered by evaluation interval:
select
cgd.label AS 'Group name',
cqd.label AS 'Query name',
cgd.eval_freq AS 'Eval Period (secs)',
DATEADD(ss, cgd.last_eval_date_time, '19700101') AS 'Last evaluation'
FROM [mdb].[dbo].[ca_group_def] cgd
INNER JOIN mdb.dbo.ca_query_def cqd
ON cgd.query_uuid = cqd.query_uuid
order by cgd.eval_freq
For Software Policy groups run the following query to show Software Policies linked to Computer Groups with Query and ordered by evaluation interval:
select swp.name as 'Software Policy name',
swp.qevalrate as 'Software Policy evaluation interval',
cgd.label as 'Linked Computer Group',
DATEADD(ss, swp.qevaltime, '19700101') AS 'Last evaluation'
from usd_job_cont swp
INNER JOIN mdb.dbo.ca_group_def cgd
ON cgd.group_uuid = swp.qtemplfold
where cgd.query_uuid <> 0
order by swp.qevalrate