# XML Data Extraction

**URL:** <https://forum.kirupa.com/t/xml-data-extraction/329094>\
**Category:** programming\
**Created:** [July 19, 2012, 7:43pm UTC](https://forum.kirupa.com/t/xml-data-extraction/329094 "2012-07-19T19:43:24Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![hogie](https://avatars.discourse-cdn.com/v4/letter/h/90db22/32.png) [@hogie](https://forum.kirupa.com/u/hogie)\
**Post date:** [July 19, 2012, 7:43pm UTC](https://forum.kirupa.com/t/xml-data-extraction/329094/1 "2012-07-19T19:43:24Z")

</div>

I have this XML file and I would like to know how to extrace the info highlighted RED I am using C# or any language will do

Any help or hints of how to pull these values in order to store thin in DB will be appreciated

Thanks

[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000]\<?xmlversion=“1.0” encoding=“ISO-8859-1”?\>[/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000]\<WorkstationNumber=“80033” CompType=“0” Type="[/COLOR][COLOR=red]baseline[/COLOR][COLOR=#000000]" UserDef1=“Skq34"UserDef2=”[/COLOR][COLOR=red]89098[/COLOR][COLOR=#000000]"Userdef3=“76” Comment=“This”\> [/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000]\<Hardware\>[/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] \<Computer\>[/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] \<Name\>[/COLOR][COLOR=red]SPKCDC1A84[/COLOR][COLOR=#000000]\</Name\>[/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] \<Manufacturer\>INTELR\</Manufacturer\>[/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] \<Model\>[/COLOR][COLOR=red]ADRADCPI[/COLOR][COLOR=#000000]\</Model\>[/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] \<ServiceTag /\> [/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] \<BiosName\>AT/ATComp\</BiosName\>[/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] \</Computer\>[/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] \<CPU\>[/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] \<Installed\>2\</Installed\>[/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] \<Vendor\>[/COLOR][COLOR=red]Intel[/COLOR][COLOR=#000000]\</Vendor\>[/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] \<Speed\>[/COLOR][COLOR=red]2400[/COLOR][COLOR=#000000]\</Speed\>[/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] \<Model\>Awardacpi\</Model\>[/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] \<SerialNumber\>000-949-0000\</SerialNumber\>[/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] \<CPUFamily\>15\</CPUFamily\>[/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] \</CPU\>[/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] \<Drive\>[/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] \<Name\>A:\</Name\>[/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] \<Description/\>[/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] \<Capacity\>0\</Capacity\>[/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] \<Free\>0\</Free\>[/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] \<Type\>Removable\</Type\>[/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] \</Drive\>[/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] \<Drive\>[/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] \<Name\>C:\</Name\>[/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] \<Description/\>[/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] \<Capacity\>[/COLOR][COLOR=red]99999[/COLOR][COLOR=#000000]\</Capacity\>[/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] \<Free\>[/COLOR][COLOR=red]8888888[/COLOR][COLOR=#000000]\</Free\>[/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] \<Type\>Fixed\</Type\>[/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] \</Drive\>[/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] \<Drive\>[/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] \<Name\>D:\</Name\>[/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] \<Description/\>[/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] \<Capacity\>[/COLOR][COLOR=red]55555555[/COLOR][COLOR=#000000]\</Capacity\>[/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] \<Free\>[/COLOR][COLOR=red]4444444[/COLOR][COLOR=#000000]\</Free\>[/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] \<Type\>Fixed\</Type\>[/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] \</Drive\>[/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] \<Drive\>[/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] \<Name\>F:\</Name\>[/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] \<Description\>[/COLOR][COLOR=red]DVD\_2345[/COLOR][COLOR=#000000]\</Description\> [/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] \<Capacity\>0\</Capacity\>[/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] \<Type\>Removable\</Type\>[/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] \</Drive\>[/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] \</Hardware\>[/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000]\</Workstation\> [/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=“Courier New”][SIZE=3][COLOR=#000000] [/COLOR][/SIZE][/FONT]  
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT]