IBM software - report

[plinacrolan]

As title says, can someone explain how to make report that can pull out all IBM software found on network (Websphere,Tivoli...). And than we need the number of licences for each IBM sw product found as we doing some revision. The point is that we wonna compare real number bought licences with the number in use ones to see if we can cut some out.

Ty vm

[Hemoco]

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputers.LastknownIP, tblsoftware.softwareName
From tblComputers Inner Join
tblsoftware On tblsoftware.ComputerName = tblComputers.Computername
Where (tblsoftware.SoftwarePublisher Like 'ibm%') Or
(tblsoftware.softwareName Like '%ibm%')

[plinacrolan]

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputers.LastknownIP, tblsoftware.softwareName
From tblComputers Inner Join
tblsoftware On tblsoftware.ComputerName = tblComputers.Computername
Where tblsoftware.SoftwarePublisher Like 'ibm%'

This last report is the one we were looking for, but can you modify search request where we look 'ibm%' in the SoftwareName this time, im looking app from IBM just right now and its not in last report becouse SoftwarePublisher field is empty, ty.

[plinacrolan]

Ty on fast reply & solution, but are the servers also included in this report becouse i can see in others reports there are IBM sw products on them but they didnt included in this report (so pls extend search on all devices).

And if you could add columns in that report with computer name and ip per each application found ( than ill do total manually, more important is to identify device), ty vm and sry for trouble.

[Hemoco]

Ty on fast reply & solution, but are the servers also included in this report becouse i can see in others reports there are IBM sw products on them but they didnt included in this report (so pls extend search on all devices).

This contains all computer found (including servers), verify if the software pulisher name is 'IBM'

And if you could add columns in that report with computer name and ip per each application found ( than ill do total manually, more important is to identify device), ty vm and sry for trouble.

This is possible, but you won't have a count of the total.

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputers.LastknownIP, tblsoftware.softwareName
From tblComputers Inner Join
tblsoftware On tblsoftware.ComputerName = tblComputers.Computername
Where tblsoftware.SoftwarePublisher Like 'ibm%'

[Hemoco]

Try something like this (you might need to change '%ibm%)

Select tblsoftware.SoftwarePublisher, tblsoftware.softwareName,
Count(tblComputers.Computername) As Total
From tblComputers Inner Join
tblsoftware On tblsoftware.ComputerName = tblComputers.Computername
Group By tblsoftware.SoftwarePublisher, tblsoftware.softwareName
Having tblsoftware.SoftwarePublisher Like 'ibm%'