PC - OS - installed Software

[bastian23]

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...

[Hemoco]

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]

hello,

can you please add also the cpu (1...2 core) information and is this a virtual machine or real hardware.

[bastian23]

thank you... perfect very fast help.

[Hemoco · Accepted solution]

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