What tips or best practices are available for creating SQL reports?

[Obi_1_Cinobi]

If you are interested in building or modifying Lansweeper reports in your Lansweeper On-Prem installation, we recommend:

• Using AI to help you build queries. AI will work with either SQL reports (On-prem Report Builder) or GraphQL/MongoDB reports (Cloud Report Builder). More info can be found in this link: Utilizing Lansweeper Documentation With AI - Lansweeper

• Reviewing some SQL tutorials, as the Lansweeper report builder (for Lansweeper on-prem) is a standard SQL editor. If you know SQL, you know how to build Lansweeper reports as well. A quick online search will lead you to dozens of SQL tutorials, but this seems like a good tutorial: https://www.w3schools.com/sql/
• Making use of our database dictionary, which explains in great detail what each database table and field stores. More information on the dictionary can be found here: https://www.lansweeper.com/knowledgebase/accessing-the-lansweeper-database-documentation/
• Checking out our report library, where we post new sample reports regularly: https://www.lansweeper.com/report/