policyname and the start time. This however only once per day and policies
hi all can you help me? I just need the policyname and the start time. This however only once per day and policies; SELECT TOP 1000 START AT 1 domain_JobArchive.policyName as "domain_JobArchive.policyName",adjust_timestamp(domain_JobArchive.startTime,7200000 ) as "domain_JobArchive.startTime",adjust_timestamp(domain_JobArchive.endTime,7200000 ) as "domain_JobArchive.endTime" from domain_JobArchive , domain_MasterServer where domain_MasterServer.id = domain_JobArchive.masterServerId and ( (domain_JobArchive.isValid = '1') ) AND ( ( (domain_JobArchive.endTime BETWEEN '137166366798930000' AND '137167230798930000') ) AND ( (domain_JobArchive.policyType IN (40 )) ) AND ( (domain_JobArchive.type IN (0 )) ) AND ( ( (domain_JobArchive.masterServerId IN (1897 )) ) ) ) ORDER BY "domain_JobArchive.startTime" ASC one stepp more but now ein have a Problem with Date. I will start this every day: SELECT domain_JobArchive.policyName as "PolicyName",SUBSTRING(UTCBigIntToNomTime(domain_JobArchive.startTime),1,10) as "StartTime" from domain_JobArchive , domain_MasterServer WHERE domain_MasterServer.id = domain_JobArchive.masterServerId and ( (domain_JobArchive.isValid = '1') ) AND ( ( (domain_JobArchive.endTime BETWEEN '137166366798930000' AND '137167230798930000') ) AND ( (domain_JobArchive.policyType IN (40 )) ) AND ( (domain_JobArchive.type IN (0 )) ) AND ( ( (domain_JobArchive.masterServerId IN (1897 )) ) ) ) GROUP BY PolicyName, StartTime ORDER BY PolicyName ASCSolved2.1KViews0likes4Comments