
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-28-2012 02:43 PM
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
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
Labels:
- Labels:
-
Archive
1 REPLY 1

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-28-2012 02:58 PM
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.
