Hello Team
referring to the following thread, im getting an error while running the following query. can anyone pl s help
CA UIM Database
select a.customer
,a.source
,a.Date2
,CONVERT(DECIMAL(10,2),a.cpu) as cpu
,CONVERT(DECIMAL(10,2),b.mem) as memory
from
(
SELECT cpu.origin as customer
,cpu.source as source
,CONVERT(char(8), cast(cpu.sampletime as datetime), 112) as Date2
,avg(cpu.samplevalue) as cpu
FROM [CA_UIM].[dbo].[V_QOS_CPU_USAGE] CPU
where CPU.origin = 'rc82_phub'
group by CONVERT(char(8), cast(cpu.sampletime as datetime), 112), cpu.source,cpu.origin
) a
full join
(
SELECT mem.origin as customer
,mem.source as source
,CONVERT(char(8), cast(mem.sampletime as datetime), 112) as Date2
,avg(mem.samplevalue) as mem
FROM [CA_UIM].[dbo].[V_QOS_MEMORY_PHYSICAL_PERC] mem
where mem.origin = 'rc82_phub'
group by CONVERT(char(8), cast(mem.sampletime as datetime), 112), mem.source,mem.origin
) b on a.customer = b.customer and a.source = b.source and a.date2 = b.date2
order by a.date2 desc