Showing results for 
Show  only  | Search instead for 
Did you mean: 
Engaged Sweeper

Lansweeper is reporting that one of my clients does not have MS Access 2010 installed. When looking at appwiz.cpl on this client I see Access 2010 is listed.

This client also have Office home and business 2010 installed.

I have done some searching and not foun much, the only thing I can think of is that an in place upgrade was actioned and the software name has not changed from home and business to Professional.

Any suggestions as to how this can happen?

What can I check?
Lansweeper Alumni
Please contact us at and provide us with the following:
- Screenshot of your web console landing page. You can access your landing page by clicking on the Lansweeper logo in the top left corner of the web console. Please show us the whole page.
- Output of the report below, preferably in Excel format. Replace "YourComputer" with the NetBIOS name of the problem machine.

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputers.Firstseen, tblComputers.Lastseen,
tblComputers.Lasttried, tblComputers.Lasttriggered,
tblComputers.LastScheduled, tblComputers.LastActiveScan,
tblComputers.LastLsPush, tblComputers.Scanserver, Web40OSName.OSname,
Web40OSName.SP, Web40OSName.OScode, tblComputersystem.SystemType,
TsysLastscan.CFGcode, TsysWaittime.CFGname, TsysLastscan.Lasttime,
TsysLastscan.Scantime, TsysWaittime.Waitdays, tblSoftware.softwareName,
tblSoftware.softwareVersion, tblSoftware.SoftwarePublisher,
tblSoftware.Installdate, tblSoftware.Lastchanged, tblerrors.CFGname As
CFGname1, tblerrors.ErrorText, tblerrors.Lastchanged As Lastchanged1
From tblComputers Left Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Left Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername Left Join
TsysLastscan On tblComputers.Computername = TsysLastscan.Computername
Inner Join
TsysWaittime On TsysWaittime.CFGCode = TsysLastscan.CFGcode Left Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName Left Join
tblerrors On tblComputers.Computername = tblerrors.Computername
Where tblComputers.Computer = 'YourComputer' And TsysWaittime.CFGname = 'SOFTWARE'
Order By tblSoftware.softwareName, tblSoftware.softwareVersion

To use the specified report, do the following:
• Open the Lansweeper configuration console and select Reports & Alerts\Report Builder. Hit the “New” button.
• Copy the SQL code provided and paste it at the bottom of the newly created report, replacing the default SQL code.
• Click somewhere near tblComputers so the new code applies.
• Give the report a “View name” and a “Report name” and hit the “Save” button.
• Double-click on the report in the report list to see its results and export options.
Engaged Sweeper

I forgot to mention that I am ONLY using LSCLIENT in a login script.