1

assetcheck logo

Data Normalization

Your inventory and purchase data is a mess..
..and it always will be.


It's not your fault, you didn't make the data; it came from thousands of software vendors, spanning a mind-boggling number of installs over several years across your corporate devices.

No wonder nothing lines up.


AssetCheck automatically optimizes your softwarwe inventory and generate data alignment; this empowers you to properly determine license entitlements, downgrade rights and purchase entitlements.


AssetCheck can input your 'millions-of-rows' of inventory from your network management or inventory solution, and normalize all of your data .. in a matter of mintues.

   

data optimization quote

 The 5 biggest data normalization problems for Software License Management

data 1 publisher correction

You've seen slight variations in the vendor names in your reports and data-outputs. This isn't a huge problem for you, as long as you're working with one vendor at a time (sure, you can use %like% in SQL reports  or use pivot tables in Excel).

For a complete deployment review, it can't be quite frustrating as you'll have to apply the pivot-fix for each and every software vendor that you have.  Not fun.

data 2 publisher adoption

This is tougher to manage.  Adobe and Microsoft acquisitions are faily 'top of mind', but the software industry is built based upon acquisitions. I fact, In November 2011, Quest acquired it's 26th and 27th software company since it's '98 acquisition of 'TOAD', and Oracle's acquisition rate is remarakable. 

AssetLabs knowledgebase contains a 'who-bought-who' list (updated almost daily) so that you're not caught off-guard from an audit from one fo the 'big' softwrae companies who just got bigger via acqisitions.

data 3 version correction

May be it was Intel who started the 'model' trend when the successor to the 486 became 'Pentium' and not 586.  Or maybe it was Microsoft who preferred Windows XP over 'Windows 2002'.  Either way, we now have software collections that can be identified as models as well as versions.

AssetCheck not only converts long versions to simple digits, it properly maps the version equivalent of the 'model' so  that it can be properly used for licensing and downgrade right calculations.

data 4 title correction

If you're old enough to recall the Netscape web browser, you may remember when Adobe Acrobat was the app that only read PDF files, and not created them; it was Acrobat Distiller back then!!). That was version 3, and they're still out there.

The 'ProductLine' of Adobe 'reader' (as we know it today) has gone through several name changes in the last decade (Acrobat => Acrobat Reader =>Reader).   Microsoft has done the same with their Office products,  and Oracle frequently change the name of acquired products soon after aquisition.

data 5 remote install correction

 The 'remote install' capabilities of many network management products have the ability to change the install data of Windows products.   This is great for network managers to count the success rate of an over-night remote-install, but creates havoc as that changed name sitcks forever and creates havoc for the SAM team.

AssetCheck will not only detect these 'remote installs' but re-adjust the data and auto-fill any data slots that the network managers left out!