Help Running Report; Computer Name and software installed

[d4]

Hi There,

Just want create a simple report in excel where list the computer name and software on them

Any help is appreciated!

Also can we fine tune this for Microsoft, Autocad?

Cheers
Dave

[Hemoco]

Select tblComputers.Computername, tblComputers.Domain, tblSoftware.softwareName,
  tblSoftware.softwareVersion, tblSoftware.SoftwarePublisher
From tblComputers Inner Join
  tblSoftware On tblComputers.Computername = tblSoftware.ComputerName
Where tblSoftware.Softwarename Like '%yoursoftware%'

replace yoursoftware

[d4]

Many Thanks

On another query, how do get to a particular software Microsoft Project i.e.

Microsft Project 98, Microsoft Project Standard 2002, Microsoft Project Standard 2007

[Hemoco]

You need to change the '%microsoft%' part to the correct publisher

[d4]

Thanks for that!

Finally how do I modify the 'Microsoft' report to add 'autocad' software as well please

[Hemoco]

Right click/create a new report
Copy paste this code in the sql part at the bottom.
Click on the empty place where the tables are.

[d4]

Thanks I am a newbie

How do I set it up please in report builder?

[Hemoco]

This is an example for all software:

Select tblComputers.Computername, tblComputers.Domain, tblSoftware.softwareName,
  tblSoftware.softwareVersion, tblSoftware.SoftwarePublisher
From tblComputers Inner Join
  tblSoftware On tblComputers.Computername = tblSoftware.ComputerName

This is only microsoft software:

Select tblComputers.Computername, tblComputers.Domain, tblSoftware.softwareName,
  tblSoftware.softwareVersion, tblSoftware.SoftwarePublisher
From tblComputers Inner Join
  tblSoftware On tblComputers.Computername = tblSoftware.ComputerName
Where tblSoftware.SoftwarePublisher Like '%microsoft%'

[d4]

Version 3.5.6

[Hemoco]

Are you using version 3.5.x or beta 4.0?