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! Trying to display different versions of software

Here is my code so far, I copied it and thought I could just add to it to ask for columns at the top, software name and versionSelect Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon, tblAssets.AssetID, tblAssets.AssetUnique, tblAssets.AssetName...

Tholmes by Engaged Sweeper III
  • 3570 Views
  • 2 replies
  • 0 kudos

Switch & Port reports - SNMPInfo tables missing info

Hi,So I used the report found here as base...And found out there are *some* assets, that are missing from the report,more specifically information is missing in the tblSNMPAssetMac and tblSNMPInfo tables.Yet when you go to the asset's page in the we...

Maxlieb by Engaged Sweeper
  • 1855 Views
  • 0 replies
  • 0 kudos

Resolved! Webcam report, the wrong way

And then when I view it, I have to sort the view by manufacturer, type in Logitech and get all the Logitech webcams in there. Have I gone round this a long convoluted way, or is this the best?Is there a way for me to just have the Logitech sorted on ...

Tholmes by Engaged Sweeper III
  • 5667 Views
  • 3 replies
  • 0 kudos

Resolved! zerologin posted report

the report, as posted to your page shows assets that are marked with status other than active...such as destroyed, in-active etc. when one has a lot of assets in the report these should likely get filtered out so the active ones get priority in patch...

AZHockeyNut by Champion Sweeper III
  • 8712 Views
  • 5 replies
  • 0 kudos

Need help finishing a report for Failed Logons

The report I have works great (I got it from here)!! However, I would like it to show only findings with "Unknown user name or bad password." as the reason.Any help is VERY much appreciated!-JasonSelect Top 1000000 tblAssets.AssetID, tblAssets.Asse...

Russian in Report

Hi! How to use Russian in reports?For example:Select Top 1000000 tblADusers.Userdomain + '\' + tblADusers.Username As Displayname, tblADusers.Username, tblADusers.Userdomain, tblADusers.Name, 'usersm.png' As icon, tblADusers.IsEnabled As Enable...

Resolved! Asset location report with count ?

I am currently adding in floor maps to our lansweeper db and I was wondering if a computer count can be added to a report like this?Select Top 1000000 tblAssets1.AssetID, tblAssets1.AssetName, tblAssets1.DescriptionFrom tblAssets Inner Join tsysAs...

stahly8 by Engaged Sweeper III
  • 7537 Views
  • 2 replies
  • 0 kudos