
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-02-2013 07:23 PM
Is there a way to create a custom report from a software search? I performed a search for a specific software title and want to easily add the IP address and IP location to the report. If not, can anyone tell me how to tie the IP location field to the Software Name field? I previously used the upgrade_tblComputers table and the upgrade_tblSoftware table, but those no longer exist. Thanks alot for the help.
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-05-2013 07:21 PM
If anyone is curious, the below code displays a report of a specific software title with the location listing.
Select Top 1000000 upgrade_tblSoftware.SoftwarePublisher,
upgrade_tblSoftware.softwareName As Software,
upgrade_tblComputers.Domain,
upgrade_tblComputers.Computer,
upgrade_tblComputers.Username,
tblADusers.Displayname,
tsysIPLocations.IPLocation
From upgrade_tblComputers
Inner Join upgrade_tblSoftware On upgrade_tblComputers.Computername =
upgrade_tblSoftware.ComputerName
Left Outer Join tblADusers On upgrade_tblComputers.Username =
tblADusers.Username And upgrade_tblComputers.Userdomain =
tblADusers.Userdomain
Left Join tsysIPLocations On upgrade_tblComputers.IPNumeric >=
tsysIPLocations.StartIP And upgrade_tblComputers.IPNumeric <=
tsysIPLocations.EndIP
Where upgrade_tblSoftware.softwareName = 'Google Chrome'
Order By upgrade_tblComputers.Computer
Select Top 1000000 upgrade_tblSoftware.SoftwarePublisher,
upgrade_tblSoftware.softwareName As Software,
upgrade_tblComputers.Domain,
upgrade_tblComputers.Computer,
upgrade_tblComputers.Username,
tblADusers.Displayname,
tsysIPLocations.IPLocation
From upgrade_tblComputers
Inner Join upgrade_tblSoftware On upgrade_tblComputers.Computername =
upgrade_tblSoftware.ComputerName
Left Outer Join tblADusers On upgrade_tblComputers.Username =
tblADusers.Username And upgrade_tblComputers.Userdomain =
tblADusers.Userdomain
Left Join tsysIPLocations On upgrade_tblComputers.IPNumeric >=
tsysIPLocations.StartIP And upgrade_tblComputers.IPNumeric <=
tsysIPLocations.EndIP
Where upgrade_tblSoftware.softwareName = 'Google Chrome'
Order By upgrade_tblComputers.Computer
3 REPLIES 3

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-06-2013 08:49 PM
Note that automatically generated pages cannot be modified for now. You have to use custom reports to recreate these pages and add the information you need.

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-05-2013 07:21 PM
If anyone is curious, the below code displays a report of a specific software title with the location listing.
Select Top 1000000 upgrade_tblSoftware.SoftwarePublisher,
upgrade_tblSoftware.softwareName As Software,
upgrade_tblComputers.Domain,
upgrade_tblComputers.Computer,
upgrade_tblComputers.Username,
tblADusers.Displayname,
tsysIPLocations.IPLocation
From upgrade_tblComputers
Inner Join upgrade_tblSoftware On upgrade_tblComputers.Computername =
upgrade_tblSoftware.ComputerName
Left Outer Join tblADusers On upgrade_tblComputers.Username =
tblADusers.Username And upgrade_tblComputers.Userdomain =
tblADusers.Userdomain
Left Join tsysIPLocations On upgrade_tblComputers.IPNumeric >=
tsysIPLocations.StartIP And upgrade_tblComputers.IPNumeric <=
tsysIPLocations.EndIP
Where upgrade_tblSoftware.softwareName = 'Google Chrome'
Order By upgrade_tblComputers.Computer
Select Top 1000000 upgrade_tblSoftware.SoftwarePublisher,
upgrade_tblSoftware.softwareName As Software,
upgrade_tblComputers.Domain,
upgrade_tblComputers.Computer,
upgrade_tblComputers.Username,
tblADusers.Displayname,
tsysIPLocations.IPLocation
From upgrade_tblComputers
Inner Join upgrade_tblSoftware On upgrade_tblComputers.Computername =
upgrade_tblSoftware.ComputerName
Left Outer Join tblADusers On upgrade_tblComputers.Username =
tblADusers.Username And upgrade_tblComputers.Userdomain =
tblADusers.Userdomain
Left Join tsysIPLocations On upgrade_tblComputers.IPNumeric >=
tsysIPLocations.StartIP And upgrade_tblComputers.IPNumeric <=
tsysIPLocations.EndIP
Where upgrade_tblSoftware.softwareName = 'Google Chrome'
Order By upgrade_tblComputers.Computer

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-02-2013 11:52 PM
If this isn't possible does anyone know how to add the IP location to the custom built report shown below? The report was built in the previous version of lansweeper and displays all the desired information except for the IP location (which is define in our config). Which table can be used to include the IP location information for each computer. I cannot find a way to create a link from the tsysIPLocations table to the tables currently used below. Thanks in advance for the help.
Select Top 1000000 upgrade_tblSoftware.SoftwarePublisher,
upgrade_tblSoftware.softwareName As Software,
upgrade_tblComputers.Domain,
upgrade_tblComputers.Computer,
upgrade_tblComputers.Username,
tblADusers.Displayname
From upgrade_tblComputers
Inner Join upgrade_tblSoftware On upgrade_tblComputers.Computername =
upgrade_tblSoftware.ComputerName
Left Outer Join tblADusers On upgrade_tblComputers.Username =
tblADusers.Username And upgrade_tblComputers.Userdomain =
tblADusers.Userdomain
Where upgrade_tblSoftware.softwareName = 'Google Chrome'
Order By upgrade_tblComputers.Computer
Select Top 1000000 upgrade_tblSoftware.SoftwarePublisher,
upgrade_tblSoftware.softwareName As Software,
upgrade_tblComputers.Domain,
upgrade_tblComputers.Computer,
upgrade_tblComputers.Username,
tblADusers.Displayname
From upgrade_tblComputers
Inner Join upgrade_tblSoftware On upgrade_tblComputers.Computername =
upgrade_tblSoftware.ComputerName
Left Outer Join tblADusers On upgrade_tblComputers.Username =
tblADusers.Username And upgrade_tblComputers.Userdomain =
tblADusers.Userdomain
Where upgrade_tblSoftware.softwareName = 'Google Chrome'
Order By upgrade_tblComputers.Computer
