MAP 8.0 Need report or query to list Installed Software by Computer Name RRS feed

  • Question

  • I'm trying to create a report or SQL query that will show me the installed software on each computer (as opposed to just listing product totals which is how it is reported in the standard reports). Previously this could be accomplished with the SQL query listed below but now with the schema changes in 8.0 this no longer works.

    Looking for some advice or guidance on how to accomplish this.

    Note: This type of reporting would be used to support SAM engagements and help resolve specific licensing questions and remediation issues. Thank You

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

    FROM products p INNERJOIN unique_devices ud

         ON ud.device_number= p.device_numberORDER BY 1,

    Thursday, December 20, 2012 4:27 PM