Hello, We need to understand if SCCM 2007 can: Populate list of installed software (including portable software) and installation packages on a client machine. We need the following details for each software found: Vendor Name Software TitleSoftware Package (if applicable)Software versionPath to the Software FolderTime of last usage (optional) Perform search for non-executable files according to defined mask (e.g. crack.txt, serial.txt) Also we need additional information about SCCM DB structure for proper HP Connect It (CIT) sync scenario (SCCM 2007 HP Asset Manager 9.30) modification. In particular please advise the tables and fields where stored information listed above with mapping to client machine and/or user name.

Regarding DB Structure, this is the document you likely want: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=22052 Vendor Name, Software Title, Software Version = yes, that would be in Add/Remove Programs data by default. Path to the Software Folder = a qualified yes: that would be in Software File data, potentially by default--but that is configurable. You'd need to make sure your environment is gathering that data. Time of last usage = a qualified yes: that is Software Metering, you'd need to make sure your environment is gathering the SW Metering data. Not sure what you mean by "software package". If whatever you mean by that is natively available in the registry, in wmi, or a file, then yes. non-exe files: Yes, your environment would need to configure Software Inventory to search for a defined mask, like crack.txt, or serial.*, but yes.Standardize. Simplify. Automate.

Dear Sherry, thank you for the answer - we will check the provided KB article. In regarding "software package" I mean the following: while you have Office 2010 Pro installed it will be nice to have the SCCM to know that it is Office package, but not the separate software titles like Word, Excel, Outlook and so on. Similar example is Adobe Creative Suite which includes Photoshop, Illustrator, Indesign and so on.

That's actually a complex task and what Asset Intelligence (AI) is meant to do. You could also use the information collectio from Add/Remove programs. Note that software inventory does a poor job of this becayse it inventories executables, not applications.Jason | http://blog.configmgrftw.com | Twitter @JasonSandys