Hi,<br/>When running a Windows 2008 server assesment, simply to inventory systems, I get a summary of the installed applications. I know that in the database the information is collected on a per server basis (but it is matched with a UID instead of the server name). My question is how can I display the applications installed on a per server basis or simply put, could anyone provide the required SQL query to perform this?<br/>Thanks in advance<br/>Eran© 2009 Microsoft Corporation. All rights reserved.Sun, 07 Jun 2009 07:40:39 Zb4d6d393-b8a6-4be8-ba76-f6a0acccda9bhttp://social.technet.microsoft.com/Forums/en-US/map/thread/b4d6d393-b8a6-4be8-ba76-f6a0acccda9b#b4d6d393-b8a6-4be8-ba76-f6a0acccda9bhttp://social.technet.microsoft.com/Forums/en-US/map/thread/b4d6d393-b8a6-4be8-ba76-f6a0acccda9b#b4d6d393-b8a6-4be8-ba76-f6a0acccda9bEranatworkhttp://social.technet.microsoft.com/Profile/en-US/?user=EranatworkHi,<br/>When running a Windows 2008 server assesment, simply to inventory systems, I get a summary of the installed applications. I know that in the database the information is collected on a per server basis (but it is matched with a UID instead of the server name). My question is how can I display the applications installed on a per server basis or simply put, could anyone provide the required SQL query to perform this?<br/>Thanks in advance<br/>EranMon, 18 May 2009 14:50:16 Z2009-05-18T14:50:16Zhttp://social.technet.microsoft.com/Forums/en-US/map/thread/b4d6d393-b8a6-4be8-ba76-f6a0acccda9b#0518c7ac-68df-4cc0-9323-95404c4b5a2bhttp://social.technet.microsoft.com/Forums/en-US/map/thread/b4d6d393-b8a6-4be8-ba76-f6a0acccda9b#0518c7ac-68df-4cc0-9323-95404c4b5a2bEranatworkhttp://social.technet.microsoft.com/Profile/en-US/?user=EranatworkWell, I took a deeper look into the SQL db of maps and found a few things.<br/>First, I foudna pretty easy way to perform the SQL query using simply Access 2007.  if anyone wants details I will provide them.<br/>Second, I found that the DB contains much more info than is displayed in the reports. For instance, the SQL assesment is performed any way and the info is in the DB. the assesment is only used to display the info in a comfortable way in an excell sheet but the info itself is there even if you simply run the inventory.<br/>So wjat I have to say is simply look deeper in the db. it is very surprising.<br/>enjoy<br/>EranThu, 21 May 2009 09:11:26 Z2009-05-21T09:11:26Zhttp://social.technet.microsoft.com/Forums/en-US/map/thread/b4d6d393-b8a6-4be8-ba76-f6a0acccda9b#ef8ecf58-8cd8-4908-a0d6-778b671f9e83http://social.technet.microsoft.com/Forums/en-US/map/thread/b4d6d393-b8a6-4be8-ba76-f6a0acccda9b#ef8ecf58-8cd8-4908-a0d6-778b671f9e83Jay Saulshttp://social.technet.microsoft.com/Profile/en-US/?user=Jay%20SaulsYes, there's a lot of data there that's not in the reports.<br/> <p class=MsoListParagraph style="text-indent:-0.25in;margin:0in 0in 0pt 0.5in"><span style="" lang=EN-GB><span style=""><span style="font:7pt 'Times New Roman'">      </span></span></span><span style="font-size:small"><span style="font-family:Calibri"><span style="color:#1f497d" lang=EN-GB>relies on Win32_Product WMI class, which depends on the Windows Installer Provider for WMI being installed on the target machine.  For x64 machines and server machines, this component isn’t installed by default:</span><span style="" lang=EN-GB> <span style="color:#1f497d"><a href="http://msdn.microsoft.com/en-us/library/aa392726(VS.85).aspx#windows_installer_provider">http://msdn.microsoft.com/en-us/library/aa392726(VS.85).aspx#windows_installer_provider</a></span></span></span></span></p> <p class=MsoNormal style="margin:0in 0in 0pt 0.5in"><span style="color:#1f497d" lang=EN-GB><span style="font-size:small"><span style="font-family:Calibri">In version 4.0 of MAP, we’ve rewritten that part of inventory to bypass Win32_Product and interrogate the registry directly to get this data.  So if an application (such as Oracle, for instance) registers itself in the MSI database, then it should show up in a MAP 4.0 report regardless of whether the Windows Installer provider is on the target or not.  </span></span></span></p>Thu, 21 May 2009 15:44:47 Z2009-05-21T15:44:47Zhttp://social.technet.microsoft.com/Forums/en-US/map/thread/b4d6d393-b8a6-4be8-ba76-f6a0acccda9b#69adabd1-f58f-4c58-a659-8723c8d7bc35http://social.technet.microsoft.com/Forums/en-US/map/thread/b4d6d393-b8a6-4be8-ba76-f6a0acccda9b#69adabd1-f58f-4c58-a659-8723c8d7bc35Eranatworkhttp://social.technet.microsoft.com/Profile/en-US/?user=EranatworkHi Jay,<br/>When will version 4.0 will be released?<br/>thanks <br/>Wed, 03 Jun 2009 13:09:54 Z2009-06-03T13:09:54Zhttp://social.technet.microsoft.com/Forums/en-US/map/thread/b4d6d393-b8a6-4be8-ba76-f6a0acccda9b#1bef76c8-c737-49a7-af15-a1864816e674http://social.technet.microsoft.com/Forums/en-US/map/thread/b4d6d393-b8a6-4be8-ba76-f6a0acccda9b#1bef76c8-c737-49a7-af15-a1864816e674Jay Saulshttp://social.technet.microsoft.com/Profile/en-US/?user=Jay%20Sauls<p>Beta should be avaialble mid-June.  You'll see announcements here....</p>Wed, 03 Jun 2009 14:53:41 Z2009-06-03T14:53:41Z