After some poking around I found the values I wanted in the tblComputersytem and tblComputers tables.Īs you can see above, I’ve linked to tables together with a join by dragging Computername from one table to the other. Selecting the items from the tables will produce those items in the final report. After messing around a bit I found you could drag and drop tables from the table list over to the builder piece. You’ll notice the Report Output tab and the Report Builder Tab…we wanna go to the Report Builder Tab. Make sure you are logged on here with enough rights in SQL to do the magic you need. First open up lsbuilder:Īs you can see I’ve got SQL Express loaded on locally so it’s pointing back to itself. Unfortunately, this report didn’t exist in the base tool, so I created it on my own. I wanted a report of Computer Manufacturer, Computer Name, Computer Model and the last logged in user. However, lsbuilder is just an easy way to create your own SQL queries so you could probably do that with the standard SQL tools.
To do this you need lsbuilder, which is part of the Premium Version.
I’ll let you check out the basics for yourself on their demo site, but I thought I’d walk you through how to extend the reporting functionality. What I like about it is that it’s very extendable and it’s pretty easy to create your own reports. I’ve been using it for a few months now and it’s become one of my favorite tools. There is a Premium Version that provides some extras that are well worth the investment. Lansweeper is a free and very cool tool for network inventory purposes.