We have set up everything when linking 365 to lanseeper but hit a wall on Step 4: Assign and grant API permissions. For those that have Lansweeper at work, I wrote this little PowerShell module that can get any Lansweeper report into PowerShell object so you can interact with Lansweeper data in PowerShell. You can even use your browser to make API calls. Specifically, it tries to retrieve warranty details like purchase date, warranty expiration date, ship date, purchase country and purchased warranty products. I can still track the monthly windows 10 cumulative updates by the windows build number, so I know the updates are being applied, but the monthly patch audit reports Lansweeper puts out all show everything out of date anyway. $assets = Invoke-Sqlcmd -ServerInstance servername -Database lansweeperdb -Username lansweeperuser -Password 'password' -Query @", SELECT a.AssetID, a.AssetName, b.Serialnumber, b.SystemSKU, FROM lansweeperdb.dbo.tblAssets a, lansweeperdb.dbo.tblAssetCustom b, WHERE a.AssetID = b.AssetID AND, a.Assettype = -1 AND, b.Warrantydate is NULL AND, PSLansweeper is small module (about 80 lines of code) that interacts with Lansweeper SQL Database. I use powershell. For those that have Lansweeper at work, I wrote this little PowerShell module that can get any Lansweeper report into PowerShell object so you can interact with Lansweeper data in PowerShell. You can download the PowerShell script here (right click, save link as. What is noted in the document above does not mirror our tenant. Changelog 0.0.1 - 2019.07.13 First Release (draft) 0.0.3 - 2019.07.14 - Blog post with description: https://evotec.xyz/using-lansweeper-with-powershell-to-your-advantage/ First Public release Usage PowerShell makes working with rest API's easy. Lansweeper first tries to retrieve certificates using the Remote Registry service. It is modified to minimize the number of times it needs to generate new access tokens and to make it easier to use. To get those JSON Data you can simple use 3 lines of Powershell Code or any other language you perfer (Python, Java, C# or even assembly ) Quote: $response = Invoke-WebRequest -Uri "http://localhost:85/api/Values" # Use your API-Lansweeper URI here $data = ConvertFrom-Json $ ( [String]::new ($response.Content)) $data | Out-GridView EXAMPLE: LANSWEEPER #> param ([string] $ComputerName) if ( $ComputerName){start https: // lansweeper / quicksearch.aspx?q = $ComputerName} if ( -not $ComputerName) As soon as I add the API key to the URL I get a 500 Internal Server Error. If you never heard of Lansweeper, it's a great inventory tool that can scan Windows, Linux, Network, Printers, and other types of assets gathering it all in SQL Database. Using Lansweeper with PowerShell to your advantage. Audit and Take Action in 3 Easy Steps 1. I have found a module on the Powershell Gallery: https://www.powershellga.ges/Lansweeper-PS/1.30.5 However, I cannot get it to work. At its basics, I need to query and filter lansweeper assets and perform some tasks on each filtered asset. To get those JSON Data you can simple use 3 lines of Powershell Code or any other language you perfer (Python, Java, C# or even assembly ) Quote: $response = Invoke-WebRequest -Uri "http://localhost:85/api/Values" # Use your API-Lansweeper URI here $data = ConvertFrom-Json $ ( [String]::new ($response.Content)) $data | Out-GridView Usually, you would use their friendly, fast interface to access data it stores because it offers a lot of flexibility, export options, and many many features. Scripts. In the current iteration (which is maybe a weekend of work) it can pull info from the Assets table by searching an identifier such as name or IP address, and return all the object's properties from the table. Lansweeper only allows you to add time for yourself and it's cumbersome to reassign the ticket 3 times to get everyone's time added. To get those JSON Data you can simple use 3 lines of Powershell Code or any other language you perfer (Python, Java, C# or even assembly ) $response = Invoke-WebRequest -Uri "http://localhost:85/api/Values" # Use your API-Lansweeper URI here $data = ConvertFrom-Json $([String]::new($response.Content)) $data | Out-GridView The script will print warranty info for a Dell PC to the screen and save to the $response variable. can be used as "LANSWEEPER computer" or by running "LANSWEEPER" then being prompted to enter computer name.. Your Lansweeper scanning server must have a 64-bit architecture. It's a really small project (about 80 lines of code) but you can get lots of ready to go reports. SYNOPSIS: Send you to your internal lansweeper page. The main documentation for the Helpdesk API can be found in the Ticket API section in the application. Run the following tool found on the scanning server: Program Files (x86)\Lansweeper\Tools\ConfigEditor.exe, Hit the Add button under appSettings, Configure the popup as shown below and hit Add. Using that info it can also return basic tables showing anything from the assets table (picture below). Powershell Tools for Accessing APIs, Some of the tools provided in Powershell I will be discussing in this series are: Invoke-WebRequest, Invoke-RestMethod, ConvertTo-JSON, ConvertFrom-JSON, Setting a variable to accept XML response (without quotes) ' ['xml']'$somevariable =, After all that, if you still can't find a particular report you need, Lansweeper includes an easy-to-use graphical report builder. To get the data we want, and get it in Lansweeper, we'll use a combination of PowerShell, deployment and registry scanning. I'm working on something in Powershell that would all a tech to add a note and time for someone else, but I'm not seeing how to add time. These sections describe all the information related to the use of Lansweeper Cloud's API, including the endpoint needed to make queries, the correct process to authenticate for securely request information, and many examples about how to extract data. If the service is enabled but stopped, Lansweeper does attempt to start it. In PowerShell version 3, the cmdlets Invoke-RestMethod and Invoke-WebRequest where introduced. Your Lansweeper scanning server must have Windows PowerShell version 5.1. i wrote for myself Powershell script to get all HP computers/laptop assets from DB, use Powershell module to get warranty info thru SOAP API and update asset in DB . Invoke-RestMethod -Url "https://lansweeper.domain/api.aspx?key=12345" -Method Get I have tested different server names (FQDN and not), https and http, different methods (Post, Get). Lansweeper used to return detailed information on windows updates. Step 1: PowerShell Online prerequisites To enable PowerShell Online scanning, make sure that: Your Lansweeper scanning server must be running Windows 7 or a more recent operating system. The Lansweeper website also hosts hundreds of additional report templates, including over 230 just focussed on security topics, such as scanning for specific CVE vulnerabilities and "patch Tuesday" compliance reports. To start we'll need to grab the data using PowerShell and store it in a registry key. Lansweeper performs an automated warranty check and warranty scanning for assets whose manufacturer is Dell, Fujitsu, HP, IBM, Lenovo or Toshiba/Dynabook. These cmdlets are a huge improvement coming from the .NET model you had to work with previously turning a request into a concise one liner similar to curl (Which is also an alias for Invoke-WebRequest in PowerShell). Stop the Lansweeper Server service in Windows Services on the scanning server you'd like to put into debug mode. Function LANSWEEPER {<#. Run the Audit & Take Action How to Run an Audit Download Lansweeper to Run this Audit Harness the Power of Reporting Is there any supported way to integrate Lansweeeper into automation? Has anyone successfully been able to script help desk tickets with Powershell? Scan Your Network Configuring the First Run Wizard Overview of Scanning Methods 3. Since March it doesn't include updates in the scan info for some reason? EXAMPLE: LANSWEEPER computer. Get Information what Software is installed on Computers by HTTP Requests. ). Hit the Save button below your appSettings. If you want Lansweeper to use this method for certificate retrieval, make sure the Remote Registry service is enabled and running in Windows Services on your client machines. Collection of custom reports and scripts for use with Lansweeper, sql powershell-scripts lansweeper, Updated on Oct 12, 2021, PowerShell, MarcoGriep88 / API-Lansweeper, Star 4, Code, Issues, Pull requests, Web API for Lansweeper. Labels: General Discussion, 0 Kudos, Share, Reply, 1 ACCEPTED SOLUTION, To get those JSON Data you can simple use 3 lines of Powershell Code or any other language you perfer (Python, Java, C# or even assembly ) Quote: $response = Invoke-WebRequest -Uri "http://localhost:85/api/Values" # Use your API-Lansweeper URI here I've decided to write this simple PowerShell command that allows me to use Lansweeper in PowerShell. It's a really small project (about 80 lines of code) but you can get lots of ready to go reports. lansweeper, Updated on Jul 14, 2021, These can be run directly against lansweeperdb if you are using SQL Server as your back end, or executed using the DatabaseMaintenance.exe tool included with Lansweeper. It does need direct access to SQL. To get going you could use "Postman, by Google" which will test the calls to the API and see if everything is set up correctly. A mixture of PowerShell scripts that leverage data from Lansweeper, and also cleanup SQL scripts for maintenance of the Lansweeper database itself. This PowerShell script is a modified version of the one form the reddit post. The HP API has been down for a while and our fallback method of scraping the website, unfortunately, is non-functional currently as well due to changes at the end of HP. 1.2 PowerShell, Download & Install Lansweeper Download Lansweeper 2. . Provides a wrapper for dbatools to query Lansweeper SQL database to pull information about assets and users Minimum PowerShell version 3.0 Installation Options Install Module Azure Automation Manual Download Copy and Paste the following command to install this package using PowerShellGet More Info Install-Module -Name Lansweeper-PS Author (s)
Disable Azure Ad Sync Service, Husqvarna Automower 415x, Highland Cow Fleece Fabric, Best Resources For Adults With Adhd, Delta Monitor Handle Replacement, Powerwerx Distribution Block, Grey Shirt Jacket Women's, Baby Fleece Fabric By The Yard, Tommy Hilfiger Boyfriend Jeans Vintage,
