Complete Microsoft Report

[kevinoie]

Hi.

I was wondering if it was possible to create a report with the following tables:

PC/Server Name
Device Type - Desktop/Laptop/Server
Application Name, Version and edition
Microsoft produce ID
Microsoft License Key
Install Date
Last used Date (if possible)

I would be very greatful for any assistance on this.

kev

[Hemoco]

It is important to note that software and product key scanning are completely separate from one another. A report that includes both software and product key information would not be useful, as random scanned software packages would be paired with random scanned product keys.
Usage information is not currently collected for software.


Example Microsoft software report:

Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique, tblComputers.Domain, TsysChassisTypes.ChassisName, tblSoftware.softwareName, tblSoftware.softwareVersion, tblSoftware.SoftwarePublisher, tblSoftware.Installdate, tblSoftware.Lastchanged From tblComputers Inner Join tblSoftware On tblComputers.Computername = tblSoftware.ComputerName Inner Join tblSystemEnclosure On tblComputers.Computername = tblSystemEnclosure.Computername Inner Join TsysChassisTypes On TsysChassisTypes.Chassistype = tblSystemEnclosure.ChassisTypes Where tblSoftware.SoftwarePublisher Like '%Microsoft%' Order By tblComputers.ComputerUnique, tblSoftware.softwareName

Example product key report:

Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, TsysChassisTypes.ChassisName, tblSerialnumber.Product,
tblSerialnumber.ProductID, tblSerialnumber.ProductKey,
tblSerialnumber.Lastchanged
From tblComputers Inner Join
tblSystemEnclosure On tblComputers.Computername =
tblSystemEnclosure.Computername Inner Join
TsysChassisTypes On TsysChassisTypes.Chassistype =
tblSystemEnclosure.ChassisTypes Inner Join
tblSerialnumber On tblComputers.Computername = tblSerialnumber.Computername
Order By tblComputers.ComputerUnique, tblSerialnumber.Product