Hi,I am trying to create a report that shows assets that are out of warranty by a set time. I have modified a previous report that I found to include the Asset Location The Asset location is set here for each asset Sometimes there is an asset which ...
I am having trouble creating a report that will show me computers that are not a member of a certain AD Group. Any help would be greatly appreciated.Thank you.
Trying to get desktops over 5 years old based off of the purchase date. Here's what I have so far... I'm new to SQL, so please forgive and inefficiencies. It doesn't seem to grab everything...am I missing something? Select Top 1000000 tblAssets.Asse...
Can I see in Lansweeper if a user has disconnected a monitor? I am trying to find a way to detect if a user takes a monitor from one computer and plugs it into another.
I am looking to run a report where it will give the Name of the asset, IP, Hardware info, and the software that is installed on the machine. Here is an example.Machine1 1.1.1.1 PowerEdge 2650 Adobe Chrome ...
I want to create report for unmoved computers with user name and USER OUI create it but I want to add user OU in reportSelect Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tsysAssetTypes.AssetTypename, tsysAssetTypes.AssetTypeIcon10 As icon,...
Hello,I have a report that shows computers that are missing the Firewall Single Sign On agent and I was wondering if there was a way to make it so that it only shows computers who are in the DHCP pool?Our pool is 192.168.90.1 - 192.168.92.254Current ...
How can I add a column for "Last User" to log on to the machines in all reports?
Does anyone know how to change the trigger for the low disk space alerts on workstations? I would like to either increase the trigger from 1 GB to either a 10 GB alert or to a percentage alert like 5% of disk space.
