Software Identification #'s

[Guest_imported]

Within the Software Products table, there is a column for Product ID.&nbsp;&nbsp;This Product ID looks to be unique to each Product Name and Product Version.<br>i.e. -&nbsp;&nbsp;&nbsp;Product Name &quot;A&quot; with Product Version &quot;B&quot; would have Product ID &quot;1&quot;<br>and Product Name &quot;A&quot; with Product Version &quot;C&quot; would have Product ID &quot;2&quot;<br><br>Is this a standard within SMS for all programs and versions?<br>If so, is there a master listing somewhere?<br><br>What I am trying to do is set up collections using Product ID's as identification for software products.<br><br>Following is a couple of Product ID's, Product Names, and Product Versions for comparison.&nbsp;&nbsp;<font color=red>Please reply if you are able to determine if these #'s match what you have in your site.</font><br><br><u>Product ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Product Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Product Version</u><br>246&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Microsoft Office&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;8.0<br>552&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Microsoft Office 2000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;9.1.2719<br>479&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Microsoft Office 2000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;9.0.2617<br>509&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Microsoft Office 2000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;9.0.2719<br>508&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Microsoft Office 2000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;9.0.2609<br>500&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Microsoft Office 2000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;9.0.2601<br>489&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Microsoft Office 2000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;9.0.2717<br>2575&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Visio 2000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;6.00<br>4024&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;WinZip&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;8.0 (3105)<br><br>Any help is greatly appreciated, or any suggestions on another way to track exact software name and versions would help.<br><br>Thanks! <p> <br><a href=mailto: anongod@hotmail.com> anongod@hotmail.com</a><br><a href= > </a><br>"Drawing on my fine command of language, I said nothing."

 

[simonwhitelock]

I have asked the same question - if SMS has a special package ID for each piece of software surely there is a master list somewhere !!! I've looked and found nothing. !!!!!

 

[snyderj]

SMS has three core tables for software: Files, Products, and Inventory.

- The Products table is a list of company name, product name and product version. Each record is given a Product ID. Product information is taken from the inventory file's header. If no information is available then the product ID is assumed to be 0 (zero).

- The Files table is a list of each unique software file name, version, size and Product ID. Each record is given a File ID.

- The Inventory table is a list of clients (SMS Record ID), File ID and file count.

In SMS Admin Console (or WBEM ODBC) you'll see SoftwareProduct, Software File and UnknownFile.

- SoftwareProduct is a view of the SMS Product and Inventory tables.

- SoftwareFile is a view of the SMS File and Inventory tables.

- UnknownFile is a view of the SMS Product and Inventory tables where ProductID = 0.

Hope this helps.