Dear Lady's and Gents, I been asked to make a custom lansweeper report but im not really a SQL expert :). I searched multiple lansweeper posts, but didnt quite found my answer. I was looking fo...
I'm looking for a way to report on all my devices mapped drives in my environment, but I want to exclude specific drive mappings that are standard. Essentially finding users who are "going roug...
Hi, I am using the following report to get the total OS count by Windows version. The SQL query is set to only display "Active" devices. However, when clicking on the totals, the list expands and t...
Hello, I would like to create two reports to obtain all local users and which group they belong to; one for Windows servers and another for Linux servers.
Hello Several times through out the year we are asked for reports for auditing purposed to list out all the local administrators on a few of our critical systems. We have a basic report setup ...
Hi, When I search a user, it'll show basically all that is in AD for that user (email address, computer, ad groups etc). I would like to have it show their AirWatch asset info or select AirWat...
We use SCCM to deploy packages so we needed to monitor the c:\windows\ccmcache folder. We have a 10 GB policy on that folder so it is not supposed to get over 10 gigs. BUT we have many workstations t...
I am trying to expand upon the reports in Pro Tip 52 for outdated Zoom.
We would like to create similar reports for Google Chrome, Mozilla Firefox etc. I have tried making a report for...
...,
tblADusers.LockoutDate,
tblADusers.PasswordLastSet,
tblADusers.PasswordRequired
From tblADusers
Where (tblADusers.IsEnabled = 'True' And tblADusers.ADObjectID In (Select
t...