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! Using subqueries?

I am trying to get all of the machines that are not at the highest version of Windows 10. I get get the highest version:Select Max(tblOperatingsystem.Version)From tblAssets Inner Join tblOperatingsystem On tblAssets.AssetID = tblOperatingsystem.A...

laurin1 by • Engaged Sweeper III
  • 3895 Views
  • 1 replies
  • 0 kudos

Resolved! Request for Report for Event ID 1055

We are seeing a large quanity of this error:GroupPolicy Event 1055 System NT AUTHORITY\SYSTEMThe processing of Group Policy failed. Windows could not resolve the computer name. This could be caused by one of more of the following: a) Name Resolution ...

del019589 by • Engaged Sweeper
  • 7269 Views
  • 1 replies
  • 1 kudos

TPM Status

Is there a way to pull the TPM status of a machine? I imagine there is a way in windows, since starting Bitlocker does an in-windows check for the TPM activation. If so, how would you create a report to retrieve said info? Ideally it would pipe ev...

Stored Procedure

Is there a way to run a stored procedure when using SQL datanase to return a report. I am trying to pull a report of all Auto desk products installed. When using the following query:Select Distinct Top 1000000 tblSoftwareUni.softwareName, tblAssets....

BadenhoA by • Engaged Sweeper
  • 3836 Views
  • 1 replies
  • 1 kudos

USB Device (Specific Manufacturer)?

Could someone pls. help me with a report that shows all "USB Devices" from a specific manufactuer?The place I can find the info manually is by choosing a asset (PC) and then Config->Hardware -> USB Devices And then the first column hold the name of ...

CHRLAU by • Engaged Sweeper III
  • 6872 Views
  • 3 replies
  • 0 kudos

Resolved! HDD changes on assets

Hi guys,I have a report that flags any changes made to the hard drives. It flags whenever an add or a remove is triggeredI am using the tblFloppyHist in order to do this.Unfortunately i am getting a lot of triggers for no reasons. please see an examb...

degett by • Engaged Sweeper II
  • 8017 Views
  • 4 replies
  • 0 kudos

Cisco date of manufacture

SELECT TOP 1000000 tblAssets.AssetID, tblAssets.AssetName, tsysAssetTypes.AssetTypename, tsysAssetTypes.AssetTypeIcon10 AS icon, tblAssets.IPAddress, Serialnumber, DATEADD(DAY,7*SUBSTRING(Serialnumber,6,2)-7, DATEADD(YEAR,96+SUBSTRING(Serialnu...

Filip_V by • Lansweeper Alumni
  • 15513 Views
  • 4 replies
  • 4 kudos

Resolved! Malware detection Security report

Trying to make some very cool for security.Looking for report which shows any admin group account logins over the last 30 days and any failed login attempts.next I would like a list of any items listed in the following• HKLM\Software\Microsoft\Window...