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! List owner of an asset

HiI use this report to list computers etc i Our AD. Select Top 1000000 tblADusers.Company, tblAssets.AssetName, tblstate.Statename, tblAssets.Username, tblADusers.Firstname, tblADusers.Lastname, tsysAssetTypes.AssetTypename, tblAssets.SP, tbl...

jimmern by • Engaged Sweeper II
  • 7430 Views
  • 2 replies
  • 2 kudos

Resolved! All Windows Servers and All Linux Red Hat Servers

I've been trying to get a report that provides all my Windows servers and all my Red Hat Linux servers in one report..Here is my "All Windows Servers" that has some custom fields returned..Select Top 1000000 tblAssets.AssetID, tblAssets.AssetName, ...

Resolved! Report listing machines running Office x86

I need to build a report that will scan for computers that have the 32-bit (x86) version of Microsoft Office (any version) installed. I checked around and it seems like even the x64 version of Office creates folders and installs software in both Prog...

DSKIM by • Engaged Sweeper
  • 8137 Views
  • 3 replies
  • 0 kudos

Adding OS to my report

Select Top 1000000 tblAssets.AssetID, tblAssets.Username, tblAssets.AssetName, tblAssetCustom.Model, tblAssetCustom.Manufacturer, tblAssetCustom.Serialnumber, tsysAssetTypes.AssetTypename, tblProcessor.Name As CPU, tsysAssetTypes.AssetTypeIco...

Adding OU to a Report

Hi All,I am having issues adding OU and computer model to the following Hard drive size report.please can someone assist? here is the SQL i am using for HDD sizeSelect Top 1000000 tblAssets.AssetID, tblAssets.AssetName, Sum(Cast(Cast(tblDiskdrives....

magson by • Engaged Sweeper II
  • 5575 Views
  • 1 replies
  • 0 kudos

Report for Discs in Drives e.g. CDs/DVDs etc.

This may be a bit of an odd request, but I think for me it'd be helpful to have a report to tell you which computers have discs in the drive - only because we use a number of CD/DVD tools for diagnostics, windows installation etc. and although we nor...

alewis by • Engaged Sweeper
  • 4325 Views
  • 3 replies
  • 0 kudos

Resolved! Chart report with count of Chassis Type

I'm trying to create a Chart report to count each of the Chassis types in our environment. I have a report that gives me the Chassis type, but having trouble turning it into a count of each type:Select Top 1000000 tsysOS.Image As icon, tblAssets.As...

galesj by • Engaged Sweeper II
  • 5376 Views
  • 3 replies
  • 0 kudos