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: 

Forum Posts

Sign in/Join

Resolved! How do I add tblADusers

Hello. I found a report to list mac addresses and added the portable battery and IPLocation at the request of managment to try and output all laptops asset name, domain, network card, mac addresses, ip, last changed, userID, IPlocation and got a goo...

praetor11 by • Engaged Sweeper
  • 6609 Views
  • 2 replies
  • 0 kudos

Assets that have Changed State in the past 24 hours

I am trying to create a report that will show an asset that has had a state change within the past 24 hours. This report will be used to auto email the asset manager that an asset has changed, for example: we take an asset out of service to be recy...

ahedden by • Engaged Sweeper II
  • 8604 Views
  • 5 replies
  • 1 kudos

Resolved! Multiple IP report

Is there a way to get the Computer: IP List report to show ALL the IP addresses associated with a system? Just trying to track down users running wireless and wired connections.

Brendan440 by • Engaged Sweeper II
  • 7778 Views
  • 2 replies
  • 1 kudos

Windows Assets report - Active and Non Active

Hello,Could anyone help how I can get a full list of all active and ALL non active assets, at the moment i'm unable to show all inactive Microsoft hardware or assets contained in the domain OU (not listed here).Type | Vendor | Asset Type | Model | As...

Resolved! Calendar Reports

Is there a way to run a report on the calendar to see what event types have been added?

Zacs by • Engaged Sweeper III
  • 4778 Views
  • 1 replies
  • 0 kudos

Resolved! Show full OS build

I have a report that has been created by my team which can be found below. It is great but I would like for the report to show full OS build. Currently it is only showing the OS version but not Edition. Ie Windows 2012 R2, where as I would like the r...

Ismail by • Engaged Sweeper II
  • 5406 Views
  • 1 replies
  • 0 kudos

Resolved! Hardware/Software Poll

The information I am seeking are the following fields:Last known userOSIP addressIP locationLast seenLast triedComputer nameCPUI have basically taken the built in report named "OS: Operating system overview", added in the "tsysIPLocation" table and c...

dalbright by • Engaged Sweeper
  • 4894 Views
  • 3 replies
  • 0 kudos

Resolved! Support for nested queries?

I want to list all assets from a hard-coded list and next to each asset, the version of CrashPlan installed, or blank where it is not installed.Here is my query:Select tblAssets.Username , (select s.softwareVersion from tblSoftware s inner join t...