Reports & Analytics

Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.

Topics in this forum

Sorted by:

Sign in/Join

Report Filtering Uptime

Hi Guy's,I was hoping an SQL wiz could help me.I have the below report. I am wanting to limit the report to two criteria.1st Machine last seen must be within 2 days2nd Uptime must me more than 7 daysThis report will be used to target users to frequen...

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

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, ...

Top Kudoed Authors

User

Count

4

2

1

1

1