Software Inventory Logging Aggregator 1.0 for Windows Server

Software Inventory Logging is intended to reduce the operational costs of inventorying the Microsoft software deployed across many servers in an IT environment. This Software Inventory Logging Aggregator 1.0 will install on one server and receive inventory data from any Windows Server configured to forward data to it via the Software Inventory Logging feature available in Windows Server itself. The design allows data center administrators to enable Windows Server's Software Inventory Logging feature in master images intended for wide distribution in their environment and deployed with automation. This software package is the target point and intended for customers to install on their premises for easy logging of inventory data over time. This software also allows for periodic creation of basic inventory reports in Microsoft Excel. Software Inventory Logging Aggregator 1.0 reports include counts of installations of Windows Server, System Center, and SQL Server.

Important: No data is sent to Microsoft with the use of this software

For more info and details on Software Inventory Logging Aggregator, go to: http://go.microsoft.com/fwlink/?LinkID=616388&clcid=0x409

Supported Operating Systems

Windows Server 2012 R2

Software Inventory Logging Aggregator 1.0 requires the following software for installation:

• Windows Server 2012 R2 (Standard or Datacenter Edition)
• SQL Server 2012 Sp2 Standard Edition or SQL Server 2014 Standard Edition
• 64 bit Microsoft Excel 2013 with PowerPivot add-in

If running in a virtual machine, a minimum of 4GB of memory should be assigned to the virtual machine.

There are some things you need to make sure of before installing SIL Aggregator on a Windows Server:

• SQL Server Standard Edition is installed, or is installed on a remote server you intend to be used with this software.
• The IIS server role is added with .Net Framework 4.5, WCF Services, and HTTP Activation, all in the same selection tree in Add Roles and Features Wizard.
• You are logged on to the server with an account that has administrative privileges.
• You are logged on to the server with an account that has sysadmin privileges on the SQL Server, if Windows Authentication is desired. Or, if SQL Authentication is desired you have the password for an account that has SQL administrative privileges.
• You have a valid SSL certificate that you want to use to host this software’s web service. And the name of the certificate matches the name of the server.

To install the software:

• Download both files, Setup.exe and Microsoft.SILA.MSI.msi, into the same local directory.
• Double-click the Setup.exe to start the installation.
• Click Next on the welcome window.
• If you accept the EULA, check the box accepting the agreement and then click Next.
• In Choose Features, select Install Software Inventory Logging Aggregator and Reporting Module, and then click Next.
• After all prerequisites are verified, click Next.
• In Choose an Account Type, select either local user or gMSA depending on your preference.
• In Choose a SQL Server window, enter the SQL Server where your SQL instance is installed, or "localhost," if it is installed on the local server.
• Select the authentication type and click Verify SQL.
• Click Next, and then in Internet Information Services Server Details, select a port number or keep the default.
• Browse for the .pfx file location, type the password for the .pfx file, and then click Next.
• The final screen will show installation progress. Once completed successfully, click Finish.

To uninstall the software:

• Open Powershell as an administrator, and then type Stop-SilAggregator. When the prompt returns, SIL Aggregator has stopped.
• Go to Control Panel, click Programs and Features, click Uninstall Programs, click Software Inventory Logging Aggregator, and then click Uninstall at the top.
• Software Inventory Logging Aggregator will open a window to prompt you to choose between deleting all data in the database, or keeping all data in the database. The default selection is to keep (if a reinstall is desired, you can attach to the existing database to pick up where the Aggregator left off).
• Select either Keep or Delete, and then click Next.
• After the progress bar completes, click Finish.