Create Time Chart

[RolandB]

Is it possible I can create a   Time Chart: New Software found daily

Have any an idea and what could the query look like?
I found this old article  Create a time chart - Lansweeper Community - 24815   and I don´t know what could the query look like.

[DavidPK · Accepted solution]

Hi Roland,

The community post did not include a full query—only guidance on where to find the database tables needed to build one. You will need to create your own custom report based on those references.
We recommend using the documentation links provided to help you identify the correct tables and fields. You may also use an AI assistant to help formulate the query, as long as you supply it with the necessary table structure and requirements.

If you are interested in building or modifying reports, we do recommend:

• Reviewing some SQL tutorials, as the Lansweeper report builder is a standard SQL editor. If you know SQL, you know how to build Lansweeper reports as well. 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: https://www.lansweeper.com/report/