I want to find the SQL instance Name from following WQL query using SCCM. select InstanceName from ServerNetworkProtocolProperty where ProtocolName='sm' But here i am getting output like "Instance = <Instance Name>" ... Here i need only <Instance Name> instead of "Instance = <Instance Name>" .. How can i do trim or exclude the text of "Instance =" Can anyone help me on this .. Note : I want to use only WQL query language Thanks ...

Thread closed, duplicate.Follow me through my blog and Twitter!

Hi, As this is a duplicate post, we will close it, please see the reply in this thread: http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/thread/57ff002b-17ff-4aff-a39d-a2f067c67b2cPlease remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.