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

Report auto formatter removing brackets

Creating this report:Select tblSoftwareUni.softwareName, tblAssets.AssetNameFrom tblSoftwareUni Inner Join tblSoftware On tblSoftwareUni.SoftID = tblSoftware.softID Inner Join tblAssets On tblAssets.AssetID = tblSoftware.AssetIDWhere tblSoftwareUn...

Software counts/audit

Looking to make a report that will compile the following:Name of software | Total Count of Install locations | list of computers/users it is installed for | In a certain IP LocationAny thoughts?

Resolved! Assetname not clickable

Anyone have any idea why the assetname in the report below is not clickable? Followed advise on old thread to remove the alias. Works for most reports just not this one. Any help appreciated.Select Top 1000000 tsysOS.Image As icon, tblAssets.AssetNa...

Checking MS17-010 patch is installed

We can use lansweeper to check if MS17-010 was correctly installed on windows system, follow these steps:-first add a custom File scanning into lansweeper, the file to check is '%windir%\system32\drivers\srv.sys'following the idea you can find here: ...

ufficioced by Champion Sweeper
  • 14608 Views
  • 4 replies
  • 0 kudos

Petya Vulnerability report

I'm in over my head on this one, I've been asked to create a report that will tell me which assets with the following versions of Microsoft office are missing the following KB and are vulnerable to petya ransomewareoffice pro 2007 / KB3141538Off...

dmorris by Engaged Sweeper II
  • 6558 Views
  • 1 replies
  • 1 kudos

Report Creation

Good Afternoon,I am having some trouble getting a report to produce that will show the following information:Software -Foxit Phantom PDF/Foxit PhantomPDF StandardMAC AddressLast User Logged InCurrently we've attempted to solve this problem by editing...

Tczadzeck by Engaged Sweeper II
  • 4618 Views
  • 1 replies
  • 0 kudos

Resolved! Office Hotfix

Hi all,I need a report to list the Office Hotfix. Is there any table that contains the office updates/hotfix as Windows?ThanksAlex

amutto by Engaged Sweeper II
  • 5754 Views
  • 1 replies
  • 0 kudos

User not seen in X days

Hi folks,hope someone can help.Is there, or can someone help with a report that would list AD users who have not logged on in a specific range - say 30 days?My SQL knowledge is pretty poor, so I don't know where to start in writing one myself.Thanks!...