cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
sundarrs
Engaged Sweeper II
Hi,

I need to generate a report for Trial Software with the following details

ComputerName,Name of the Trial Software, Trial Software Version,Name of the User(Active Directory user ID),IP Address, Department Name


Additionally if we get the Installed using UserID,Installed Date is also appreciable.

Best Regards,

R.S.Sundar
1 REPLY 1
Hemoco
Lansweeper Alumni
sundarrs wrote:
I need to generate a report for Trial Software with the following details

Such a report will not be possible. Lansweeper does not categorize software automatically and it is not currently possible to do this manually either.

For a general software report, you can use the SQL code below.

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputers.LastknownIP, tblSoftware.softwareName,
tblSoftware.softwareVersion, tblSoftware.SoftwarePublisher,
tblSoftware.Installdate
From tblComputers Inner Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName
Order By tblComputers.ComputerUnique


sundarrs wrote:
Additionally if we get the Installed using UserID,Installed Date is also appreciable.

A software install date can often be retrieved, but it is not currently possible to see who installed a software package.