Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.
The report I want is to return one asset per line, and to include both its bios age and its warranty age in that line. I have accomplished this by modifying the bios age report and adding warranty age, but now I am getting duplicate asset lines. How ...
Trying to find the best way (easiest) to sort a report that is sorted by asset type to keep servers together, workstations, and maybe even laptops/tablets/notebooks. I do not know of a way to create a server asset type.
I need to show two different values of the same attribute in one report. To be more specific. In the report we want to see the currently installed Office Client LIKE 'Microsoft Office Professional%' OR 'Microsoft Office Standard%' OR 'Microsoft Offic...
I have a chart report that works well but I want to refine it a little bit. The report queries a group of workstations, determines what version of java is installed and presents that in a bar chart with totals for each version. Currently, there are 3...
Hi folks,My SQL is still rubbish. I have tried to work this out combining aspects from other reports, but I am getting nowhere.I need a helpdesk report that shows time worked per ticket type in the last 7 days.Sorted by:1. Ticket Type2. Time Worked3...
What is the proper syntax for this operation? I have tried the following:Where tblAssets.AssetName = In ('asset name 1', 'asset name 2', 'asset name 3', 'asset name 4', 'asset name 5')orWhere tblAssets.AssetName = In "'asset name 1, 'asset name 2'I h...
Hi All,Looking to add Bluebeam Revu Licenses to the "Scanned License Keys" section on Lansweeper.Has anyone done this one yet?Thanks,Chris
I am running the following report, however, I am missing computers, the built in Asset report detects it, I think the common denominator is no user logged onSelect Top 1000000 tsysOS.Image As icon, tblAssetCustom.AssetID, tblAssets.AssetName, tblA...
