Can someone help me with a query to pull the response time (qos_net_connect) data from the database. I trying to get all the information in an excel sheet and find out the response time of each device over a month.
Ananda Guberan K
qos.qos = 'QOS_NET_CONNECT'
data.table_id = qos.table_id
data.sampletime >= DATEADD(MONTH,-1, getdate())
make sure to fix row 7 to use the correct table
Thanks a lot for the help. However, I am really new to DB and would appreciate if you can give me an idea on what should be in table 7?
if you do query
select r_table from s_qos_definition where name = 'QOS_NET_CONNECT'
You get the value for that
Retrieving data ...