Hi I am tryning to build a report with specific parameteres. The most important are Working time and a custom field from htblticketcustomfield, named OfficeLocation. I was able to get the result but can it be optimised some how?Select Top 1000000 htb...
Hoping that someone else has already tackled this. I'd like a report of all Windows devices with Duo installed ("Duo Authentication for Windows Logon"). The report should show the following registry values for each asset with the program installed. A...
Dear Lady's and Gents,I been asked to make a custom lansweeper report but im not really a SQL expert :).I searched multiple lansweeper posts, but didnt quite found my answer. I was looking for the following:I need a custom report that shows: AssestNa...
My SQL is not upto scratch, and I found this code, but would like it to just run for this current month.Here is the code and Select Top 1000000 htblteams.teamname As team, totalTickets.totalCount As [All Closed Tickets], onTimeTickets.onTimeCount A...
Hi,How would I go about making a report to list members of a specific O365 group with each asset the member "owns" (we setup an ownership relationship between an AD user and their computer - but using "last logged in" computer could work too)?...I as...
I'm attempting to create a report containing all Windows 10 Pro operating systems, as we need to upgrade them to Enterprise. I've tried a number of SQL variables related to the OS but so far have had no luck returning a successful report. What's the ...
Can somebody please help me edit this report so that instead of listing software as up to date it will just exclude it in the report? I have a report that has over 1000+ assets listed for outdated software but in reality only 40 of them are actually ...
