XML Data Extraction

programming
1

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]