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.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now