locked
Inventory report per computer RRS feed

  • Question

  • Hi,

    I'm trying to get a list of all computers and the s/w installed on them using MS MAP so I can import the data into our companies' software assett management system.

    I've generated a report using the Inventory Summary Results > Computers section and I get 2 reports "InventoryResults" and "HardwareAndSoftwareSummary" but neither of these list the software on each computer.

    I was expecting a spreadsheet with thousands of rows with each listing an application:

    Hostname | Application | Version | etc

    Is this possible with MS MAP?

    Thanks,
    Paul

     

     

    Wednesday, June 29, 2011 10:13 AM

All replies

  • I’m sorry to say that there is currently no report in MAP that produces a list of installed software by machine.  If you feel comfortable with SQL Server, you can run this custom query to get a list of all products by host name. I should warn you, depending on the number of machines and products inventoried, this could return millions of rows.

     

    From SQL Server Management Studio, run this query:

     

    SELECT dbo.GetDeviceNameForDisplay(p.device_number) [Computer Name], p.caption

      FROM products p INNER JOIN unique_devices ud

          ON ud.device_number = p.device_number ORDER BY 1, p.name

    Thanks

    Wednesday, June 29, 2011 4:24 PM