I have a report that has been created by my team which can be found below. It is great but I would like for the report to show full OS build. Currently it is only showing the OS version but not Edition. Ie Windows 2012 R2, where as I would like the r...
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 ...
