Need some help writing a VBS script

[bisk]

I have been tasked with doing the cost recovery for my company's Terminal Server users, this is how I have planned on doing this. I was thinking of writing a VBS script to read in the following XML file and list all of the users in the Set and then count the number of users in that set (if you think there’s a better way to layout the file, please say so).

XML File
<Recoup>
<Set Name=”Head Office”>
<Group Name=”domain\ho users” />
<Group Name=”domain2\ho remote users” />
</Set>
<Set Name=”Branch”>
<Group Name=”domain\branch users” />
<Group Name=”domain2\mobile branch users” />
</Set>
</Recoup>

Output in Excel File
User Name Set Name
John Doe Head Office
Jane Doe Head Office
. .
. .
. .
User 2 Head Office
Billy User Branch
. .
. .
. .
Don Hall Branch


Total Head Office users – 100
Total Branch users - 150