Do you have tips on developing SQL reports for Lansweeper on-premises?

[Riley]

Do you have tips on developing SQL reports for Lansweeper on-premises?

[Riley · Accepted solution]

Our biggest recommendation is using AI, which will work with either On-prem reports (SQL) or GraphQL/MongoDB reports (Cloud Report Builder).

More info can be found in this link: Utilizing Lansweeper Documentation With AI - Lansweeper

Additionally, you can follow SQL tutorials. The Lansweeper report builder (for Lansweeper on-prem) is a standard SQL editor, so anyone who knows SQL can also use our report builder.  A quick online search will lead you to dozens of SQL tutorials, like this one: https://www.w3schools.com/sql/

Other helpful resources are our database dictionary, which explains in great detail what each table and field stores: https://www.lansweeper.com/knowledgebase/accessing-the-lansweeper-database-documentation/ and our report library, where we post new sample reports regularly: https://www.lansweeper.com/report/