Hi Hal If you look at the SIW product there is a Licences Branch which shows all the product keys for (I presume) the products which require a valid license. Some how they have collected the information from the registry and unscrambled it to show the original product key, for example, when you install Windows XP you install with the 25 digit product key supplied by M$, The registry only shows the product serial no. as shown on the first tab of the computer properties dialogue. There are a number of products out there like Magic Jelly bean and Rock XP which will decode this information for you but SIW.exe is the only one that I have found that I can interrogate the resultant report and run from within VFP. I would like to do this using WMI or some other solution. Someone knows how to do it but I cant find that information. Michael Hawthorne's suggestion is both too expensive and does not give the other information required, however it does fit the bill in terms of its ability to reach out over a network and its ability to give information in real time. At the moment I am running SIW to produce a HTML report then selecting the report and parsing it out to various tables, each table has a field which holds the Computer Name, and the data can be viewed for a single computer (What make and Model Mother Board is fitted) or say all the Windows XP Licences/Product Codes for the whole company. But, to collect the data SIW has to be run on each machine in turn then collated on the master computer, so is only accurate at the time it is run therefore needing to be run again if any software is added/removed or changes are made to the hardware. I want to run the whole set of procedures on the master on a daily or weekly basis then notify the manager of any changes. I can reach out and interrogate the registrys remotely but can't decode the product ID's. Hope this is clearer.
Thanks to Michael for his suggestion. Peter -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hal Kaplan Sent: 03 April 2007 16:16 To: ProFox Email List Subject: RE: Computer Hardware and Software Inventory I started doing something similar but the client ran out of interest or money. I am not aware of any tag or hook that relates to licensing. My impression is that the licensing issue is one that must remain secret in order to protect MS's GWA. Or maybe I misunderstood your question. Care to elaborate? B+ HALinNY => -----Original Message----- => From: [EMAIL PROTECTED] => [mailto:[EMAIL PROTECTED] On Behalf Of Peter Hart => Sent: Monday, April 02, 2007 06:55 => To: ProFox Email List => Subject: RE: Computer Hardware and Software Inventory => => Hi => => I am currently using a product called SIW.exe for => inventorying my Small Business Clients computers. I run the => program from within VFP and then collate the data produced => down to Client and Client computer. With the data I can => then check for Valid Licensing and advise accordingly. Also => be able look at the data before travelling to a client when => they have a hardware failure. Then hopefully taking the => right components with me. => => I would prefer to use WMI within VFP to access the data over => the Network thus collating the data on one computer, but I => have come across a stumbling block regards the => License/Product Key information. => => My question is. Has anyone done any work in this area and => can advise me on where to look or better ways of doing this. => => TIA => => Peter Hart => PETER HART COMPUTERS => [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
