This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
Community FAQ

Reports & Analytics

Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Topics in this forum

Sign in/Join

Resolved! Add displayname or email to existing report

Can someone help me adding user displayname and/or full email adress to the native report called "Asset: Out of warranty"Default it looks like this :Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon, tblAssets.AssetID, tblAssets.AssetName, ...

Morten by • Engaged Sweeper
  • 3719 Views
  • 2 replies
  • 0 kudos

Tickets Created and Closed per month on one report

Hi All,I am trying to get a report that shows created and closed tickets on the same report or SQL query.I have attempted to use a combination of the pre-loaded reports for Created and closed but am unable to get the details on the same report. Is th...

dan-jones by • Engaged Sweeper
  • 2480 Views
  • 1 replies
  • 0 kudos

USB printers with toner levels

Hi there,I was wondering if there was a report that can be made that can pull all of the USB printers that are connected to computers (I have some code below that I pulled from a different thread)but also have a column for toner. Is this possible?Sel...

ajokerst by • Engaged Sweeper II
  • 4374 Views
  • 3 replies
  • 0 kudos

Showing all assets without a department

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...

JTempleton by • Engaged Sweeper III
  • 3057 Views
  • 1 replies
  • 0 kudos

Count by Department

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...

JTempleton by • Engaged Sweeper III
  • 4784 Views
  • 3 replies
  • 0 kudos

Adding computer type to Windows 10 report

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...

chenegh by • Engaged Sweeper II
  • 4802 Views
  • 3 replies
  • 1 kudos

Hardware Inventory

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...