AnsweredAssumed Answered

DB Views for QOS data

Question asked by wbdeford on Jul 15, 2015
Latest reply on Jul 15, 2015 by wbdeford

We have run the standard script to create an initial set of views into QOS metrics such that we can run SQL queries like this:


select robot, sampletime, samplevalue from dbo.V_QOS_CPU_USAGE

where robot = 'servername' AND sampletime > '2015-07-09' AND sampletime < '2015-07-10'


Is there a script that can create a separate view for each and every QOS metric that it finds in the DB?