I would like to create a report to find computers not using all available RAM. I think I need to compare the $PhysicalRAM to $InstalledRAM WMI attributes but I am not sure how to do so. Thank you in advance.
Hi!I have built some custom reports in order to get Lansweeper to accomplish the task of our central CMDB.For example, this report is showing all desktop-devices:
Select Top 1000000 tblAssets.AssetName As [Asset Name | Hostname],tblAssetCustom.Manufa...
Hi, I've been trying to get a report that will show me if a machine doesn't have the current Symantec Endpoint protection installed. I have it showing me ANY antivirus that is out of date, but that's part of the problem.I'd like a few reports in the ...
Dear All, I would like to create a report which displays the amount of laptop user was logged on as the last user. For example there will be plenty of machines where the Administrator account was used as the last logged on user. I would like to displ...
I have some laptops that are in a Asset Group. These laptops are borrowed for presentations , or work in travel etc. What I need is an notification (alert or email or report etc) that can notify me when the borrowed time/date has expired so I can cal...
Hi Everyone,I am looking for some assistance combining two separate reports (our dev guy is out for a month).Rather, I need a registry value from the second report to appear in the first one, or just show blank if it doesn't exist.One report lists PC...
Does anyone have a report or SQL Query to see what PC's have reported in using LSPUSH? I searched the Forum and the built-in reports but couldn't find one.Thanks,Nik
The script provided earlier to this topic failed when ran:Invalid SELECT statement. Unknown object name: "tsysOS".: Unexpected token "tsysOS" at line 0, column -1Can someone provide a fix?
