Hi everyone;I have a column name called countername it has different values like;% Free SpaceFree MegabytesAvg. Disk sec/TransferWhat i am trying to do place them next to each other in the query; Here is my query; SELECT dbo.vManagedEntity.Path,dbo.vPerformanceRuleInstance.InstanceName,Perf.vPerfHourly.AverageValue,Perf.vPerfHourly.DateTime,dbo.vManagedEntity.DisplayName,dbo.vPerformanceRule.ObjectName,dbo.vPerformanceRule.CounterName, dbo.vManagedEntity.Name FROM Perf.vPerfHourly INNER JOIN dbo.vPerformanceRuleInstance ON Perf.vPerfHourly.PerformanceRuleInstanceRowId = dbo.vPerformanceRuleInstance.PerformanceRuleInstanceRowId INNER JOIN dbo.vManagedEntity ON Perf.vPerfHourly.ManagedEntityRowId = dbo.vManagedEntity.ManagedEntityRowId INNER JOIN dbo.vPerformanceRule ON dbo.vPerformanceRuleInstance.RuleRowId = dbo.vPerformanceRule.RuleRowIdWHERE (dbo.vPerformanceRule.ObjectName = 'Logicaldisk') and CounterName like '%Free%'
Here is the output; Path InstanceName AverageValue DateTime DisplayName ObjectName CounterName NameMYServerName.abc.com L: 94.51095581 00:00.0 Cluster Disk 4 L-Drive Logs LogicalDisk % Free Space Cluster Disk 4 L-Drive LogsMYServerName.abc.com L: 94.51095581 00:00.0 Cluster Disk 4 L-Drive Logs LogicalDisk % Free Space Cluster Disk 4 L-Drive LogsMYServerName.abc.com L: 157648 00:00.0 Cluster Disk 4 L-Drive Logs LogicalDisk Free Megabytes Cluster Disk 4 L-Drive LogsMYServerName.abc.com L: 157648 00:00.0 Cluster Disk 4 L-Drive Logs LogicalDisk Free Megabytes Cluster Disk 4 L-Drive Logs
What i need is something like this; Path InstanceName Free Megabytes % Free SpaceMYServerName.abc.com L: 5000 75
where Free megabytes and % Free Space is next to each other. any input greatly appreciated. Thank you.