Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.
I tried creating a report to show all assets which have no department showing. It is not happening to all assets, but some assets are showing multiple times. Where did I go wrong in making the report? All fields show the same information.Select To...
I am trying to get a count of our assets by department. I have created this report, but it only counts up to 554. When I look at our configuration/License page, it says we have 1779 licensed assets. I am not sure what is wrong with the report. Th...
We have a Windows 10 report that we would like to also show whether each asset is a desktop or a laptop. What do we need to add to the report to show these?Here is the Windows 10 report we have:Select Top 1000000 tblAssets.AssetID, tblAssets.AssetUn...
I decided to publish some of my reports.Problem: collect HW inventory.Solution: LS HW Inventory Report.Select Distinct Top 1000000 tblAssets.AssetID, tblAssets.AssetName, tblBaseBoard.Manufacturer As MBManufacturer, tblBaseBoard.Product, tblAsset...
Has anybody written a report that lists windows activation status?
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...
