About Nick_VDB

Nick_VDB · 09-20-2017

Old name: License: License expiration < 60 daysThe report below gives back a list of software license contracts expiring in less than 60 days.The report will only list licenses that meet all of the following criteria:There is software license contrac...

Nick_VDB · 09-20-2017

Old name: License: License expiration < 90 daysThe report below gives back a list of software license contracts expiring in less than 90 days.The report will only list licenses that meet all of the following criteria:There is software license contrac...

Nick_VDB · 09-13-2017

The report below gives back a list of assets that have a ticket linked to it and a count of the number tickets that are linked.The report will only list assets that meet all of the following criteria:The assets state is set to 'Active'The asset has a...

Users: AD user has no e-mail address · 09-13-2017

The report below lists users in Active Directory that have no e-mail address filled in.The report will only list users that meet all of the following criteria:The user was scanned in Active DirectoryThe user has no e-mail addressSelect Top 1000000 tb...

Nick_VDB · 08-09-2017

Added in v.6.0.100The report below will give back Windows computers the last users that logged on to the computer.The report will only list assets that meet all of the following criteria:The asset state is set to "active".The asset has been successfu...

Nick_VDB · 09-19-2017

We are not quite sure if you have any questions related to the report that you posted.

Nick_VDB · 09-18-2017

The secure boot state is currently not scanned by Lansweeper. However, it is possible to scan the registry location of the secure boot state and pull a report the value of the registry key to check if it enabled or not. You can setup registry scannin...

Nick_VDB · 09-13-2017

We would need to see the full report to check what may be causing the error that you are getting back. If you can post in this thread we will have a look at it.

Nick_VDB · 09-01-2017

We did some modifications to the query by making use of sub-queries so that each custom field gets their own column.Select Distinct Top 1000000 htblticket.ticketid, htblticket.subject, htblticket.date, CustomField1.name As Name1, CustomField1.dat...

Nick_VDB · 08-18-2017

We filtered out all PC's, Windows, Linux and Apple Mac.Instructions for adding this report to your Lansweeper installation can be found here. If you are interested in building or modifying reports, we do recommend:Reviewing some SQL tutorials, as the...

User Statistics

User Activity

License Compliance: Expiration < 60 days (Built-in)

License Compliance: Expiration < 90 days (Built-in)

Assets: Has tickets (Built-in)

Users: AD user has no e-mail address

Windows: Last logon detected during scanning, per user (Built-in)

Re: Windows 10 version

Re: Report to read if Secure Boot is Enabled

Re: Problem with the generation of a new report

Re: Helpdesk Reports with Custom Fields

Re: Report except for devices