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! User with more then 1 computer

Hello,I want make/have a query that show a list with user that have more then 1 computers as last logged in.In that way we can figure out who have still old computer or second computer which is not allowed for us.Does somebody have similar report or ...

jmichiels by • Engaged Sweeper III
  • 9996 Views
  • 5 replies
  • 1 kudos

Resolved! Hyperlinks in Reports through Excel-Import

Aloha,i am "importing" reports directly into Excel over SQL-Import. However the hyperlinks of the assets are gone after i did the import. When i run the report directly in Lansweeper the hyperlinks are working.Is it possible to get the hyperlinks for...

Nukular by • Engaged Sweeper
  • 7556 Views
  • 3 replies
  • 0 kudos

Resolved! Duplicate entires

Hi im having an issue with duplicate entries on tblSoftware. Essentially i want to show all the software installed on the various computers and who was the last user to log on. I have tried something similar to the link below but with no success. Any...

chrisjones by • Engaged Sweeper II
  • 4012 Views
  • 1 replies
  • 0 kudos

Resolved! Computer model summary with Custom Field

I use the custom20 field to hold the planned retirement year of of our computers. I'd like to be able to run the "Computer model summary" report and have the Custom20 (Retirement year) show. I think because this is consoldated report it doesn't wan...

murpmic by • Engaged Sweeper III
  • 5333 Views
  • 1 replies
  • 1 kudos

Resolved! Report showing Windows assets missing Java

I am trying to create a report that will have all the assets that do not have Java installed on them. I have this report that shows all of them that are not at the current version:Select Top 1000000 tblAssets.AssetID, tblAssets.AssetUnique, tblSof...

sullivane by • Champion Sweeper III
  • 5228 Views
  • 2 replies
  • 0 kudos

Resolved! Report Hostname + Last User

I am trying to create a report to generate Computer names and last logged in user.My final goal would be to match last user to AD property "MangedBy", but I don't if that's possible. If it is the I would like to flat it if there is a difference. Can ...

ogeccut by • Engaged Sweeper II
  • 7096 Views
  • 1 replies
  • 0 kudos

Resolved! Assets with Relational mapping report

Hello,I'm a SQL novice and I need help generating a custom report that has the following fields for Windows/PC Systems:System/PC NameIP LocationPC TypePC ManufacturerPC ModelPC Serial Number# of monitor(s) connectedMonitor Manufacturer(s)Monitor Mode...

MCXCCR by • Engaged Sweeper
  • 5405 Views
  • 2 replies
  • 1 kudos