Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.
The information I am seeking are the following fields:Last known userOSIP addressIP locationLast seenLast triedComputer nameCPUI have basically taken the built in report named "OS: Operating system overview", added in the "tsysIPLocation" table and c...
I want to list all assets from a hard-coded list and next to each asset, the version of CrashPlan installed, or blank where it is not installed.Here is my query:Select tblAssets.Username , (select s.softwareVersion from tblSoftware s inner join t...
We track our software usage & purchases by Department. I have added a Department code to Software Purchase information in the Comments field. I am able to create a report to show me the count of purchases by DepartmentsSelect Cast(tblSublicensesOrd...
Greetings,I am a newbie and I don't know the system well enough to do what I am looking to do. I have defined locations (IT, Marketing ...). I have pinned locations to some assets. I created a report to give me all Windows systems with the query belo...
I'm very new to building Lansweeper reports. I'm not sure if someone has posted this already but I was seeing if someone could please walk me through creating a report for Windows 10 machines that includes the OS build version? Thank you in advance!
I've tried various SQL statements but cant get it to format correctly. Basically, I need to see all my closed and open cases for the last 7 days with the subject, date, user name, and notes (all of them not just the initial notes). Can somebody help ...
Hello, We recently went through and added every asset that exists in LanSweeper to one or more groups based on the line of business they belong to. What I am trying to do now is make a report that will shows me total amount of CPU/CPU Cores/Memory in...
I am been trying to create a single report that includes all the SQL Server (any version), MS Visio and MS Project installed in my environment, so far, haven't been able to do so, has anyone ran into this type of report before?
