Hello,from the button "Software" I can see all software found in my Assets list.Is it possible have a report of Software that lasweeper found only in a specific Asset Group?Regards
Hi,We have a report as below and a static group already set up "Critical Systems". What we need to do is only show results for that static group. Can you help? Apologies in advance but we have no SQL skills in-house .Select Top 1000000 tblSoftwareUn...
Hi All,We have a custom field (drop down) in our Tickets for "Location" used to select geographic locations that a ticket relates to (only 4 possible values in the drop down). I would like to modify the standard Lansweeper Report "Helpdesk: Count of ...
I have pieced together this report that reports the full OS Build of Windows 10. It works, but it relies on 2 custom registry scans. The 2 custom scans are both from \HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion. One is ReleaseID...
I am trying to write a report to find assets within our US domain, that are tied to the tblADUsers.Department %IT% and do no have versions 6.0.0 or 6.0.1 of Traps on their system. I run the code below and what I get back is a bit of a mess, looking f...
In light of the closing Windows 7 EOL date, you can use the report below to check whether your workstation are ready for a Windows 10 upgrade. The report checks the hardware requirements and if an in-place upgrade is possible or not. The specificatio...
This report shows you overlapping IP scan ranges and the assigned site server. Select Top 1000000 t1.IprangeID As [1 Range ID], t1.Servername As [1 Scanning server], t1.Ipstart As [1 Start], t1.Ipend As [1 End], '<----->' As [=], t2.IprangeID As...
Hello, I'm trying to write a report that gives information about the monitors, not so much about the computers they are attached to.So far this is what I have:Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tsysAssetTypes.AssetTypename A...
