OPENXML question for SQL Server I am brand new to OPENXML, and have 90 % of what I want to do working...stuck on this:

&lt;ReportHost name="411.114.42.42"&gt;
  &lt;HostProperties&gt;
    &lt;tag name="HOST_END"&gt;Wed Nov 11 20:48:43 2015&lt;/tag&gt;
    &lt;tag name="LastAuthenticatedResults"&gt;8675309&lt;/tag&gt;
    &lt;tag name="Credentialed_Scan"&gt;true&lt;/tag&gt;
    &lt;tag name="policy-used"&gt;AWT v6&lt;/tag&gt;
    &lt;tag name="ssh-auth-meth"&gt;MyPassword&lt;/tag&gt;
    &lt;tag name="ssh-login-used"&gt;MyLogin&lt;/tag&gt;
    &lt;tag name="local-checks-proto"&gt;ssh&lt;/tag&gt;
    &lt;tag name="host-ip"&gt;411.114.42.42&lt;/tag&gt;
    &lt;tag name="HOST_START"&gt;Wed Nov 11 20:00:01 2015&lt;/tag&gt;
  &lt;/HostProperties&gt;
&lt;/ReportHost&gt;


My Desired results:

Wed Nov 11 20:48:43 2015
8675309
TRUE
AWT v6
MyPassword
MyLogin
ssh
411.114.42.42
Wed Nov 11 20:00:01 2015


I am able to get the name value ("Host_end", etc.), but not the content.

My query:

Select   * 
from OPENXML (@hdoc,'/ReportHost/HostProperties/tag',1)
WITH (
    name varchar (500)
     )


I'd like to stick with OPENXML if at all possible, since I just spent the day learning it and getting to this final step.

Please let me know if I have provided enough info.
You need to query for nodetype 3 to get the element text. I have changed your xpath expression slightly so it just returns the node text

EXEC sp_xml_preparedocument @hdoc OUTPUT, @XmlDocument
Select   [text]
from OPENXML (@hdoc,'/ReportHost/HostProperties/tag/text()',3)