EddyBoi479 · Senior IT Solutions Engineer

Comments

  • Nevermind, have this working now with the below: SELECT d.Clusters.DataCenter.VCenter.DisplayName as vCenterName, d.clusters.DisplayName as ClusterName,d.name as Volume, l.LunID, SUBSTRING(l.CanonicalName,13,24) as SerialNumber, SUBSTRING(l.Name, 0, CHARINDEX(' (', l.Name)) AS Vendor FROM Orion.VIM.Datastores d LEFT JOIN…
    in SWQL Trimming/removing part of a string in a select statement Comment by EddyBoi479 July 2025
Default Avatar