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: 

Topics in this forum

Repor needed with one HDD per PC

Hi all,I need a report that will have pc model, manufacturer, operating system, memory and total size of HDD.I can create the report except getting the total HDD size (i can get it by partition). Is there a solution for this?Regards,

simonch by Engaged Sweeper II
  • 458 Views
  • 1 replies
  • 0 kudos

Report for Disconnected Users

is there a way to run a report that shows all users that are logged into a workstation but are in a disconnected state? I'm talking about someone who logged in and then walked away and never logged out and its like 5 days later and now I have 4 diffe...

Privileged AD Users in Local Groups Report

I decided to analyze AD users for administrative rights on local machines and wrote this query with 3 levels membership: Select Top 1000000 tblassets.AssetID, tblassets.Domain, tblassets.AssetName, tblUsersInGroup.Groupname As local_adm_group_n...

Resolved! OU Report

Hello,I want to be able to pull a report, based on specific OU, with the following information in itSite(OU) | Computer Name | Model | Serial# | OS | Last recorded user with date | Warranty Info Ultimately, I would want a report for each OU I have,...

GreenCup by Engaged Sweeper II
  • 12206 Views
  • 6 replies
  • 0 kudos

Error in August 2024 Patch Tuesday Report

The SQL query has a command "Try_convert" in it.  This is an invalid command.  Revised code below.   Select Distinct Top 1000000 Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon, tblAssets.AssetID, tblAssets.AssetName, tblAssets.Domain,...

CarlV by Engaged Sweeper
  • 724 Views
  • 3 replies
  • 0 kudos

Can't use plus (+) in report names

Wasn't sure the best place to put this, but I noticed that you cannot name reports with a plus sign.  In my use case, I was tracking outdated installs of software (notepad++ in this case) and the + signs are dropped when I save the report.

jwood-ok by Engaged Sweeper II
  • 524 Views
  • 2 replies
  • 0 kudos