AnsweredAssumed Answered

error_query

Question asked by La-Qa on Jan 30, 2017
Latest reply on Jan 30, 2017 by JAllen11

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

Outcomes