Reporting with TrakPC


TrakPC is the auditing program that runs on PCs and sends back hardware and software information to the Asset Management server. For the software, it reads the registry and retrieves the software titles that are displayed in the Windows Add or Remove Programs area. Here are a few examples of registry names:

Adobe Acrobat X

Citrix ICA Client

Amazon Cloud Player

These are straightforward. You can easily run reports on licensing compliance. Here are other examples of registry items returned by TrakPC:

Microsoft Office 2016

Microsoft Office Excel 2016

Microsoft Office OneNote 2016

If you link these to a single “Microsoft Office” software title you can report on the total of all of the individual items in one report.

There are two software tables involved with Asset Management, the Software Titles and the Software Registry. Each record in the registry table can be linked back to a record in the software title table.

When you enter a software purchase, you indicate a software title. You might record two purchases of Office 2016, one purchase for twenty-five licenses, and another for ten. Suppose you install twenty-three copies, and they show up in the registry as “Microsoft Office 2016”. Then you install eight more copies, and they are named “Microsoft Office Excel 2016”. By linking the two different registry descriptions back to the Software Title “Microsoft Office 2016”, your license compliance report would show something like:

Software Title Purchased Installed Remaining
Microsoft Office 2016 35 31 4

The license compliance report only displays software for which you have recorded purchases. This eliminates software such as updates and hot fixes from showing up on the compliance report.

When searching for asset items, you can search by the registry description or the software title. In the above example, searching on the software title “Microsoft Office 2016” would produce a list of thirty-one PCs. Searching on the registry description “Microsoft Office Excel 2016” would show eight.