Include user name in Software Reports

[d_i_saunders]

Hi all..

Is it simple to include the user name in the software reports..

Currently I search on a bit of software.. It finds it, shows the number of people that have it installed...

I click on the software in the report and it shows the PC Name, domain etc of the pcs that have the software installed.

I would like to incluide the user name..

We need to contact some people that have sepecific version installed.

Is it easy?

Thanks

Dave

[Cobra7]

I see.

As far as I know the detailed software report is hard coded and can not be changed.

What you can do is make a new report in Report builder and change the code when you need a report for a new software type.

SELECT TOP 100 PERCENT 
  dbo.tblSoftware.ComputerName,
  dbo.tblSoftware.softwareName,
  dbo.tblComputers.Username
  dbo.tblSoftware.softwareVersion
FROM
  dbo.tblSoftware
  INNER JOIN dbo.tblComputers ON (dbo.tblSoftware.ComputerName = dbo.tblComputers.Computername)
WHERE
  dbo.tblSoftware.softwareName LIKE 'adobe reader%'
GROUP BY
  dbo.tblSoftware.ComputerName,
  dbo.tblSoftware.softwareName,
  dbo.tblComputers.Username
ORDER BY
  dbo.tblSoftware.softwareName,
  dbo.tblSoftware.ComputerName

In the WHERE section, you can change LIKE to = and get rid of the %, then change to an exact name to get an exact report, or you can leave it and get all versions.

I know this isn't exactly what you want, but it may be a decent work around.

[d_i_saunders]

Hi,


Thanks for the reply...

The report is the standard one from LS...

I search at the top of the screeen fro application X

I then returns "Software search for : X"

I click on the verison of X that I need...

It then shows " Software X 765 items found"

For each of records it shows:

Computer Decription OS Domain Date

I would just like to include User Name

Thanks Again.

dave

[Cobra7]

Is this a cusom report or is it one that came with LS?

If it did come with LS, post here the exact name of the software (as LS sees it) and I'll write up a quick report for you.