Software Search does not work anymore

[jacobsenm]

Hi,

I am using LANSweeper 3.5.1.28957

I recently upgraded from version 3.2 to 3.5.1.28957
Now I found that the software search from the right upper corner does not work anymore.
When I type the software name, it displays it in the lookup.
But when I press enter or click on the "magnifying glass" icon no results are displayed.

When I try to find for instance all Autocad software (find on auto) it display a script error:

Line 27
Char 9
Error 'document.getElementByID(....) is null or not an object
Code 0
URL: http://euedeap04/lansweeper32/default.aspx?
software=auto&item=searchsoftware

Can you help to resolve this ?

Thank you.

[jacobsenm]

Hi,

THAT did the trick.
Issue is resolved now.
I can search the software from the upper part of the screen.

Thanks a lot for your prompt replies.

[Hemoco]

Try this:

alter view dbo.web30repsoftwaretotal
 AS SELECT     TOP 100 PERCENT dbo.tblSoftware.softwareName AS Software, dbo.tblSoftware.softwareVersion AS Version, 
                      dbo.tblSoftware.SoftwarePublisher AS Publisher, COUNT(dbo.tblSoftware.ComputerName) AS Total
FROM         dbo.tblSoftware INNER JOIN
                      dbo.tblComputers ON dbo.tblSoftware.ComputerName = dbo.tblComputers.Computername
GROUP BY dbo.tblSoftware.softwareName, dbo.tblSoftware.softwareVersion, dbo.tblSoftware.SoftwarePublisher
ORDER BY COUNT(dbo.tblSoftware.ComputerName) DESC

[jacobsenm]

I know. But I tend to think that this can resolve the problem.

Because I saw some references in the forum that makes me think that I created this problem myself.

The Sofware search issue started when I played with a Software report based on the report "All Installed Software".
This report "All Installed Software"does not work anymore. I did not change "All Installed Software" by purpose.

I think when this report (or related view) is fixed, the software search will work as well.

Thanks

[Hemoco]

The script was meant to try to solve the software search problem.

[jacobsenm]

I ran the script that you supplied.
Now still when I try to open the report "All Installed Software" it still gives error:

Invalid Object name "web30repsoftwaretotal"

Thank you for the prompt reply

[Hemoco]

Could you try this code : (run from the sql scripts)

ALTER PROCEDURE dbo.web30ajaxsoftware
(@soft nvarchar(300))
AS SELECT DISTINCT 
                      TOP 20 ISNULL(dbo.tblSoftware.softwareName, '') AS softwareName, CASE WHEN dbo.tblApprovedSoftware.Software IS NULL 
                      THEN 'images/snok.gif' ELSE 'images/sok.gif' END AS softwareImage
FROM         dbo.tblSoftware LEFT OUTER JOIN
                      dbo.tblApprovedSoftware ON dbo.tblSoftware.softwareName = dbo.tblApprovedSoftware.Software
WHERE     (dbo.tblSoftware.softwareName LIKE @soft + '%') AND (ISNULL(dbo.tblSoftware.softwareName, '') <> '')
ORDER BY dbo.tblSoftware.softwareName

[jacobsenm]

I think the issue is related to the fact I by accident ruiened the report "'all installed software".
How can I create it again ?

Thank you

[jacobsenm]

I did an upgrade from 3.2 to 3.5.1 1 month back.
So the lansweepersetup.exe was not in the upgrade file.

I used the "Fresh" 3.5.1 install setup file called :
Lansweepersetup.exe

I start in install and ONLY check Website to install.
I choose the correct server : EUEDEAP04\SQLEXPRESS
It succeeds in connecting, but than the connection to the database gives me an error:

The lanssweeper database is not installed on EUEDEAP04\SQLEXPRESS Server

I am stuck again

[Hemoco]

For point 3 you should run the installer (lansweepersetup.exe)