Office 2016

[donohue17]

Can anyone see Office 2016 Pro Plus on the PC View?

[Susan_A · Accepted solution]

Donohue17's issue has been resolved. For everyone else's benefit, I'm pasting the latest reply we sent via email below.

Thank you for the information. We found the following error in your errorlog.txt:

03/29/2016 12:28:37: DEBUG Software: error finding unique key for softwareName=Microsoft Office Professional Plus 2016, softwarePublisher=Microsoft Corporation on asset <ASSETNAME>

The error points to a structural issue with your Lansweeper database, which is preventing new software records from being added. We're not sure what caused the database problem, but could you do the following to resolve the issue:

• Execute the script below in the Lansweeper web console under Configuration\Database Scripts. Copy and paste the code and hit the Execute SQL Code button. Just to be safe, back up your database first by following these instructions. The script will restore some default constraints that appear to be missing from your database.
  

  ALTER TABLE tblSoftwareUni ADD CONSTRAINT DF_tblUniqueSoftware_Approved DEFAULT ((0)) FOR Approved
  GO
  ALTER TABLE tblSoftwareUni ADD CONSTRAINT DF_tblUniqueSoftware_OSType DEFAULT ((1)) FOR OSType
  GO
  ALTER TABLE tblSoftwareUni ADD CONSTRAINT DF_tblSoftwareUni_Added DEFAULT (getdate()) FOR Added
  GO

  
  
• Restart the Lansweeper Server service under services.msc
  
• Rescan the computer by hitting the 'Rescan Asset' button in the left column of the asset web page. Wait for your scanning queue to clear under Configuration\Scanning Queue and refresh the asset web page.

[donohue17]

I just emailed back the results of the Log file in debug mode.

[Susan_A]

Just for everyone else's benefit, I'm posting the reply we sent via email below. We haven't heard back from donohue17 yet, so for now I'm assuming this issue is resolved.

Could you isolate one problem computer and double-check that:

• The computer has recently and successfully been rescanned. The "last seen" date listed on the computer webpage should be recent.
  
• The user logged into the computer during the last successful computer scan (i.e. the user listed in the computer's Summary tab) has the software listed in Add/Remove Programs on the client machine. If there are multiple users on the computer and only specific users have the software installed, the software will only be listed in the computer's Software tab if it's installed for the user logged in during the last computer scan.

If the information above doesn't explain the issue, could you:

• Put your scanning service in debug mode by following these instructions.
  
• Rescan one problem client machine by clicking the Rescan Asset button on the asset page. Wait for the "last seen" date listed on the page to update.
  
• Send us:
  - Program Files (x86)\Lansweeper\Service\Errorlog.txt, as present on your Lansweeper server.
  - Screenshot of the Software tab of the problem client machine's Lansweeper webpage.
  - Screenshot of the Scan Time tab of the problem client machine's Lansweeper webpage.
  - Screenshot of Add/Remove Programs on the client machine itself.

[donohue17]

I just sent the email in to get this looked at.

[Bart_E]

If you are running the latest version of Lansweeper, Office 2016 is listed in the Add/Remove Programs on the client machine and you successfully rescanned your asset by using the 'Rescan Asset' button, the software should list under the Software tab on the asset web page. If not, could you drop a mail to support@Lansweeper.com so we can further investigate this with additional information.

[donohue17]

Susan,

I would think that would be the case as well but it is not. I have Office 2016, Java and a few other items on my system that show up in Add/Remove but do not show up in LAN Sweeper PC View.

[Susan_A]

If the software package is listed in Add/Remove Programs on the client machine, it should be scanned by the default software scanning procedure as well and it should be visible in the computer's Software tab. Try rescanning your machines by clicking the Assets link at the top of the web console, ticking the upper checkbox and hitting the Rescan button on the left. Wait for the "last seen" (= last successful scan) dates listed on your computer webpages to update.