DX Unified Infrastructure Management

Good Morning,

I'm trying to create a query to get the value recorded in a QOS, the aws probe, but I can only display the table with all the data of QOS.

I can not figure out how to get the last value

“select * from dbo.S_QOS_DATA where qos = 'QOS_FILEREADTIME' and source 'S3Watcher.moodlefaeusf.s3TestDocument.txt' and target = 'file transfer time'

Hi,

You'll need to dig around the actual data tables. Something like this:

select samplevalue from rn_qos_data_0003 where table_id = 1 and sampletime = (select max(sampletime)  from rn_qos_data_0003 where table_id = 1)

 -jon

Jon, worked, Put in SELECT * FROM S_QOS_DATA not appear for all records I find the table_id and RN_QOS_DATA the target I need, how can I filter by robot or probe?

select * from dbo.S_QOS_DATA where qos = 'QOS_FILEREADTIME' 

Finally! unable to get the information with the query below and value with the query you gave me

Very much thank you for the help