How to get a computer by computer view of installed software using the MAP toolkit

November 23, 2014

As an Administrator maintaining Windows domains, one of the herculean tasks usually one run into is to make a software asset inventory. There are plenty of excellent software to do the job for you, obviously for some cost.

Here we are suggesting you a cheaper alternative, using Microsoft’s own MAP toolkit. Be ready to sweat a bit, and we are sure you would love the outcome.

The entire write up is copied from Microsoft blog and tested by us for assuring, if you follow the instructions as given, within few hours of time you will have a neat software inventory list.

The original link is here

One of the most frequent questions we get at MAPFDBK@microsoft.com is how to get a list of the software discovered by the MAP toolkit on a computer by computer basis.  Most of the users who ask are using this to help them answer a licensing question but it can be used in a number of other scenarios as well for example Software Asset Management or user profiling for VDI (see http://blogs.technet.com/b/mapblog/archive/2012/07/09/planning-for-desktop-virtualization-with-the-map-toolkit-7-0-4-of-4.aspx).

In MAP 7.0, provided this information through a database view and Microsoft Excel.  The name of the view is InstalledProducts_view.

In MAP 8.0, this view has been renamed to [UT_WinServer_Reporting].[InstalledProductsView].

This view contains several key pieces of information that you can use to do a number of things including:

  • Understand what applications and versions are installed throughout your organization
  • See the Operating Systems on which these apps are running and whether the machine is physical or virtual
  • See who is using the machines on which the apps are running
  • Get important license related information such as processor counts, total cores and logical processor counts

To get started, you will need to open Excel and connect to your local SQL Server database that is storing the MAP data that you want to view.  There are two different ways to connect, depending on the version of SQL Server that you are using.

Using your own SQL Server instance

If you are using your own instance (the non-default MAP install), you will select the Data option on the Excel ribbon and select the ‘From other sources’ option.  Then select ‘From SQL Server’.

image_thumb6

Enter your server name and instance name and click ‘Next’.

image_thumb5

Select the database that contains the data you want and then pick InstalledProducts_view row under ‘Name’ for databases created with MAP 7.0.

For MAP 8.0, use [UT_WinServer_Reporting].[InstalledProductsView].

image_thumb7

You can also add some additional information to help describe the connection.  Then click ‘Finish’ and select the location where you want the query results to populate.

image_thumb9

Using the default (LocalDB) instance

In MAP 7.0, the default database installed moved to SQL Server 2012 LocalDB.  There are a couple of steps that are different than those used in other versions of SQL Server.

First, make sure that you have the SQL Server 2012 Native Client installed.  You can get it from

http://www.microsoft.com/en-us/download/details.aspx?id=29065.

With Excel open and the Data ribbon highlighted, select the ‘From other data sources’ option and select ‘From Data Connection Wizard’

image_thumb12

Select the ‘Other/Advanced’ option.

image_thumb13

Then select the option for SQL Server Native Client 11.0 as highlighted below.  If this option is not available, make sure that you have the native client installed – http://www.microsoft.com/en-us/download/details.aspx?id=29065.

image_thumb15

Next, you enter in the server name.  If you are using the default install the server name will be: (localdb)\maptoolkit.

Set the option in #2 to Use Windows NT Integrated Security

Hit ‘Test Connection’

image_thumb18

If you’ve done it correctly, you will get a success message!

image_thumb21

Then follow the same steps as above where you select the database name and the InstalledProducts_view for 7.0.  For 8.0, use [UT_WinServer_Reporting].[InstalledProductsView].

Populate the results in your spreadsheet!

What do I do next?

Well – that is entirely up to you.  One thing that we like to do is to create a pivot table and drill down into this information. Here is one that I created.  I filtered down the application name to include only those that had SQL Server components.  I could look at this by physical/virtual and by operating system.

Pretty cool – huh!

image_thumb23

As a reminder, here is a link to some valuable MAP community supported content.

Enjoy!

Advertisements

Windows 7 “no internet access” false message

March 11, 2012

We lost the count of discussions initiated through this blog, every time there was another “reason” for this false message with Windows 7. After using Windows 7 more than couple of years time, recently we noticed this false message being an annoyance once again with few of the dell desktop machines we started using at work.

Loads of googling around brought us to a topic which discussed about AVG blocking Windows network awareness service and further dwelling into the topic proved that, any Anti-virus with a built-in firewall capability could indirectly affect the above said service, thus causing “no Internet access” false message. At work we use symantec endpoint as corporate solution and Avast Internet security suite with few client systems which are dominantly used for Oracle development.

Somehow, Symantec end point suite always disliked Oracle forms developer suite(s) and we were forced to switch to Avast suite for those users who are into Oracle development.

Back to the topic, following a tip obtained from google search, we did the following

Avast -> settings -> Troubleshooting-> and checked “load avast services only after loading other services” and bingo! no more false messages, no more yellow triangle with network connection icon.


Java security warning “This application requires an older version…”

June 3, 2011

Try the below to get rid of annoying Java security warnings (As we don’t know what would happen if you would uninstall the older versions which are used by 3rd party applications like Oracle e-business suite,  recommended application installed instead)

This tip was collected from this link

1. Close all browsers;
2. Make sure you are running latest version of Java
(check this via Java Control Panel in Windows Control Panel, or, more simply,
just download latest version from Java.com) (as of today’s date, the latest
version is 1.6.0_13);
3. Open Java Control Panel (via Windows Control
Panel);
4. Go to “Java” tab;
5. Click on “View” in “Java Applet Runtime
Settings” of that tab;
6. Uncheck “Enabled” for every version of Java listed
EXCEPT for the latest version;
7. Click “OK”, etc., and thus close Java
Control Panel;
8. Restart browser(s);
9. Done.

We hope this information is useful for few others out there!

for Windows7bugs

Admin