Pulling specific information from XML file

1

I have been trying to figure out a good way to get specific text from an XML document and have run into a roadblock. There may be a different approach but I’m trying to extract data from an XML document for an analysis. There is an XML file created by Dell Command Update app that lists all the current drivers and versions for the system (Below is the data in the XML). I’m trying to get an analysis that extracts the quoted text after “display=” and the quoted text after “packageVersion=” in the section following the “<Application” field for each line. I have a relevance that sorta works but breaks once it gets to the BIOS line because the “preceding text of first “packageVersion=”” in my relevance does not exist on that line.

Below is the relevance I have so far.

(following text of first “display=” of preceding text of first “inboxDriver=” of it of following text of first “<Application” of it & ": " & following text of first “version=” of preceding text of first “packageVersion=” of it of following text of first “<Application” of it) of substrings separated by “<Device” whose (it contains “<Application” ) of concatenation “” of lines of file “C:\Inventory.xml”

Below is the content of the XML file I’m querying. If anyone knows a better way to extract this data please let me know, as I’m at a loss.

<?xml version="1.0" encoding="UTF-16"?>

    	
    <SVMInventory lang="en" schemaVersion="1.0" timeStamp="2023-09-11T10:09:05" invcolVersion="11.0.6.0">
    	<OperatingSystem osVendor="Microsoft" osCode="WIN" osArch="x64" majorVersion="10" minorVersion="0" spMajorVersion="0" spMinorVersion="0" buildNumber="22621"/>
    	<System systemID="0C0B" TPMmeasurementsOn="false"/><Device vendorID="8086" deviceID="A7A1" subDeviceID="0C0B" subVendorID="1028" bus="0" device="2" function="0" display="Intel(R) Iris(R) Xe Graphics"><Application componentType="DRVR" version="31.0.101.4502" packageVersion="31.0.101.4502" display="Intel(R) Iris(R) Xe Graphics Driver" inboxDriver="false"/></Device>
    	<Device vendorID="8086" deviceID="A71E" subDeviceID="0C0B" subVendorID="1028" bus="0" device="13" function="0" display="Intel(R) USB 3.20 eXtensible Host Controller - 1.20 (Microsoft)"><Application componentType="DRVR" version="10.0.22621.1928" packageVersion="10.0.22621.1928" display="Intel(R) USB 3.20 eXtensible Host Controller - 1.20 (Microsoft) Driver" inboxDriver="true"/></Device>
    	<Device vendorID="8086" deviceID="51F1" subDeviceID="4090" subVendorID="8086" bus="0" device="20" function="3" display="Intel(R) Wi-Fi 6E AX211 160MHz"><Application componentType="DRVR" version="22.230.0.8" packageVersion="0" display="Intel(R) Wi-Fi 6E AX211 160MHz Driver" inboxDriver="false"/></Device>
    	<Device vendorID="8086" deviceID="AE50" subDeviceID="1028" subVendorID="0C0B" bus="0" device="0" function="0" display="Intel Smart Sound Technology for USB Audio"><Application componentType="DRVR" version="10.29.0.8719" packageVersion="0" display="Intel Smart Sound Technology for USB Audio Driver" inboxDriver="false"/></Device>
    	<Device vendorID="8086" deviceID="A76E" subDeviceID="0C0B" subVendorID="1028" bus="0" device="7" function="0" display="PCI Express Root Port"><Application componentType="DRVR" version="10.0.22621.1778" packageVersion="10.0.22621.1778" display="PCI Express Root Port Driver" inboxDriver="true"/></Device>
    	<Device vendorID="8086" deviceID="09AB" subDeviceID="0000" subVendorID="0000" bus="0" device="6" function="0" display="Intel RST VMD Managed Controller 09AB"><Application componentType="DRVR" version="19.5.1.1040" packageVersion="0" display="Intel RST VMD Managed Controller 09AB Driver" inboxDriver="false"/></Device>
    	<Device vendorID="8086" deviceID="0222" subDeviceID="1028" subVendorID="0C0B" bus="0" device="0" function="0" display="Intel Smart Sound Technology OED"><Application componentType="DRVR" version="10.29.0.8719" packageVersion="0" display="Intel Smart Sound Technology OED Driver" inboxDriver="false"/></Device>
    	<Device vendorID="8086" deviceID="51EF" subDeviceID="0C0B" subVendorID="1028" bus="0" device="20" function="2" display="Intel(R) Shared SRAM - 51EF"><Application componentType="DRVR" version="10.1.36.7" packageVersion="10.1.36.7" display="Intel(R) Shared SRAM - 51EF Driver" inboxDriver="false"/></Device>
    	<Device vendorID="8086" deviceID="51A4" subDeviceID="0C0B" subVendorID="1028" bus="0" device="31" function="5" display="Intel(R) SPI (flash) Controller - 51A4"><Application componentType="DRVR" version="10.1.36.7" packageVersion="10.1.36.7" display="Intel(R) SPI (flash) Controller - 51A4 Driver" inboxDriver="false"/></Device>
    	<Device vendorID="8086" deviceID="51CA" subDeviceID="0C0B" subVendorID="1028" bus="0" device="31" function="3" display="Intel Smart Sound Technology BUS"><Application componentType="DRVR" version="10.29.0.8719" packageVersion="0" display="Intel Smart Sound Technology BUS Driver" inboxDriver="false"/></Device>
    	<Device vendorID="8086" deviceID="51E3" subDeviceID="0C0B" subVendorID="1028" bus="0" device="22" function="3" display="Intel(R) Active Management Technology - SOL (COM3)"><Application componentType="DRVR" version="2251.4.1.0" packageVersion="0" display="Intel(R) Active Management Technology - SOL (COM3) Driver" inboxDriver="false"/></Device>
    	<Device vendorID="8086" deviceID="15EF" subDeviceID="0000" subVendorID="8086" bus="1" device="0" function="0" display="PCI Express Upstream Switch Port"><Application componentType="DRVR" version="10.0.22621.1778" packageVersion="10.0.22621.1778" display="PCI Express Upstream Switch Port Driver" inboxDriver="true"/></Device>
    	<Device vendorID="8086" deviceID="AE30" subDeviceID="1028" subVendorID="0C0B" bus="0" device="0" function="0" display="Intel Smart Sound Technology for Bluetooth Audio"><Application componentType="DRVR" version="10.29.0.8719" packageVersion="0" display="Intel Smart Sound Technology for Bluetooth Audio Driver" inboxDriver="false"/></Device>
    	<Device vendorID="8086" deviceID="51E0" subDeviceID="0C0B" subVendorID="1028" bus="0" device="22" function="0" display="Intel(R) Management Engine Interface #1"><Application componentType="DRVR" version="2306.4.3.0" packageVersion="0" display="Intel(R) Management Engine Interface #1 Driver" inboxDriver="false"/></Device>
    	<Device vendorID="8086" deviceID="51E8" subDeviceID="0C0B" subVendorID="1028" bus="0" device="21" function="0" display="Intel(R) Serial IO I2C Host Controller - 51E8"><Application componentType="DRVR" version="30.100.2237.26" packageVersion="30.100.2237.26" display="Intel(R) Serial IO I2C Host Controller - 51E8 Driver" inboxDriver="false"/></Device>
    	<Device vendorID="8086" deviceID="A71D" subDeviceID="0C0B" subVendorID="1028" bus="0" device="4" function="0" display="Intel(R) Innovation Platform Framework Processor Participant"><Application componentType="DRVR" version="1.0.11201.31046" packageVersion="1.0.11201.31046" display="Intel(R) Innovation Platform Framework Processor Participant Driver" inboxDriver="false"/></Device>
    	<Device vendorID="8086" deviceID="A708" subDeviceID="0C0B" subVendorID="1028" bus="0" device="0" function="0" display="PCI standard host CPU bridge"><Application componentType="DRVR" version="10.0.22621.1" packageVersion="10.0.22621.1" display="PCI standard host CPU bridge Driver" inboxDriver="true"/></Device>
    	<Device vendorID="8086" deviceID="A73F" subDeviceID="0C0B" subVendorID="1028" bus="0" device="7" function="1" display="PCI Express Root Port"><Application componentType="DRVR" version="10.0.22621.1778" packageVersion="10.0.22621.1778" display="PCI Express Root Port Driver" inboxDriver="true"/></Device>
    	<Device vendorID="0000" deviceID="0000" subDeviceID="0000" subVendorID="0000" bus="0" device="13" function="2" display="USB4(TM) Host Router (Microsoft)"><Application componentType="DRVR" version="10.0.22621.1928" packageVersion="0" display="USB4(TM) Host Router (Microsoft) Driver" inboxDriver="true"/></Device>
    	<Device vendorID="8086" deviceID="51A3" subDeviceID="0C0B" subVendorID="1028" bus="0" device="31" function="4" display="Intel(R) SMBus - 51A3"><Application componentType="DRVR" version="10.1.36.7" packageVersion="10.1.36.7" display="Intel(R) SMBus - 51A3 Driver" inboxDriver="false"/></Device>
    	<Device vendorID="8086" deviceID="281F" subDeviceID="0000" subVendorID="0000" bus="2" device="1" function="0" display="HD Audio Driver for Display Audio"><Application componentType="DRVR" version="31.0.101.4502" packageVersion="0" display="HD Audio Driver for Display Audio Driver" inboxDriver="false"/></Device>
    	<Device vendorID="8086" deviceID="281F" subDeviceID="0000" subVendorID="0000" bus="2" device="21" function="0" display="HD Audio Driver for Display Audio"><Application componentType="DRVR" version="31.0.101.4502" packageVersion="0" display="HD Audio Driver for Display Audio Driver" inboxDriver="false"/></Device>
    	<Device vendorID="8086" deviceID="281F" subDeviceID="0101" subVendorID="8086" bus="0" device="0" function="0" display="HD Audio Driver for Display Audio"><Application componentType="DRVR" version="31.0.101.4502" packageVersion="0" display="HD Audio Driver for Display Audio Driver" inboxDriver="false"/></Device>
    	<Device vendorID="8086" deviceID="51FC" subDeviceID="0C0B" subVendorID="1028" bus="0" device="18" function="0" display="Intel(R) Integrated Sensor Solution"><Application componentType="DRVR" version="3.1.0.4589" packageVersion="0" display="Intel(R) Integrated Sensor Solution Driver" inboxDriver="false"/></Device>
    	<Device vendorID="10EC" deviceID="0289" subDeviceID="0C0B" subVendorID="1028" bus="0" device="0" function="0" display="Realtek(R) Audio"><Application componentType="DRVR" version="6.0.9514.1" packageVersion="0" display="Realtek(R) Audio Driver" inboxDriver="false"/></Device>
    	<Device vendorID="8086" deviceID="15F0" subDeviceID="0000" subVendorID="8086" bus="3" device="0" function="0" display="Intel(R) USB 3.1 eXtensible Host Controller - 1.10 (Microsoft)"><Application componentType="DRVR" version="10.0.22621.1928" packageVersion="10.0.22621.1928" display="Intel(R) USB 3.1 eXtensible Host Controller - 1.10 (Microsoft) Driver" inboxDriver="true"/></Device>
    	<Device vendorID="8086" deviceID="A77F" subDeviceID="0C0B" subVendorID="1028" bus="0" device="14" function="0" display="Intel RST VMD Controller A77F"><Application componentType="DRVR" version="19.5.1.1040" packageVersion="19.5.1.1040" display="Intel RST VMD Controller A77F Driver" inboxDriver="false"/></Device>
    	<Device vendorID="8086" deviceID="A77D" subDeviceID="0C0B" subVendorID="1028" bus="0" device="10" function="0" display="Intel(R) Platform Monitoring Technology Driver"><Application componentType="DRVR" version="10.0.22621.1485" packageVersion="10.0.22621.1485" display="Intel(R) Platform Monitoring Technology Driver Driver" inboxDriver="false"/></Device>
    	<Device vendorID="8086" deviceID="51ED" subDeviceID="0C0B" subVendorID="1028" bus="0" device="20" function="0" display="Intel(R) USB 3.10 eXtensible Host Controller - 1.20 (Microsoft)"><Application componentType="DRVR" version="10.0.22621.1928" packageVersion="10.0.22621.1928" display="Intel(R) USB 3.10 eXtensible Host Controller - 1.20 (Microsoft) Driver" inboxDriver="true"/></Device>
    	<Device vendorID="8086" deviceID="A74F" subDeviceID="0C0B" subVendorID="1028" bus="0" device="8" function="0" display="Intel(R) GNA Scoring Accelerator module"><Application componentType="DRVR" version="3.0.0.1457" packageVersion="0" display="Intel(R) GNA Scoring Accelerator module Driver" inboxDriver="false"/></Device>
    	<Device vendorID="8086" deviceID="519D" subDeviceID="0C0B" subVendorID="1028" bus="0" device="31" function="0" display="Intel(R) LPC Controller - 519D"><Application componentType="DRVR" version="10.1.36.7" packageVersion="10.1.36.7" display="Intel(R) LPC Controller - 519D Driver" inboxDriver="false"/></Device>
    	<Device vendorID="8086" deviceID="15EF" subDeviceID="0000" subVendorID="8086" bus="2" device="2" function="0" display="PCI Express Downstream Switch Port"><Application componentType="DRVR" version="10.0.22621.1778" packageVersion="10.0.22621.1778" display="PCI Express Downstream Switch Port Driver" inboxDriver="true"/></Device>
    	<Device vendorID="8086" deviceID="15EF" subDeviceID="0000" subVendorID="8086" bus="2" device="4" function="0" display="PCI Express Downstream Switch Port"><Application componentType="DRVR" version="10.0.22621.1778" packageVersion="10.0.22621.1778" display="PCI Express Downstream Switch Port Driver" inboxDriver="true"/></Device>
    	<Device vendorID="8086" deviceID="51E9" subDeviceID="0C0B" subVendorID="1028" bus="0" device="21" function="1" display="Intel(R) Serial IO I2C Host Controller - 51E9"><Application componentType="DRVR" version="30.100.2237.26" packageVersion="30.100.2237.26" display="Intel(R) Serial IO I2C Host Controller - 51E9 Driver" inboxDriver="false"/></Device>
    	<Device componentID="159" display="BIOS" impactsTPMmeasurements="true"><Application componentType="BIOS" version="1.6.0" display="BIOS"/></Device>
    	<Device componentID="111952" display="NVMe PM9B1 NVMe Samsung 512GB"><Application componentType="FRMW" version="4630.5039" packageVersion="4630.5039" display="NVMe PM9B1 NVMe Samsung 512GB Firmware" inboxDriver="false"/></Device>
    	<Device pnpID="8087" pnpProductID="0033" componentID="103306" hardwareID="USB\VID_8087&amp;PID_0033&amp;REV_0000" display="Intel(R) Wireless Bluetooth(R)"><Application componentType="DRVR" version="22.230.0.2" packageVersion="22.230.0.2" display="Intel(R) Wireless Bluetooth(R) Driver" inboxDriver="false"/></Device>
    	<Device pnpID="8087" pnpProductID="0033" componentID="103306" hardwareID="USB\VID_8087&amp;PID_0033" display="Intel(R) Wireless Bluetooth(R)"><Application componentType="DRVR" version="22.230.0.2" packageVersion="22.230.0.2" display="Intel(R) Wireless Bluetooth(R) Driver" inboxDriver="false"/></Device>
    	<Device pnpID="INTC" pnpProductID="1078" componentID="105204" hardwareID="ACPI\VEN_INTC&amp;DEV_1078" display="Intel(R) HID Event Filter"><Application componentType="DRVR" version="2.2.2.1" packageVersion="2.2.2.1" display="Intel(R) HID Event Filter Driver" inboxDriver="false"/></Device>
    	<Device pnpID="INTC" pnpProductID="1078" componentID="105204" hardwareID="ACPI\INTC1078" display="Intel(R) HID Event Filter"><Application componentType="DRVR" version="2.2.2.1" packageVersion="2.2.2.1" display="Intel(R) HID Event Filter Driver" inboxDriver="false"/></Device>
    	<Device pnpID="INTC" pnpProductID="1078" componentID="105204" hardwareID="*INTC1078" display="Intel(R) HID Event Filter"><Application componentType="DRVR" version="2.2.2.1" packageVersion="2.2.2.1" display="Intel(R) HID Event Filter Driver" inboxDriver="false"/></Device>
    	<Device pnpID="0BDA" pnpProductID="402E" componentID="103620" hardwareID="USB\VID_0BDA&amp;PID_402E&amp;REV_0001&amp;MI_00" display="Realtek USB Audio"><Application componentType="DRVR" version="6.3.9600.2330" packageVersion="6.3.9600.2330" display="Realtek USB Audio Driver" inboxDriver="false"/></Device>
    	<Device pnpID="0BDA" pnpProductID="402E" componentID="103620" hardwareID="USB\VID_0BDA&amp;PID_402E&amp;MI_00" display="Realtek USB Audio"><Application componentType="DRVR" version="6.3.9600.2330" packageVersion="6.3.9600.2330" display="Realtek USB Audio Driver" inboxDriver="false"/></Device>
    	<Device pnpID="0A5C" pnpProductID="5842" componentID="21505" hardwareID="USB\VID_0A5C&amp;PID_5842&amp;REV_0101&amp;MI_00" display="Dell ControlVault w/o Fingerprint Sensor"><Application componentType="DRVR" version="5.13.10.14" packageVersion="5.13.11.19" display="Dell ControlVault w/o Fingerprint Sensor Driver" inboxDriver="false"/></Device>
    	<Device pnpID="0A5C" pnpProductID="5842" componentID="21505" hardwareID="USB\VID_0A5C&amp;PID_5842&amp;MI_00" display="Dell ControlVault w/o Fingerprint Sensor"><Application componentType="DRVR" version="5.13.10.14" packageVersion="5.13.11.19" display="Dell ControlVault w/o Fingerprint Sensor Driver" inboxDriver="false"/></Device>
    	<Device pnpID="0BDA" pnpProductID="8153" componentID="103219" hardwareID="USB\VID_0BDA&amp;PID_8153&amp;REV_3111" display="Realtek USB GbE Family Controller #2"><Application componentType="DRVR" version="1153.10.20.1104" packageVersion="1153.10.20.1104" display="Realtek USB GbE Family Controller #2 Driver" inboxDriver="false"/></Device>
    	<Device pnpID="0BDA" pnpProductID="8153" componentID="103219" hardwareID="USB\VID_0BDA&amp;PID_8153" display="Realtek USB GbE Family Controller #2"><Application componentType="DRVR" version="1153.10.20.1104" packageVersion="1153.10.20.1104" display="Realtek USB GbE Family Controller #2 Driver" inboxDriver="false"/></Device>
    	<Device componentID="108342" display="WD19TB" serviceTag="XXXXXX"><Application componentType="FRMW" version="01.00.32.01" display="WD19TB Firmware"/></Device>
    	<Device display="STM " componentID="112227"><Application componentType="FRMW" version="1.769.0.0" display="STM " packageVersion="1.769.0.0"/></Device>
    	<Device display="Intel(R) Optane(TM) Memory and Storage Management Component" softwareComponentClassID="SWC\VID8086&amp;SW_RstHSA_19_0"><Application componentType="DRVR" version="19.5.1.1040" display="Intel(R) Optane(TM) Memory and Storage Management Component " packageVersion="19.5.1.1040"/></Device>
    	<Device display="Intel(R) Graphics Command Center" softwareComponentClassID="SWC\101.4502_VEN8086_IGCC"><Application componentType="DRVR" version="31.0.101.4502" display="Intel(R) Graphics Command Center " packageVersion="31.0.101.4502"/></Device>
    	<Device display="Realtek Audio Universal Service" softwareComponentClassID="SWC\VEN_10EC&amp;SID_0001"><Application componentType="DRVR" version="1.0.616.0" display="Realtek Audio Universal Service " packageVersion="1.0.616.0"/></Device>
    	<Device display="Intel(R) iCLS Client" softwareComponentClassID="SWC\PROVIDER_INTEL_COMPONENT_ICLSCLIENT_ES_ONLY"><Application componentType="DRVR" version="1.66.712.0" display="Intel(R) iCLS Client " packageVersion="1.66.712.0"/></Device>
    	<Device display="Realtek Audio Effects Component (USB)" softwareComponentClassID="SWC\VEN_10EC&amp;AID_0002"><Application componentType="DRVR" version="11.0.6000.1043" display="Realtek Audio Effects Component (USB) " packageVersion="11.0.6000.1043"/></Device>
    	<Device display="Waves Audio Effects Component for DO" softwareComponentClassID="SWC\VEN_WAVES&amp;AID_MA12_DO"><Application componentType="DRVR" version="12.2.0.588" display="Waves Audio Effects Component for DO " packageVersion="12.2.0.588"/></Device>
    	<Device display="Intel(R) Dynamic Tuning Technology Device Extension Component" softwareComponentClassID="SWC\VID8086_DTT_1.0"><Application componentType="DRVR" version="9.0.11202.31222" display="Intel(R) Dynamic Tuning Technology Device Extension Component " packageVersion="9.0.11202.31222"/></Device>
    	<Device display="Realtek Asio Component" softwareComponentClassID="SWC\VEN_10EC&amp;ASIO_ID_0001"><Application componentType="DRVR" version="1.0.0.10" display="Realtek Asio Component " packageVersion="1.0.0.10"/></Device>
    	<Device display="Realtek Audio Effects Component" softwareComponentClassID="SWC\VEN_10EC&amp;AID_0001"><Application componentType="DRVR" version="11.0.6000.1096" display="Realtek Audio Effects Component " packageVersion="11.0.6000.1096"/></Device>
    	<Device display="Intel(R) Management Engine WMI Provider" softwareComponentClassID="SWC\06657A6D-FE0F-4C90-8DDA-A1501C74CE4B"><Application componentType="DRVR" version="2303.4.2.0" display="Intel(R) Management Engine WMI Provider " packageVersion="2303.4.2.0"/></Device>
    	<Device display="Intel(R) Dynamic Application Loader Host Interface" softwareComponentClassID="SWC\3C4852D6-D47B-4F46-B05E-B5EDC1AA440E"><Application componentType="DRVR" version="1.42.2023.102" display="Intel(R) Dynamic Application Loader Host Interface " packageVersion="1.42.2023.102"/></Device>
    	<Device display="Intel(R) Wireless Manageability" softwareComponentClassID="SWC\D1D545FE-A4C1-45BD-8C7C-2B90A7C3734A"><Application componentType="DRVR" version="2252.71.74.0" display="Intel(R) Wireless Manageability " packageVersion="2252.71.74.0"/></Device>
    	<Device display="Realtek Hardware Support Application" softwareComponentClassID="SWC\VEN_10EC&amp;HID_0001"><Application componentType="DRVR" version="10.0.22621.1" display="Realtek Hardware Support Application " packageVersion="10.0.22621.1"/></Device>
    	<Device display="Intel(R) Management and Security Application Local Management" softwareComponentClassID="SWC\5DCEB103-DD64-403C-A17C-94FC5F917A9C"><Application componentType="DRVR" version="2302.4.3.0" display="Intel(R) Management and Security Application Local Management " packageVersion="2302.4.3.0"/></Device>
    	<Device display="Intel OED Extension LibPath (by Realtek)" extensionID="{2A1A2071-D20A-43F8-AA82-B6DD10133949}"><Application componentType="DRVR" version="10.35.212.005" display="Intel OED Extension LibPath (by Realtek)" packageVersion="10.35.212.005"/></Device>
    	<Device display="Waves Audio Device Extension" extensionID="{3ED78669-04CF-413C-A8DF-553436CEA20F}"><Application componentType="DRVR" version="1.12.2.134" display="Waves Audio Device Extension" packageVersion="1.12.2.134"/></Device>
    	<Device display="Realtek(R) Audio" extensionID="{C3A63EDD-2D27-4B66-B155-5E94B43D926A}"><Application componentType="DRVR" version="1.0.0.61" display="Realtek(R) Audio" packageVersion="1.0.0.61"/></Device>
    	<Device display="AppUp.IntelOptaneMemoryandStorageManagement" packageFamilyName="AppUp.IntelOptaneMemoryandStorageManagement_8j3eq9eme6ctt"><Application componentType="APAC" version="19.0.1042.0" display="AppUp.IntelOptaneMemoryandStorageManagement" packageVersion="19.0.1042.0"/></Device>
    	<Device display="AppUp.IntelGraphicsExperience" packageFamilyName="appup.intelgraphicsexperience_8j3eq9eme6ctt"><Application componentType="APAC" version="1.100.5180.0" display="AppUp.IntelGraphicsExperience" packageVersion="1.100.5180.0"/></Device>
    	<Device display="AppUp.IntelManagementandSecurityStatus" packageFamilyName="appup.intelmanagementandsecuritystatus_8j3eq9eme6ctt"><Application componentType="APAC" version="2316.5.0.0" display="AppUp.IntelManagementandSecurityStatus" packageVersion="2316.5.0.0"/></Device>
    	<Device display="DellUpdateSupportAssistPlugin" componentID="104763"><Application componentType="APAC" version="0" display="DellUpdateSupportAssistPlugin" packageVersion="0"/></Device>
    	<Device componentID="19098" display="Dell Command | Configure">

    <Application packageVersion="4.9.0.570" componentType="APAC" version="4.9.0.570" display="Dell Command | Configure"/>

      </Device>
    	<Device componentID="23400" display="Dell Command | Update">

    <Application packageVersion="5.0.0" componentType="APAC" version="5.0.0" display="Dell Command | Update"/>

      </Device>
    	<Device componentID="112200" display="Dell_Pair">

    <Application packageVersion="0" componentType="APAC" version="0" display="Dell_Pair"/>

      </Device>
    	<Device componentID="103292" display="Graphics">

    <Application packageVersion="31.0.101.4502" componentType="DRVR" version="31.0.101.4502" display="Graphics"/>

      </Device>
    	<Device componentID="106712" display="Intel Common PPM Package">

    <Application packageVersion="0" componentType="APAC" version="0" display="Intel Common PPM Package"/>

      </Device>
    	<Device componentID="100352" display="Realtek High Definition Audio">

    <Application packageVersion="6.0.9514.1" componentType="DRVR" version="6.0.9514.1" display="Realtek High Definition Audio"/>

      </Device>
    	<Device componentID="111084" display="Dell DBUtil Removal Utility">

    <Application packageVersion="0" componentType="APAC" version="0" display="Dell DBUtil Removal Utility"/>

      </Device>
    	<Device componentID="111201" display="Dell AC Thermal PPkg Driver">

    <Application packageVersion="0" componentType="DRVR" version="0" display="Dell AC Thermal PPkg Driver"/>

      </Device>
    	</SVMInventory>
2

Use the native XML inspectors! Lots of examples in a forum search, this one should be a good starting point Help navigating through and selecting information from an XML document

3

I tried using XML inspectors but it doesn’t seem to work. I don’t know if it’s a formatting issue or what but even when I try to get node names in the debugger it returns “#document” which is why I was using the text values to query.

4

A good place to start is by navigating through the top levels of the document

q: (node names of it, node names of child nodes of it) of xpaths "/" of xml documents of files "c:\temp\test.xml"
A: #document, xml
A: #document, SVMInventory
T: 5.583 ms
I: plural ( string, string )

q: (node names of it, node names of child nodes of it) of xpaths "/SVMInventory" of xml documents of files "c:\temp\test.xml"
A: SVMInventory, OperatingSystem
A: SVMInventory, System
A: SVMInventory, Device
A: SVMInventory, Device

…

If I’m reading correctly, you want the ‘display’ attributes of only the <Application> nodes beneath a <Device> node? That should be something like

q: (node values of attributes "display" of it) of xpaths "/SVMInventory/Device/Application" of xml documents of files "c:\temp\test.xml"
A: Intel(R) Iris(R) Xe Graphics Driver
A: Intel(R) USB 3.20 eXtensible Host Controller - 1.20 (Microsoft) Driver
A: Intel(R) Wi-Fi 6E AX211 160MHz Driver
A: Intel Smart Sound Technology for USB Audio Driver
5

Thanks Jason! I was able to get what I needed after you pointed me in the right direction. I was not using “xpaths” which ended up being the key I was looking for.

1 Like