Custom Software Report

[ServiceDeskAPS]

Hi

I was wondering if anybody could assist with the following request

I would like to generate a report for Software as per the following:

Publisher
Software Name
Version Number
Type: Server Software or Desktop Software (dont know if this is possible may need to get it manually)
Bit Type (32 bit or 64 bit) - I didnt see a table that had this information in it

Thanks!

[Hemoco · Accepted solution]

Please use this sql

Select tblSoftware.SoftwarePublisher, tblSoftware.softwareName,
  tblSoftware.softwareVersion, Count(tblSoftware.ComputerName) As Total
From tblSoftware                  
Group By tblSoftware.SoftwarePublisher, tblSoftware.softwareName,
  tblSoftware.softwareVersion
Order By tblSoftware.SoftwarePublisher, tblSoftware.softwareName,
  tblSoftware.softwareVersion

The last two fields you need are not available.