Reports & Analytics

SQL Server Report - Count Of Assets

Hi ,Does anyone have a SQL Server report which gives a count of SQL for each device, the issue I'm having is its returns multiple instances per device because of the number of SQL Server services running , also if its 86 or 86 and 64 , I just need a...

Asset-User Relation Report

Hi,I got a report to display the Asset Description + the user + relationship type (like Used by). But for AD group, it just shows Used by blank.Anyway this is fine up until the report also displays disabled user using active asset. Then I had to put ...

Windows 10 Version Chart

I'm trying to build a chart report that displays the different versions of Windows 10 we have in our environment. I'm trying to simplify it for management and using 'Case' to display the layman's versions but I keep getting errors trying to do it. ...

Report for "Country or region", "Regional format", "Windows display language" and "Keyboard layout"

Dear Community,I am working on a task to create a report that contains the following entries of our asset base, which is (mostly) Windows10 PCs:- Country or region (from Settings->Time&Language->Region)- Regional format (from Settings->Time&Language-...

Show Date Without Time

Hello,I am hoping to get some help with this report. I'd like the Creation Date and Last Update Date to show as DD/MM/YYYY WITHOUT showing the time.SELECT TOP (1000000) '#' + CAST(htblticket.ticketid AS nvarchar) AS Ticket, htblticket.date AS ...

add Windows Update KB Title on report 'Installed Windows Update query'

Thank Lansweeper which provided the good report 'Installed Windows Updates query' to list out what KB has installed on end user workstation. We would like to add 1 more information - 'KB Title'. We have tried on tblQuickFixEngineering query but unabl...

Software authorization report grouped by publisher/Approved status

Hi allI am not sure if the following is possible, but I thought I would ask just in case.We managed to create (with the kind help of someone here), a report of all the software, number of installations and whether its approved or not. Basically the S...

Cryptojacking related reports

Hi All,We've just published a new blog and reports covering a cryptojacking use case.There are 3 new reports included:CPU UtilizationFacexWorm Chrome extensionComputer Processes

Reports & Analytics

Topics in this forum

SQL Server Report - Count Of Assets

Asset-User Relation Report

Windows 10 Version Chart

Report for "Country or region", "Regional format", "Windows display language" and "Keyboard layout"

Show Date Without Time

add Windows Update KB Title on report 'Installed Windows Update query'

Software authorization report grouped by publisher/Approved status

Cryptojacking related reports

Report for Missing Software Using Another Software...

Query inside of another query?

DiskPartition Changes Report

Report - KB report details for the month of Februa...

Query Report al Instance DB SQL e no SQL

Report to see what machine upgrade Windows

Hyper-V report with CPU information

Windows devices with Uptime more than 30 days

Windows 11 readiness report - storage not working ...

Report for Local Administrator accounts on All Ass...