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

Help reporting a funky timestamp from registry

I am reporting on a registry value that produces a time stamp that looks like '20181025162152.000000-420'. I simply want to convert this to a short date that Excel can read. Using the example time stamp above it should look like '10/25/2018'.I was ...

STRiCT by Engaged Sweeper
  • 11100 Views
  • 8 replies
  • 0 kudos

Resolved! Report with duplicates

Hi,I'm creating a Report with all Windows 7 Computers and their Hardware. Im getting multiple lines per Asset. What am I missing?Thanks!Select Top 1000000 tblAssets.AssetID, tblAssets.AssetUnique, tblAssets.Domain, tsysOS.OSname, tblComputersyste...

pscholz by Engaged Sweeper
  • 6577 Views
  • 5 replies
  • 0 kudos

Out Of Warranty in 90 days by ChassisType

hi all, below is my statement. the below generates all assets and does not provide me with the 90 days. can anyone help advise please.Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon, tblAssets.AssetID, tblAssets.AssetName, tblAssetCustom...

kiran by Engaged Sweeper
  • 2905 Views
  • 1 replies
  • 0 kudos

Custom Inventory audit report

I am trying to generate essentially an Audit ReportThe below is what we have so far, But i would like to add: - Free Disk space on the C: in GB- If Parallels Client 64 bit is installed and What version- the username of local admin account- and instal...

Office Standalone 32bit or 64 bit Report?

Is there a way to reliably find out if around 150 PCs have 32bit or 64 bit versions of the standalone office installer. These PCs are not bundled with outlook which means Bitness isnt a reliable way to find out. Ive also tried comparing program file...

adip by Engaged Sweeper
  • 3631 Views
  • 1 replies
  • 0 kudos

AWS: AMIs (Built-in)

The report below gives back a list of AWS Machine Images (AMI).The report will only list AMIs when the following criteria are met:You have Lansweeper 7.1 or higher.There is AWS AMI data scannedSelect Top 1000000 tblAWSAmi.ImageId, tblAWSAmi.Name, t...

Esben_D by Lansweeper Employee
  • 1812 Views
  • 0 replies
  • 0 kudos

AWS: Dedicated Hosts (Built-in)

The report below gives back a list of AWS dedicated hostsThe report will only list assets when the following criteria are met:You have Lansweeper 7.1 or higher.There is AWS dedicated host data scannedSelect Top 1000000 tblAWSHost.HostId, tblAWSHost....

Esben_D by Lansweeper Employee
  • 1858 Views
  • 0 replies
  • 0 kudos

AWS: Instance AMI (Built-in)

The report below gives back a list of AWS Instance AMIs.The report will only list AMIs when the following criteria are met:You have Lansweeper 7.1 or higher.There is AWS Instance AMI data scanned.Select Top 1000000 tblAssets.AssetID, tblAssets.Asset...

Esben_D by Lansweeper Employee
  • 1132 Views
  • 0 replies
  • 0 kudos