Reports

How fast? Seriously fast.

We've done enough transformation projects to know that good planning can reap huge rewards in the long term, so this week I wanted to focus on AppTracker's planning capabilities. The data in the screenshot below is from a real-life Windows 8.1 migration currently in progress. 

Overview: A large organisation want to mobilise their workforce by replacing legacy desktops with Windows 8.1 tablets and laptops. They use a software asset management (SAM) solution to discover which users use which applications. This produces a huge volume of data:

  • Over 3,000 apps in use in the organisation
  • 700,000 application usage records appended daily with new data

The traditional approach for the applications team is to start getting the 3,000 apps ready for the new environment. This involves discovery, packaging, UAT, release to Live etc. Once most of the applications (80-90%) have been through the full readiness process we can start to migrate our users to Windows 8.1. The issue here is that we have to wait 12 months or more before these 3,000 applications are ready. 

Thankfully there is a better way which will save a huge amount of time and money:

AppTracker Application Prioritisation ("AAP")

AppTracker Application Prioritisation

AAP allows you to specify how many applications the team can get ready each week. I chose 55 per week for this example. It's a big number, but there's a big team working on this one. AppTracker looks at the data feed from the software asset management solution, and works out which applications you need to get ready each week based on which application the business use the most. Because AppTracker knows which users need which applications, it can then tell you when each user is ready to migrate.

"With just 20% of the applications ready 

we can migrate 79% of the users"

In the screenshot above each orange bar represents a week and the green line shows how many users are ready for migration on that week. The selected orange bar is 10 weeks into the project. At this point we have 20% of the applications ready, and we can migrate 79% of the users. This allows us to start the deployment phase of the project over six months earlier than is possible without AppTracker's planning capabilities. Now there's a cost saving that'll put a smile on the CFO's face...

New AppTracker Reports & Analysis

Four new reports have been added to AppTracker

  1. Packaging Impact Analysis
  2. User-Apps Readiness Report
  3. Blueprint-App Readiness Report
  4. Deployment Unit Apps Readiness Report

To access these reports, just select the users you wish to report on and the Click Reports as shown below:

New Reports

It's been an extremely busy four months with AppTracker. The User Migration module is really coming on in leaps and bounds with the new Application Readiness reports. It's now possible to answer the question:

"which applications do I have to package first in order to  provide the most amount of users ready for migration?"

These new reports put the project manager firmly in control of the user migration schedule and allow them to concentrate on the logistics of delivering the solution. It was a real eye opener to be able to go into a project the other day, analyse the data and tell the client that if they packaged the top 40 applications then 60% of their 14,000 user base could be migrated from an application perspective.

Packaging Impact Analysis

This is the highlight of AppTracker’s latest features. This report allows you see your current state of readiness (the blue bars) and your predicted state of readiness if you let AppTracker pick the applications to package first. 

Packaging Impact Analysis

By using the interactive gauges it's possible to see the effect your packaging effort will have on the overall user migration readiness. To then be able to break that data down into Blueprints (i.e. by department or geographical area) and confidently say that the Finance department will be in a position to be migrated in September is very powerful indeed.

Impact Analysis Guages

These new reports can be accessed from the Reports menu in the User Migration and Deployment Unit sections of AppTracker.

User Apps Readiness Report

This is an update to the previous User Apps Readiness Report but it now has a new layout and better ‘What If’ options so you can see the impact of packaging specific apps or whole processed of apps on your estate. 

User Apps Readiness

Blueprint Apps Readiness Report

Get individual Readiness of your users on a Blueprint level, see which Blueprints are closest to being ready.

Blueprint Apps Readiness

Deployment Unit Apps Readiness Report

Get individual Readiness of your users on a Deployment Unit, see which DU’s are closest to being ready.

Deployment Unit Apps Readiness



Reporting - Miscellaneous

In this post I'll cover 3 miscellaneous reports that can be handy for getting obscure information.

Change History

AppTracker shows a detailed history of changes made to applications including who made the changes. The change history report shows you the changes made to a group of applications during a selected time period. This can be used to build bespoke reports not covered in the standard list.
For example:

  1. List all the applications raised in the last two weeks.
  2. List all the applications added to the UK Blueprint this month.
  3. Show all the changes made by a specific user this week.

This is achieved by filtering the history to the change events that you are looking for.

Change History

Applications Contacts

Applications can have different contacts attached to them, these can be for UAT, discovery, support, app owners etc. This report shows all the contacts associated with a list of applications and what type of contact they are.

Discovery Info

AppTracker’s Discovery Info tab is completely configurable by you, you can add text boxes, radio buttons, tick boxes, dropdowns … etc . If you want a report of a list of applications and some or all of these discovery options then this report will allow that. You can select all the major application fields and Discovery Info fields that you need and run the report. You’ll get back and excel style grid of the information.

Discovery Info


Reporting - Blueprints

In this post I'll cover the two main Blueprint reports in AppTracker.

Blueprint Process Totals

When you have a lot of Blueprints and various applications in each you might want to see the process totals breakdown for each of your Blueprints without having to click them individually in the applications view. This report shows you the various process totals in each of your Blueprints and can be configured for only processes you care about.

Applications in Blueprints

As AppTracker supports having the same applications in multiple Blueprints it can be useful to see which applications are requested the most across all of your Blueprints. This report and will show you a count of the number of Blueprints an application is in as well as the names of those Blueprints.

Reporting - Processes and Times

In this post I'll cover the 4 main processes and time reports in AppTracker. These reports in particular are essential information for on time software migrations.

Process Milestones

A very powerful report showing a bar chart of the total number of applications in the various different processes over a given period in the past. E.g. it’s possible to take a Blueprint of applications and check their process totals for the last six weeks or the last six months. This can show measurable process or lack of and the need for intervention.

Process Milestones

Process Deltas

This report builds on the process milestones report and can show you the rate of applications entering the different processes over a given period. For example this can show the rate of applications going from packaging to UAT and if it has remained constant. This is very good at  measurable if SLA's are getting meet by the various teams.

Process Deltas

Time in Current Process

If you are looking for bottle necks in your workflow this report can help, it will show the total time each applications has been in its current Process / Sub Process. This can then be further filtered and sorted to highlight the applications that have been stuck for days or weeks and need to be focused on.

Total Time in Processes

If you are trying to identify which processes are taking the longest, get the average packaging time or find the top 10 longest applications to package then this report will give you the building blocks. It will show the total time an app has spent in each process over its lifecycle.

Reporting

Over the next few days I will write a number of posts on AppTracker's reporting ability. This will cover Testing reports, Processes & Time reports, Blueprints reports and other handy reports all built into AppTracker. 

AppTracker contains very powerful and detailed set of reports that can be used to manage a software migration project from start to finish. Our reports can be run on all applications or any subset of applications allowing you to analyse and filter the application portfolio by Blueprint, process, vendor, packager etc, or any combination of these options!  

Report Types

There are three types of reports in AppTracker; Test Reports, Metric Reports and Inventory Reports.

Test Reports

Provide the ability to manage the testing and quality of the deliverables within the project. This is especially useful when trying to manage the process interfaces between teams such as the discovery team and an outsourced packaging company. By managing the quality throughout the workflow it is possible to substantially reduce costs and improve productivity.

Metric Reports

Allow a project manager to see how a project is progressing over time. By providing weekly or bi weekly snapshots of the workflow its possible to see if a project or process is stalling and whether team members need to be refocused to concentrate on difficult areas.

Inventory Reports

Provide the ability to extract information from the extensive application knowledge base. This knowledge base can be dynamically defined and extended by the administrator as requirements come into the project. It then becomes possible to ask questions such as "show me all the applications used by Marketing", "Show me all the applications that connect to ServerX", "Show me all applications that failed quality step Y"

Output

All of the reports can be printed directly to a printer or exported to Excel, word CSV and other standard formats for further manipulation.

Dashboard Reporting

The AppTracker Dashboard is the first screen that everyone will see when the open AppTracker. It shows three charts. Users can configure this view for the processes or package types they are most interested in.

  1. A snapshot of the current processes and the number of applications in each.
  2. A pie chart of the breakdown of application types that are in the system, e.g. msi, app-v, citrix. 
  3. A progress history of applications moving through the various processes since the beginning of the project. 

Dashboard Reporting