→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
gdavis
Engaged Sweeper II
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.
1 ACCEPTED SOLUTION
gdavis
Engaged Sweeper II
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

View solution in original post

3 REPLIES 3
Hemoco
Lansweeper Alumni
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.
gdavis
Engaged Sweeper II
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
gdavis
Engaged Sweeper II
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