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
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Forum Posts

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
  • 8221 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
  • 5628 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
  • 4357 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
  • 5448 Views
  • 3 replies
  • 0 kudos

Report for Notebooks and Laptops and LSAgent

Hi,i´m not very familiar with sql, but i would like to build a report regarding the dynamic group "Laptops" und the static group "Notebooks" to check if the installation of LSAgent was successful. It would be nice if this report will only show the No...

daniel_kr by Engaged Sweeper
  • 3533 Views
  • 1 replies
  • 0 kudos