XML file --> report format ? 2

[bristolxyz]

Here's my question...prob an easy and silly one.. but... how do I get this data to display in a report, or better yet, suppose THIS DATA is an xml file...suppose I have MANY of these, about 200 of them, how could I get a "report" based on selectable "tags" out of multiple xml files?
I'm keen on HTML but lost here..

<?xml version=&quot;1.0&quot; encoding=&quot;ISO-8859-1&quot; ?>
- <Workstation Number=&quot;853493&quot; CompType=&quot;0&quot; Type=&quot;baseline&quot; AuditDate=&quot;20031202121554&quot; AuditVersion=&quot;6.0.260&quot; AuditXMLVersion=&quot;6.0.0&quot; WorkstationGuid=&quot;14ECA7AA-9873-406B-8A8E-2C6D8305DC7A&quot;>
- <Hardware>
- <Computer>
<Name>ITOFFICE</Name>
<Manufacturer>Dell Computer Corporation</Manufacturer>
<Model>OptiPlex GX260</Model>
<ServiceTag>4KTH921</ServiceTag>
<BiosName>AT/AT COMPATIBLE</BiosName>
<BiosDate>09/24/02</BiosDate>
</Computer>
- <CPU>
<Installed>1</Installed>
<Vendor>Intel</Vendor>
<Speed>2660</Speed>
<Model>Pentium IV</Model>
<SerialNumber />
<CPUFamily>15</CPUFamily>
<CPUModel>2</CPUModel>
<CPUStepping>7</CPUStepping>
<CPUVendorInfo>Intel(R) Pentium(R) 4 CPU 2.66GHz</CPUVendorInfo>
</CPU>
- <Drive>
<Name>A:</Name>
<Description />
<SerialNumber>0000-0000</SerialNumber>
<Capacity>1457664</Capacity>
<Free>888320</Free>
<FileSystem>FAT</FileSystem>
<Type>Removable</Type>
<Path />
</Drive>
- <Drive>
<Name>C:</Name>
<Description>DRIVE_C</Description>
<SerialNumber>F0A9-50F4</SerialNumber>
<Capacity>20809957376</Capacity>
<Free>9452527616</Free>
<FileSystem>NTFS</FileSystem>
<Type>Fixed</Type>
<Path />
</Drive>
- <Drive>
<Name>D:</Name>
<Description />
<SerialNumber />
<Capacity>0</Capacity>
<Free>0</Free>
<FileSystem />
<Type>CDROM</Type>
<Path />
</Drive>
- <PhysicalDrive>
<Description>CD-ROM Drive</Description>
<Name>SAMSUNG CD-R/RW SW-240B</Name>
<Manufacturer>(Standard CD-ROM drives)</Manufacturer>
<DriverVersion>5.1.2535.0</DriverVersion>
<DriverDate>7-1-2001</DriverDate>
<DriverProvider>Microsoft</DriverProvider>
</PhysicalDrive>
- <PhysicalDrive>
<Description>Disk drive</Description>
<Name>Maxtor 6E020L0</Name>
<Manufacturer>(Standard disk drives)</Manufacturer>
<DriverVersion>5.1.2535.0</DriverVersion>
<DriverDate>7-1-2001</DriverDate>
<DriverProvider>Microsoft</DriverProvider>
</PhysicalDrive>

 

[vbajock]

Are you adept at coding VBA in Access or something like it?

 

[sedj]

If you use XSLT, you can create an HTML document from the xml data source.

 

[bristolxyz]

Actually, I'm trying to do AUDITS on our computers. I've looked at several software packages such as TrackIT! and it's just too expensive to justify. I have the capability to pull the data regarding each computer into an XML file, but a seperate file for each computer. Not all of teh computers are on teh network, so network scanning is not an option. I have a floppy that I use to extract the data, problem is, it puts it in an XML format...

Anyone have any suggestions, (Or know of a FREE and unlimited auditing software)?
Regards

 

[harebrain]

I'm with sedj: look into XSLT. You can find James Clark's xt processor on the Web. (blnz.com/xt) Then, with a simple batch file, you can run all your XML files against the same XSL transform to produce a nice HTML table for a report. The batch file would look like:

xt audit1.xml report.xsl
xt audit2.xml report.xsl
xt audit3.xml report.xsl
...

XSL can be a little intimidating, but your needs are rather simple. For a tutorial, try zvon.org.