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! Report showing device types by group

Hi,I'm looking for a report which will give me a count of certain device types by group. For example I have a group named "Milan" which contains all machines in the Milan IP ranges (we have multiple ranges per site).I managed to create this report by...

Resolved! Add Report Column showing Office version

Hello,I have a report that works well. It lists all of our floater (loaner) laptops. Here it is.Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon, tblAssets.AssetID, tblAssets.AssetName, tblAssets.Description, tblAssets.Domain, tblAssetG...

Jono by Champion Sweeper II
  • 6776 Views
  • 4 replies
  • 0 kudos

Resolved! OS Update Report

may be a bit difficult to come up with, but looking for a report that shows if OS updates have failed, or the last time they were looked for or installed. I did see another topic about this, but there was an error on the report.

BrianM by Engaged Sweeper III
  • 5746 Views
  • 1 replies
  • 1 kudos

Resolved! Remove Asset from Scan Error Report

Hello community,is it possible to remove a specific asset from the Error lists (Error: WMI access denied, Error: RPC Server unavailable, OS: Never scanned OS)?We have some assets that couldn't be scanned and this is ok so. But I like to remove them f...

pskup by Engaged Sweeper III
  • 11483 Views
  • 7 replies
  • 0 kudos

Resolved! SQL Server report including Databases names.

Dear Sirs.I'm looking for a custom SQL report that will provide the following information to be exported on an excel spreadsheet:1. Server name2. SQL version installed3. serviceName4. List of Database names on the SQL instance. Do you know if this is...

AlconCusi by Engaged Sweeper
  • 9958 Views
  • 2 replies
  • 0 kudos

Resolved! Query Assets in Multiple Groups

I have basically no knowledge of SQL and I'm trying to query assets that are in multiple groups. For instance: Both "Classroom" and "Longmeadow". I can only manage pulling a report of one AssetGroup. Using an AND command only returned an error.Thanks