Custom report

[dlafleur]

Good morning, folks in Lansweeper Land.
I am looking for a report or reports that will hard disk, VM Disk adds, and server adds along with Servers that have been removed.

Would anyone have something like this that they would be willing to share?

Thanks
Dave L.

[DavidPK]

Hi Dave,

We added a sample report below that should return the information you are after. Additional fields and/or filters on e.g. the specific states can of course still be added. Instructions for adding this report to your Lansweeper installation can be found

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/

SELECT
    tblAssets.AssetName,
    tblAssets.Domain,
    tblDiskDrives.DiskID,
    tblDiskDrives.Size,
    tblDiskDrives.Description,
    tblDiskDrives.LastChanged
FROM
    tblAssets
INNER JOIN
    tblDiskDrives ON tblAssets.AssetID = tblDiskDrives.AssetID
WHERE
    tblDiskDrives.Description LIKE '%Virtual Disk%'
    AND tblDiskDrives.LastChanged > GETDATE() - 7
ORDER BY
    tblAssets.AssetName, tblDiskDrives.DiskID;