Is there a way to get the Computer: IP List report to show ALL the IP addresses associated with a system? Just trying to track down users running wireless and wired connections.
Hello,Could anyone help how I can get a full list of all active and ALL non active assets, at the moment i'm unable to show all inactive Microsoft hardware or assets contained in the domain OU (not listed here).Type | Vendor | Asset Type | Model | As...
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...
