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

Windows 11 reporting

I'm wondering about reporting on Windows 11 devices in LanSweeper.Currently I can go off of tsysOS.OSCode = '10.0.22000', however, the tsysOS.OSName for that ID is still 'Win 10'. Using tsys.OSCode will allow me to report on Windows 11 machines, howe...

cand by • Engaged Sweeper
  • 2283 Views
  • 0 replies
  • 2 kudos

Chart: Microsoft Office 365 Versions

It took me a while to get this working, mainly due to my lack of knowledge in doing these queries. This will grab the version number of the Office 365 installation and give the total amount of clients with that version. In turn it can be used for cha...

suspect0 by • Engaged Sweeper
  • 17327 Views
  • 4 replies
  • 4 kudos

Printer Network Interfaces Database Table?

I'm trying to build a report showing all the network interfaces present across our printer fleet regardless of connection status. The individual printer asset pages can show multiple interfaces, but I can't find where this is stored to pull it into a...

ChrisParr by • Engaged Sweeper II
  • 1455 Views
  • 0 replies
  • 0 kudos

Resolved! small change to "Software: List of software by computer"

Hi, Can someone kindly help me figuring this out. i have no SQL query experience, hence this problem.The builtin report: Software: List of software by computeris for my purpose missing Fullname (instead of username) and the Company attribute from AD....

snigah by • Engaged Sweeper II
  • 3329 Views
  • 2 replies
  • 0 kudos

Resolved! Report if Credential Guard is active

Hi,I'm looking for a way to check whether Credential Guard is activated on my endpoints.Probably the best way to do this is to query the registry value:HKLM:SYSTEM\CurrentControlSet\Control\Lsa DWORD LsaCfgFlagsValue could be 0=deactivated, 1=On with...

addresses available report

I want to build a report that exclude the addresses ip assets, I have in Assets and will show me only which free addresses I ask for help in creating the REPORTThanks

GUYYES by • Engaged Sweeper
  • 3243 Views
  • 3 replies
  • 0 kudos

AD DistinguishedName of Computer object

How would I go about adding one of these fields to my current report?Here is my current report: Select Top 1000000 tblassets.AssetID, tblassets.AssetName, tsysassettypes.AssetTypename, tsysassettypes.AssetTypeIcon10 As icon, tblassets.Domain, tb...