Query Help - Office 97/2000 Sorting

[PulsaMatt]

I was hoping someone could help me out here. This might be simple but im just not seeing it. We have a mix of various versions of Office 97 and Office 2000 and we were looking to write a query that would tell us what computers have what. But I cant seem to get the query to work properly.

When I ask it to sort for a file name with a specific version nothing comes back. When I aske it to look by product name it doesnt sort the resulting list alphabetically so I cant find what I am looking for. I am at a loss, any help would be greatly appreciated.
Matt Laski
Sysadmin, Pulsafeeder Inc.
Dell Inspiron 7500
466 MHz Celeron, 384 MB RAM, 26 GB on 2 HDDs

 

[Droche]

I am unable to query for Office either. What I did was create individual queries (word, excel, etc.) and then export them to a spreadsheet. Then I could look and see who has what. It is tedious, but as of yet I have been unable to find a better way. Check out

http://www.swynk.com

it is a good resource.

-Dennis

 

[PulsaMatt]

I forgot to post it up here until now, but I did figure something out that seems to be a reliable resource (I am confident in the results).

I was routing through the Office directories of both 97 and 2000 and discovered that the "Product Name" was different between the versions. Office 97 shows up as "Microsoft Office" and Office 2000 shows up as "Microsoft Office 2000". So I ran a query using that info and it returned the Office 97 machines.

I did run into a problem just sorting out the Office 2000 machines however. The problem was that we have Outlook 2000 on all of the machines regardless of the rest of the office suite installed. So running a query for Office 2000 returned everything out there.

I suppose I could run a query that would be looking for product name not Microsoft Office ... havent tried that yet, been too swamped lately.

So thats what I have figured out so far I'll let ya know if i come up with anything else.
Matt Laski
Sysadmin, Pulsafeeder Inc.
Dell Inspiron 7500
466 MHz Celeron, 384 MB RAM, 26 GB on 2 HDDs