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! Duplicates (3-4) in report please helppppp!

Hello!I tried to merge 2 reports that works well but now I get 3-4 duplicates for each entries. The report return 1000 lines instead of 400.Someone can see my problem???HELP!!!!!!!! Select Top 1000000 tsysAssetTypes.AssetTypeIcon16 As icon, tblAsse...

AlexMZetec by • Engaged Sweeper II
  • 4994 Views
  • 2 replies
  • 0 kudos

Report to find all computers with no logon data

I'm attempting to run a report to find all devices that either have Config > User Info > Last logon as blank/null or that have a logon time older than X days but i keep getting blank results. Would someone be able to assist? Thank you.I've used thi...

mlevar by • Engaged Sweeper
  • 3568 Views
  • 1 replies
  • 1 kudos

Change processes report to show opposite results

I found the below script in the forum:Select Top 1000 tblAssets.AssetName, tblProcesses.CaptionFrom tblAssets Inner Join tblProcesses On tblAssets.AssetID = tblProcesses.AssetIDWhere tblProcesses.Caption = 'OneDrive.exe'https://www.lansweeper.com/f...

William382 by • Engaged Sweeper III
  • 3095 Views
  • 1 replies
  • 0 kudos

Keep link to items when using column names

I searched the forums but could not find a solution. Using the following Select statement will allow me to click on the items in AssetName columnSelect Top 1000000 tblAssets.AssetID, tblAssets.AssetName,But if use a Column Name then the link is no ...

TomGalvin by • Engaged Sweeper
  • 3157 Views
  • 0 replies
  • 0 kudos

Reporting on low HDD space for 2 servers

Hey, I'm trying to make an alert / report for two servers in the case that they get low disk space. The report I have right now doesn't seem to care about the free space left and just shows all of the drives, as well as only showing one server instea...

Report to find out which local users are present

Good morning, I have downloaded several reports and continue to use them, thanks a lot for this.Now I would like to have a report to see which local users are present on pc or at least to know if a specific user is present.With Powershell I would use...

chart by • Engaged Sweeper
  • 2492 Views
  • 0 replies
  • 0 kudos

.Net 3.5 and .Net 4 Detail Reports

I had a requirement that we needed to know what machines had .Net 4 version installed and what release this version fell under. In addition, we needed a separate report for .net 3.5 machines and if they had an SP installed. I could not find a repor...

keys_it by • Engaged Sweeper III
  • 9306 Views
  • 2 replies
  • 0 kudos