justin.hannan

SDP Table Querying Server Disks

Discussion created by justin.hannan on Oct 28, 2009
Latest reply on Nov 14, 2009 by guttorm.husveg
Hi

I'm trying to populate a SDP table object with % used QOS data from server file systems. I've got this query, which kind of works OK'ish

SELECT     TOP (8) RN_QOS_DATA_0012.samplevalue, S_QOS_DATA.target
FROM         S_QOS_DATA INNER JOIN
                      RN_QOS_DATA_0012 ON S_QOS_DATA.table_id = RN_QOS_DATA_0012.table_id
WHERE     (S_QOS_DATA.source = servername)
ORDER BY RN_QOS_DATA_0012.sampletime DESC

But does anyone have anything a bit cleaner, where you can put just the server name in and it returns the last sample value for all of a servers monitored disks, rather than having to add the number of disks to the TOP statement etc?

Thanks

Outcomes