→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
ServiceDeskAPS
Engaged Sweeper
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!

1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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.

View solution in original post

1 REPLY 1
Hemoco
Lansweeper Alumni
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.