Need help with two reports
Hi,I need help to make two reports:-Create a report on the unsuccessful admin account login.-Create a report on Attempts to Access Deactivated Accounts.Kind regards,Zakhar
Topics in this forum
Calculate computer online time (needs SQL Server)
This report function can be executed only if the Lansweeper database is running on SQL Server.Before creating and/or running the report, connect to your database with SQL Server Management Studio under the sa account and execute the following SQL cod...
Total Space & Free Space
HiI am looking to create a report to show the space servers have free and the total space. I have found a report that does what i want but shows the disk spaces in MB and i would prefer GB I was just wondering if there is a report that can show total...
IP4 not IP6
HII am having problems to create an asset list withAssetnameRAM in GBMemory in GBDisk in GBManufacturerModelOSnameIP4 Adresse which have now a ping respond ( switcht on)I can get IP Adresse but then I get also the IP 6 Adresse and in the moment I am ...
How to Edit Assets pulled by a Report?
I found a report that will pull all assets that don't have a user relation. How do I go about editing just the asset from this report to add the user relation to them?
Display Windows workstations that are Active state
Hi, does anyone know how to create a report that shows only Windows workstations that are in a Active state?Thanks!
Last Windows Update
There is a chart report Last Windows Update Chart QueryAnd the SQL query is:Select Top 1000000 Case When LastPatchDate.lastPatchDate >= DateAdd(day, -7, GetDate()) Then '1. less than a week' When LastPatchDate.lastPatchDate < DateAdd(day, ...
Resolved! Report showing multiple entries for same device
I am making a custom report that works but entries are duplicated multiple times. I have 78 printers and the report displays the printers IP location, Manufacturer, Model, SerialNumber, AssetName, Location (Custom Field 01), and the IPAddress.I have...
