- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-17-2020 04:43 PM
How can I start to troubleshoot this as it only seems to be growing in terms of entries and I am concerned that these may be machines trying to report in and they cannot for whatever reason.
Solved! Go to Solution.
- Labels:
-
General Discussion
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-04-2020 03:23 PM
You should be able to delete these records safely.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-04-2024 04:41 PM
I recently opened a support ticket regarding this issue. Here's the long response from support. Note that this response doesn't address duplicate entries (e.g. multiple tblLsAgentAsset entries referencing the same AssetID), which is also a problem. I'm still working through that one.
We understand the importance of keeping your LsAgent data clean and organized, and it sounds like you've encountered some challenges with orphaned assets and duplicates.
We have two options to help you address this:
Option 1: Manual Uninstallation of Orphaned LsAgent Assets
This approach is ideal if you want to target specific devices that you're confident are no longer needed. Here's how to proceed:
- Locate Orphaned Assets: You can identify these assets by looking for entries with no AssetID in the tblLsAgentAssets table. You can use the query (Select from tblLsAgentAsset where AssetID is NULL) to view them.
- Uninstall LsAgent from Orphaned Devices: Navigate to Scanning > LsAgent Scanning in the Lansweeper web console. Tick the boxes next to the unwanted LsAgent assets and select "Delete". This will send a command to those devices to uninstall the agent, provided they can still communicate with the scanning server.
Option 2: Database Cleanup of Orphaned LsAgent Assets
This method allows you to directly delete orphaned entries from the database. It's a good option for bulk cleanup but proceed with caution as any mistakes could affect valid assets. Here's what to do:
Important: Before proceeding, it's crucial to back up your Lansweeper installation as a safety measure. You can find instructions on how to do this here: https://community.lansweeper.com/t5/lansweeper-maintenance/back-up-your-installation/ta-p/64309
- Identify Orphaned Assets: Use the same query (Select from tblLsAgentAsset where AssetID is NULL) to view assets with no associated AssetID.
- Delete Orphaned Entries: Once you have a backup, you can run the following query to delete these entries: delete from tblLsAgentAssets where AssetID is NULL
Additional Considerations:
- If some devices cannot communicate with the scanning server for uninstallation via Lansweeper (option 1), you can manually uninstall the agent following the instructions in our Knowledge Base: https://community.lansweeper.com/t5/scanning-your-network/uninstall-lsagent/ta-p/72294 (This link pr...).
- Remember that cleanup via the LsAgent Scanning section (Scanning > LsAgent Scanning) will trigger a pending LsAgent uninstall on the targeted asset.
We recommend choosing the option that best suits your comfort level and the specific situation. If you have any questions or need further clarification on either approach, please don't hesitate to ask. We're happy to assist you further.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-05-2024 08:37 AM
Excellent, thank you for sharing the answer with the rest of the community @StillGoing
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-04-2020 03:23 PM
You should be able to delete these records safely.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-08-2021 07:49 PM
But does anyone know what should be done in this case
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-04-2020 12:55 AM
Have you found out what this issue is? i am facing the same problem right now.
cheers.