cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
bastian23
Engaged Sweeper
Hello,

i try to create a own report. with following criteria

Hostname - OS - Installed Software


this is necessary for a software lizenz audit.

is this possible? i try and try .. but i become not the needed output...
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
Please try the following report:

Select tblComputers.Computername, tblComputers.Domain, tblComputers.Computer,
tblOperatingsystem.Caption, tblSoftware.softwareName,
tblSoftware.softwareVersion, tblSoftware.SoftwarePublisher
From tblComputers Left Join
tblOperatingsystem On tblComputers.Computername =
tblOperatingsystem.Computername Inner Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName
Order By tblComputers.Computer, tblSoftware.softwareName

View solution in original post

4 REPLIES 4
Hemoco
Lansweeper Alumni
To make the distinction between a physical and a virtual machine, your best bet is the Vendor field from tblComputerSystemProduct.

Please try the following query:

Select Top 1000000 tblComputers.Computername, tblComputers.Domain,
tblComputers.Computer, tblComputerSystemProduct.Vendor,
web40ProcessorCapacity.NrOfProcessors, web40ProcessorCapacity.CPU,
tblOperatingsystem.Caption As OS, tblSoftware.softwareName,
tblSoftware.softwareVersion, tblSoftware.SoftwarePublisher
From tblComputers Left Join
tblOperatingsystem On tblComputers.Computername =
tblOperatingsystem.Computername Inner Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName Left Join
web40ProcessorCapacity On web40ProcessorCapacity.Computername =
tblComputers.Computername Left Join
tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername
Order By tblComputers.Computer, tblSoftware.softwareName
bastian23
Engaged Sweeper
hello,

can you please add also the cpu (1...2 core) information and is this a virtual machine or real hardware.
bastian23
Engaged Sweeper
thank you... perfect very fast help.

Hemoco
Lansweeper Alumni
Please try the following report:

Select tblComputers.Computername, tblComputers.Domain, tblComputers.Computer,
tblOperatingsystem.Caption, tblSoftware.softwareName,
tblSoftware.softwareVersion, tblSoftware.SoftwarePublisher
From tblComputers Left Join
tblOperatingsystem On tblComputers.Computername =
tblOperatingsystem.Computername Inner Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName
Order By tblComputers.Computer, tblSoftware.softwareName