Custom Software Report

[ranman]

I'm trying to run a report that shows specific software on each computer. What I'm trying to do is make sure that all computers on the network have these programs on it. Any suggestions? Thanks.

[gravity5]

That last piece of code is something I am looking for, but I don't understand where to enter that code into the interface.
Can you tell me?

Or is there a guide or manual for creating custom reports?

[Hemoco]

gravity5 wrote:
That last piece of code is something I am looking for, but I don't understand where to enter that code into the interface.
Can you tell me?

Or is there a guide or manual for creating custom reports?

In the configuration tool go to the report builder, right click a report, choose "new report"

[Hemoco · Accepted solution]

Select tblComputers.Computername, tblComputers.ComputerUnique,
  tblComputers.Domain
From tblComputers
Where tblComputers.Computername Not In (Select tblsoftware.ComputerName
  From tblsoftware Where tblsoftware.softwareName Not Like '%acrobat%')
or tblComputers.Computername Not In (Select tblsoftware.ComputerName
  From tblsoftware Where tblsoftware.softwareName Not Like '%software2%')
or tblComputers.Computername Not In (Select tblsoftware.ComputerName
  From tblsoftware Where tblsoftware.softwareName Not Like '%software3%')
or tblComputers.Computername Not In (Select tblsoftware.ComputerName
  From tblsoftware Where tblsoftware.softwareName Not Like '%software4%')
or tblComputers.Computername Not In (Select tblsoftware.ComputerName
  From tblsoftware Where tblsoftware.softwareName Not Like '%software5%')
or tblComputers.Computername Not In (Select tblsoftware.ComputerName
  From tblsoftware Where tblsoftware.softwareName Not Like '%software6%')

[ranman]

All user accounts worked well. Thanks.
What I am trying to do with the other report is to list about 6 programs and see what computers on the domain do not have them installed. Any ideas?
Thanks again.

[Hemoco]

This is an example to find computers without acrobat reader

Select tblComputers.Computername, tblComputers.ComputerUnique,
  tblComputers.Domain
From tblComputers
Where tblComputers.Computername Not In (Select tblsoftware.ComputerName
  From tblsoftware Where tblsoftware.softwareName Not Like '%acrobat%')

this is an example to show all users on a computer

Select tblComputers.Computername, tblComputers.ComputerUnique,
  tblComputers.Domain, tblUsers.Caption, tblUsers.Name
From tblComputers Inner Join
  tblUsers On tblComputers.Computername = tblUsers.Computername

[ranman]

I want to run a report to show which computers do not have certain software. We have a standard image that has specific software on it. I'd like to run a report that shows what PC's do not have this software installed. Would I just keep adding software titles in criteria (eg. Adobe Reader, Firefox, IE7)?
Also, is there a way to find out what accounts are ona computer through a report?

Thanks again.

[Hemoco]

I'm not sure I understand what you want.
Can you give an example please.